manage access to the database remotely

In this short Howto, want to show you how to grant remote access to a DB on your server local or remote 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


And exit your mysql

Please shareShare on Facebook0Share on Google+0Tweet about this on TwitterShare on LinkedIn0Share on Reddit0Digg thisShare on StumbleUpon0Share on VKBuffer this page