How to grant rights for remote access to a MySQL server

  1. At the MySQL server run:

mysql -u root -p mysql

  1. Once logged in, create an account:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'account_name'@'IP_address_of_Proteios_web_server' IDENTIFIED BY 'your_password' WITH GRANT OPTION;

  1. log out

mysql> exit;

  1. Check that it worked from the computer where you're going to install Proteios:

mysql -h IP_address_of_mysql_server -u account_name -p mysql

  1. If you're allowed to log in with your_password you can now proceed with the Proteios installation
Last modified 14 years ago Last modified on Sep 21, 2007, 2:16:08 PM