M3Server Technical Blog Mini Howto Connecting to Database via MySQL Workbench

Connecting to Database via MySQL Workbench



You will need to open a Support Ticket with M3 Server.
CLICK HERE to open ticket.

M3 Server will need your IP.
CLICK HERE and you will be provided with your IP.
Note: We need the IP that our site reports so it can be whitelisted. IP should be static, not dynamic, or security will be weakened.

Once your IP has been whitelisted use these steps as follows:

1. Open MySQL Workbench

2. Click the Add icon

Screen Shot 2014-07-03 at 11.20.31 AM

3. Enter a connection name

Screen Shot 2014-07-03 at 11.36.56 AM

4. Select Standard (TCP/IP) as the connection method

5. Click the Advanced tab

Screen Shot 2014-07-03 at 11.39.07 AM

6. Check the box Use the old authentication protocol.

Screen Shot 2014-07-03 at 11.41.05 AM

7.  Clich the Parameters tab

Screen Shot 2014-07-03 at 11.41.56 AM

8. Fill in this information accordingly.

Screen Shot 2014-07-03 at 11.46.54 AM
Hostname yourserver.m3xs.net
Port 3306
Username Database Username
Password: Database Password

9.  Click store in keychain and you will be prompted to enter Database Password

Screen Shot 2014-07-03 at 11.46.34 AM

10. Click OK and you should now be able to connect to your Database

NOTE:
Using MySQL client from the command line, may give you the result:

Warning: Using a password on the command line interface can be insecure.
ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option ‘secure_auth’ enabled)

To bypass this, use the command line option:
–skip-secure-auth

The command line option will then resemble the following:
mysql –skip-secure-auth -u’yourdbusername’ -p’yourpassword’ -h v2505.m3xs.net