how do connect to mysql using the mysql queary brouser edit 7/17/09

[edwardthefma]

how do connect to mysql on helo host using the mysql query brouser? hear are some screen shots

please tell me wat i am doing wrong

 

[Ashoat]

Host: 65.19.143.2:2086

Username: the MySQL username you have created to whom you gave full permission to access the below database

Database: the MySQL database you've created

Password: the above username's password

 

Make sure that you've added your home IP to the MySQL remote access list in your cPanel.

[edwardthefma]

Host: 65.19.143.2:2086

Username: the MySQL username you have created to whom you gave full permission to access the below database

Database: the MySQL database you've created

Password: the above username's password

 

i got it thx XD XD

[WyvernDragon501]

i have the same problem also and fixed it already.... but now, my problem is, i cannot create a new schema... it says an error MySQL Error Number 1044...... please help me..... i cannot create a new database..... i am using MySQL Query Browser....

 

 

 

 

Edit:

 

i figure out now why.... i have to create a new database/schema in my cpanel.... after that, i can now add tables and edit data using the query browser..... thankss.....

[Ashoat]

Sentences are supposed to end with one period, not six.

[norincourt]

Sentences are supposed to end with one period, not six.

 

 

I'm not sure if this is the way to get help on the same topic but I'll try - and if I'm not doing it right

please let me know.

 

I'm having a similar problem connecting to MySQL. I'm also using Query Browser following the earlier instructions to use Server Host 65.19.143.2 Port 2086, my userid which is my

cpanelID_krp, my password (use the same one for both cpanel and database) and I leave the schema blank.

 

The error I get says Query Browser "could not connect to the specified instance", MySQL error 2013

"lost connection to mySQL server during query.

 

pinging looks good (22ms).

 

I set my remote mysql database on cpanel to my address using a % for the last node, eg: 192.168.1.%

 

Any suggestions as to what I'm doing wrong?

 

Thanks,

 

Ken