FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Mysql problem





bluffmango
hi i created a new database and user name & password for that database but when i used it with the script i wanted it was connected to the database but gave the following error:

Error: Could not select database. Check that the database exists and that the user has permission to use it.



wats wrongggg?
mathiaus
And your using Cpanel/DAusername_databasename and Cpanel/DAusername_databaseusername ? (Replace Cpanel/DAusername with your username for either Cpanel or DA)
bluffmango
i dont really get wat u r saying

i know abt cpanel username and cpanel password wats but DA???

i m using

DATABASE NAME:

CpanelUsername_databasename

Database username:

CpanelUsername_databaseusername

HOST

localhost
mathiaus
DA is Direct Admin which is used instead of Cpanel on server 2. I wasn't sure which you used at the time.

After you created a user did you add it to the database?
check -> Cpanel -> mysql databases ->
find the database you created. Under that it should say 'users in this database' is your username there?
If all the above is Ok please post the code your using to connect to the database
bluffmango
The matter has been resolved thanks.. alot
Related topics
mysql problem
ALTER TABLE mySQL problem.
mysql problem
What is useful way in this php+mysql problem?
MySQL problem...
MySQL HELP!!
MySQL problem (as usual)
MySQL problem :'(
MySQL Problem
mysql problem
mySQL problem
header already sent? (and now introducing a mysql problem)
server -4 Mysql problem
MySQL problem - Can't insert stuff in to database
This topic is locked: you cannot edit posts or make replies.    Frihost Forum Index -> Support and Web Hosting -> Web Hosting Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.