edwardthefma Posted July 17, 2009 Share Posted July 17, 2009 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 Quote Link to comment Share on other sites More sharing options...
Ashoat Posted July 17, 2009 Share Posted July 17, 2009 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. Quote Link to comment Share on other sites More sharing options...
edwardthefma Posted July 17, 2009 Author Share Posted July 17, 2009 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 Quote Link to comment Share on other sites More sharing options...
WyvernDragon501 Posted July 30, 2009 Share Posted July 30, 2009 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..... Quote Link to comment Share on other sites More sharing options...
Ashoat Posted July 30, 2009 Share Posted July 30, 2009 Sentences are supposed to end with one period, not six. Quote Link to comment Share on other sites More sharing options...
norincourt Posted November 13, 2009 Share Posted November 13, 2009 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.