MySQL connection information

[wikiot]

Hi,
I am trying to connect to mysql using MySQL Administrator (an awesome free program). Anyway, I am not entirely sure how to connect. What is my connection info?

I have found this post http://forum.siteground.com/showthread.php?t=1283

MySQL Host Address: my website
Username: my username
Password: my password
Port: 2082

But so far it hasn't worked. What am I supposed to do to log on/

[wikiot]

ok, I don't know why I didn't add that to the bottom of the other post....anyway, I'm also wondering what access hosts mean in the mysql manager

[wikiot]

ok, I've found some info about access hosts here (http://www.cpanel.net/docs/cpanel/)

I think I need to add my own personal computer's ip to the access hosts...so I did this, but I still cannot connect to the database with mysql admin

[kenny]

To be able to remotely access your MySQL databases, you have to allow access to the databases from your computer. To do so, visit whatismyip.com, and copy your IP address. Then, log in to cPanel, go to MySQL Databases and add your IP to the list of allowed hosts.

The details to use for connecting to the database are:

MySQL Username: [same as cPanel username]
MySQL Password: [same as cPanel password]
MySQL Host: yourdomain.com OR servername.com OR server.I.P.address (these can be found in the Manage Accounts section in your customer area on siteground.com)

[wikiot]

what port should I use? When I open mySQL admin, there is a port box which has 3306 in it.

[wikiot]

when I tried to connect with the default port, I got the following error:


Could not connect to the specfied instance

MySQL error Number 1045
Access denied for user 'myusername'@blk-22-127-126.eastlink.ca' (using password:YES)

If you want to chec the network connection, please click the Ping button.


But I am able to ping the server no problem.

[kenny]

In this case, you can try creating a MySQL user via cPanel -> MySQL databases, then grant privileges to the newly created user for the database you need to be able to access, and use it for connecting remotely. Make sure you have added the IP address of your computer to the list of allowed hosts, and mind the username -- it will have the form cpuser_dbuser: cpuser will be your cpanel username, dbuser is the MySQL username you used when creating it.

[wikiot]

kenny,

Awesome. I really apppreciate your help. I tried with a new user and I was able to connect. So, I guess the problem was the user I was using before.

thanks again

[ducomagic]

Hi,

I'm having the problem mentioned here.

Could not connect to the specfied instance

MySQL error Number 1045
Access denied for user 'myusername'@CPE-xxx-xxx-xxx.xxx.domain.com.au' (using password:YES)

Have tried all the suggestions here but to no avail. Any ideas??

Thanks,
Rodney

[kenny]

@ducomagic: Most likely, you have not added your IP address to the list of allowed hosts. To resolve this, visit http://whatismyip.com/, copy the IP address, then go to cPanel -> MySQL Databases and add it to the list of allowed hosts.

Also, try using a separate MySQL user credentials (create a MySQL user via cPanel, and grant privilegest to the user for the databases you need to manage remotely).

[ducomagic]

Thanks Kenny, but I have performed both of these tests, but still no success as yet.

R

[ducomagic]

Ok - just further to my last post. I went through the whole process again and this time when I created a user, I noticed that the username had my main account user name added to it automatically as a prefix. Thus when I entered this username into MySQL admin - all good.

Thanks, appears to be working now.

[holmancarey]

Yeah, that's a funny thing fantastico does to ensure the databases made by your account on the server hosting your site don't effect any of the other users databases also hosted on that server.