How to grant rights for remote access to a MySQL server

1. At the MySQL server run:

mysql -u root -p mysql

2. 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;

3. log out

mysql> exit;

4. 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

5. If you're allowed to log in with your_password you can now proceed with the Proteios installation