Unable to connect Mysql server with mysql workbench

#1

Please share the procedure to connect mysql server with mysql workbench.

#2

Hi,
May I know if you are trying to connect Mysql workbench from Local to the CloudXLab server Mysql?
Below are actually the credentials you can try with.

  1. Using ip address
    mysql -h ip-10.142.1.2 -u sqoopuser -p
    Mysql : NHkkP876rp

  2. Using server name
    mysql -u sqoopuser -p -h cxln2.c.thelab-240901.internal
    Password : NHkkP876rp

If it don’t work you can’t connect.

All the best.

#3

Hi @snigdho

Mysql access is block outside the CloudxLab environment. Unfortunately you will not be able to connect via workbench

#4

I am able to connect cloud mysql database with my desktop mysql workbench after breaking the problem in two parts.
First I checked the connectivity with SSH Client application (Putty in windows) to connect the cloud system. I got the linux shell after successful connection.
In shell, command for connecting mysql database with Standard TCP/IP details has been given to connect database (we are normally doing the same procedure).

The above two parts are followed in mysql workbench as follows:

Database> Connect to database:

Connection Method: Standard TCP/IP over SSH

  1. SSH details to connect system:

a) SSH Hostname: f.cloudxlab.com
b) SSH Username: my user name provided by cloudxlab
c) SSH Password: password provided by cloudxlab

  1. Mysql server Standard TCP/IP connection:

a) Mysql hostname: cxln2.c.thelab-240901.internal
b) Mysql server port: 3306
c) Username: sqoopuser
d) Password: as provided by cloudxlab

It’s a great learning!!!