If you want to grant remote access privileges to a DB on your server,Please look fllow.
First login trough SSH on your server and get access to you mysql
$mysqladmin -u xxx password xxx
Note: the db user and db passwd are your database username and database password
GRANT ALL PRIVILEGES ON db_base.* TO db_user @’%’ IDENTIFIED BY ‘db_passwd’;
You can also grant accesss to a specific IP adress
GRANT ALL PRIVILEGES ON failserv_example.* TO failserver@’xx.xx.xx.xx’ IDENTIFIED BY ‘db_passwd’;
(where x is your own remote IP)
Refresh privileges,After that to activate your setting type
FLUSH PRIVILEGES;
And exit your mysql
$mysql>quit
