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.
And your using Cpanel/DAusername_databasename and Cpanel/DAusername_databaseusername ? (Replace Cpanel/DAusername with your username for either Cpanel or DA)
i dont really get wat u r saying
i know abt cpanel username and cpanel password wats but DA???
i m using
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
The matter has been resolved thanks.. alot