Nolio Official KB: How do I enable remote login to MySQL Database?

Document created by MaryGreening on Jul 8, 2014
Version 1Show Document
  • View in full screen mode
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.

 

This document was generated from the following discussion: Nolio Official KB: How do I enable remote login to MySQL Database?

Attachments

    Outcomes