Once you've created a new MySQL deployment through the ScaleGrid console, you can easily connect to it using either a MySQL client or through your application.
Skip to the next step if you've already configured your network settings.
Ensure that your network settings allow the client machine to connect to port 3306 on instances of the MySQL deployment by setting up the following:
- If your deployment is open to the Internet, ensure that your client is whitelisted either under the Cluster Firewall Settings or under the Account Firewall Settings on the ScaleGrid console. Whether your deployment is open to the Internet or not depends on the Cloud Profile settings.
- If you cluster is NOT open to the Internet, then the network settings need to be determined from the VPC and Security Group settings of the cloud provider themselves. Refer to the documentation of your cloud provider to find out the correct configuration required to ensure connectivity.
In order to connect to your MySQL deployment, you must first create a new user, as it is highly recommended that you do not use the sgroot user that was created with your cluster. Follow these steps to create a new user for your MySQL deployment:
There are various ways to connect to your MySQL database, and you can choose from the following methods below:
- Connect MySQL via the Command Line
- Connect MySQL from your Application
- Connect via MySQL Workbench GUI Tool
- Can't connect to MySQL server on
Ensure that your client IP is white-listed in the Firewall rules configuration through ScaleGrid console. Please note that if you have created any account level firewall rules, they still need to be applied for your deployment from the Firewall Rules button in the Overview page of your deployment as shown below.
- ‘Access Denied’ for user [email protected](using password: YES) occurred while trying to connect to host:
This will be typically a username and password issue. Ensure that the MySQL user you have created has access to connect to MySQL server from external clients. The host component of the username should be either % OR IP address of the client from where you are trying to connect. Valid user names are [email protected]% , [email protected] etc.
Updated about a year ago