mariusv.com

Here is a small tutorial if you want to grant remote access to a DB on your server.

First login trough SSH on your server and get access to you mysql

$mysqladmin -u XXX password  XXX

Note: that 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)

After that to activate your setting type

FLUSH PRIVILEGES;

And exit your mysql

$mysql>quit