By default, remote access to MySQL database servers is disabled as a security measure. For this reason, when you want to utilize an existing MySQL DB, as part of the the Nolio Center installation you have to start by providing remote access to the database.
The following steps will enable selected users to remotely connect to a MySQL database.
1.Connect to the database DB with the root mysql - u root -p and enter the password when requested.
2.Type:
mysql> grant all on *.* to 'root'@'%' identified by 'PASSWORD';
mysql> quit.