Unable to connect to the database

K

kamdehal

Verified User
Joined
May 12, 2005
Messages
7
Location
UK
Hi guys i searched the forums but couldnt find out anything to solve my problem.

I've just created my first database from the cpanel, then tried to connect to it through toad for mysql and mysql turbo manager with no luck at all.

Heres what i typed at the connection window for example:

username:username_user

password: xxxxx (made this diff to my account pw)

host: 209.xx.xxx.xx

database: username_dbname

port:2222

It attempts to connect then freezes or sometimes displays unable to connect to database, lost connection to MySQL server during query.

Can anyone plz help... :confused:
 
is that not the port the ip address is on, assuming everyone has that port.

Or have i misunderstood
 
the port 2222 is the port to connect to directadmin by defaut. (yourdomain.com:2222 -> DirectAdmin)


Usually, mysql is on the port 3306
 
that brings up the error message:
Access denied for user (Using password: YES)

any ideas...
 
kamdehal said:
that brings up the error message:
Access denied for user (Using password: YES)

any ideas...
Click to expand...

with what user did you try to connect ?
 
the user i created along with the database, i entered the user in after the main user like this:

username_user

username_databasename

i put this into toad for mysql to connect to the database.

Is this correct
 
i've added the access host, my ip addy without http:// and the port is seperate 3306, its denying my user permission.

I mean i've granted the user permission through the mysql management, by selecting yes.

Im using a non command line sql management prog, toad and turbo manager.

I mean can anyone help this is so annoying...
 
just wondering guys im using 101sitehosting, free web host but paid for domain reg,

could the reason be free web hosts dont allow 3rd party progs to access the mysql database.
 
Yes, it could be that MySQL will not allow any connections other than localhost or 127.0.0.1
However it is not the default with DirectAdmin.
 
You must log in or register to reply here.
Back
Top