How to access database?

[kbun]

hi all,

i've tried to access my database that i've already created but it come with this
error message

could connect to the specified instance 2003


Server Host: 'www.example.com'
username: 'username'
password: 'password'
database: 'dbname'

Please help!

[cPanelMattCurry]

Kbun,

I am sorry to hear that, well I would need a little bit of information before we could proceed. First, is this you trying to connect locally or remotely? If you are having issues with it remotely here is a link,http://forums.cpanel.net/f4/how-enab...html#post97521.

However, if it is local that can be a different story. You would need to make sure that you have added that user to your database via the cPanel interface.

This can be achieved as the user via : cPanel -> Databases -> MySQL Database


I hope this is the information you need.

Thank you,
Matthew Curry

[kbun]

I'm trying to remote access the database using MySQL Query Tool or using php code to access it.
In my control panel i created database name 'testdb' and a user name 'testuser'
i assigned full access control to this user.

But, everytime i try to connect to the database server it's always failed.

is it correct that i used www.mysite.com.au as server host?

Please help.
Jim

[kbun]

This the error message when i try to connect to the database ..

Warning: mysqli::mysqli() [mysqli.mysqli]: (00000/1130): Host 'ares.instanthosting.com.au' is not allowed to connect to this MySQL server in /home/fre47098/public_html/index.php on line 2
Connect failed: Host 'ares.instanthosting.com.au' is not allowed to connect to this MySQL server

[cPanelDavidG]

This the error message when i try to connect to the database ..

Warning: mysqli::mysqli() [mysqli.mysqli]: (00000/1130): Host 'ares.instanthosting.com.au' is not allowed to connect to this MySQL server in /home/fre47098/public_html/index.php on line 2
Connect failed: Host 'ares.instanthosting.com.au' is not allowed to connect to this MySQL server

Is this script that is giving this error on the same server as cPanel/WHM?

[kbun]

Hi,
problem solved, i can connect my database now...

THANKS A BUNCH....

Jim

[Spiral]

Server Host: 'www.example.com'
username: 'username'
password: 'password'
database: 'dbname'

Please help!

Some beginner configure tips for Cpanel based servers running MySQL:

Except in more rare cases where the database might be a remote server,
the server hostname to use in your scripts is almost always going to be
named "localhost" so use that instead of "www.example.com" above.

On cpanel systems, your database name and database username are both
prefixed with your main Cpanel account login so if your login name to
your cpanel account were "james" then the above example you wrote
would look like the following in your script settings:

Server Host: 'localhost'
username: 'james_username'
password: 'password'
database: 'james_dbname'

Hope that helps!

PS: Aside from the place in your control panel to setup MySQL databases,
there is also an interface called 'phpMyAdmin' that you can use to directly
access and work on the contents of your databases.

[kbun]

Hi spiral,

You are right everything work fine after i replace the Example Web Page with local host ...

Thank you very much for your advice.

Jim