Jump to content

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


edwardthefma

Recommended Posts

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.

Link to comment
Share on other sites

  • 2 weeks later...

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.....

Link to comment
Share on other sites

  • 3 months later...
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

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...