Connecting to online database using MySQL Query Browser
Date: 02/21/08
(MySQL Communtiy) Keywords: mysql, browser, database, sql, web
Hey all
I'm having difficulties connecting to an online database.
I uploaded it online using the webhost's database manager.
As I would need update the database very frequently, therefore going through the webhost way (using the database manager to update) is pretty troublesome... I thought of connecting to the database directly from MySQL query browser.
So I have the following details (they are all correct, as given and checked by webhost):
Database name
Username
Password
Server IP
When I start up MySQL query browser, it shows me this "Connect to MySQL Server Instance" window, prompting me for:
Stored Connection (i filled it up with 'nameofdatabase' @ 'server IP')
Server Host (i filled it up with 'server IP')
Port (it's 3306 by default, so i left that number there)
Username (i filled it up as given by webhost)
Password (self explanatory, filled that up too.)
Default Schema (i filled it up with database's name)
After filling all those up, I SHOULD be able to connect to my database. Instead, I keep getting this error:
"Access violation at address 00342F02 in module 'libmysql.dll'. Read of address 00000004."
What exactly does this error mean??? I really need to connect to the database ASAP. Would appreciate any form of help. Thanks!
Source: http://community.livejournal.com/mysql/125471.html