mariusv.com

Watch as I awkwardly stumble through life

Grant remote access to MySQL

Posted by Marius Voila on February 17, 2010 in London, U.K . — 0 comments This post contains 120 words

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