manage access to the database remotely


Please shareShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInShare on RedditDigg thisShare on StumbleUpon

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