manage access to the database remotely

by
Share this Article: Facebook0Google+0Twitter0LinkedIn0Reddit0Pinterest0StumbleUpon0Digg

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

FLUSH PRIVILEGES;

And exit your mysql

mysql>quit

For questions please refer to our Q/A forum at : http://ask.unixmen.com/

Share this Article: Facebook0Google+0Twitter0LinkedIn0Reddit0Pinterest0StumbleUpon0Digg