mysql_connection() Access Denied

[Nephryrinn]

My mysql_connect() statement gives me this error

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'geoip'@'localhost' (using password: YES) in /home/neph/public_html/index.php on line 4

mysql_connect() failed: Access denied for user 'geoip'@'localhost' (using password: YES)

 

I've already tried using 'geoip', 'neph_geoip' and 'neph', all of them gives me Access Denied.

 

A thing I found is that I can't create a new database from phpMyAdmin, even with my 'neph' (account with I signed in). Using MySQL query "CREATE DATABASE test", it returns me "#1044 - Access denied for user 'neph'@'localhost' to database 'test'". However I was able to create Db's using cPanel MySQL Page, but they all return size 0KB, when I'm sure they have data in it.

 

Maybe something wrong with my user's permitions?

 

I can provide souce code for my script if nedeed so.

 

 

 

 

Account Details:

Username: neph

Domain: neph.heliohost.org

 

Thanks for taking time to help me.

Forgive any misspelling or grammar error please.

[Wizard]

Both your database name and your MySQL username is prefixed with "neph_". Are both of them set with this in mind?

[Nephryrinn]

Oh gosh, please forgive me for being such a moron!

 

I just forgot to use 'neph_' prefix in database name. This was causing all this problem.

 

Thank you so much for this almost instantaneous reply.

 

One last thing: how I can delete a database if DROP DATABASE is disabled?

 

Forgive me again for wasting your time.

[Wizard]

Use cPanel's MySQL config: http://stevie.heliohost.org:2082/frontend/x3/sql/index.html