MySQL on CPanel and connection string...

[U7Development]

Hi!. first of all, this is not Qt framework related so please excuse me...

Has someone managed to connect to a CPanel MySql Database ?
I don't get it.. I don't know what is the domain name and port... it is using phpMyAdmin.

I tried to use:

QString odbc_cfg = "Server=u7.cl:3306;"
                      "Uid=u7cl_master;"                
                      "Pwd=$$Mas7eR$$;"            
                      "Database=u7cl_elearn;"
                      "MULTI_HOSTS=1";

with no success... Error: Can't connect MySQL Server on u7.cl

[jsulm]

@U7Development I hope this connection string does not contain real credentials...

[U7Development]

@jsulm oops they are... By the way I trust you

[jsulm]

@U7Development You should not :-) You should not trust anybody on the Internet.
How do you actually connect? Can you show the code? Do you have proper error handling?

[U7Development]

@jsulm thanks so much for that... indeed you are right, but you need to know that I would never show credentials for real company, the above credentials are test based.. if someone get connected, there will be nothing to explore..

This is the string for connection:

QString odbc_cfg = "Server=u7.cl:3306;"
                      "Uid=u7cl_master;"                
                      "Pwd=$$Mas7eR$$;"            
                      "Database=u7cl_elearn;"
                      "MULTI_HOSTS=1";

Password and UID is fine, but this DB is hosted on a Web Hosting using CPanel... so I really don't know what is the server name for it...

For instance, previously I have used a dedicated server for this, this server has a dynamic dns service so I login using it and respective port... on CPanel I have no idea...

Thanks again

[SGaist]

Hi,

What exact error do you get ?

[JonB]

@SGaist
He originally said:

Error: Can't connect MySQL Server on u7.cl

and also

so I really don't know what is the server name for it...

So where does he get his Server=u7.cl:3306; from? :)

[U7Development]

@JonB That is my web site where CPanel is..

[U7Development]

I have created an account on mariaclusters.com it uses phpMyAdmin too...

On the top center of the screen there is an url with a port number..

I tried those values on my connection string but still won't connect..

QString odbc_cfg = "Server=mariadb-13914-db.mariadb-13914:13952;"
                      "Uid=master;"                
                      "Pwd=$$Mas7eR$$;"            
                      "Database=dbelearn;"
                      "MULTI_HOSTS=1";

**Update !:
Now i managed to connect... the server was:
mariadb-13914-0.cloudclusters.net

Thanks for the help!**

[Bonnie]

You've posted too much private information bro!