MySql Driving me nuts, any experts here?
 

Have a dedicated server with Godaddy running linux and apache with mysql. I'm trying to write a simple database app in PHP and consistently get:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'blahblah'@'localhost' (using password: YES) in /home/public_html/global/database.php on line 85


I've tried everything. Double checked everything, same response. I am positive the user is permissioned, it's my root user [Blocked here]. I've also created users specifically for this database and in all cases I get this message. it is making me CRAZY!

Anyone have suggestions, c'mon time to flex your programming muscle. Any help would be really appreciated.

1. you have the permissions fucked up even though you are positive they are correct

2. you have the wrong password

3. you are using the wrong host. localhost might not be the correct host to use(can also be a permission problem)

I think localhost is default on godaddy db's, id say its something else, if you are absolutely positive its not the user data, then maybe a fuck up on their end.

I refuse to answer anything related to godaddy.

I vaguely recall MySQL giving the "access denied" error when you use the wrong database name or something, so check that the database is actually called what you think it is.

first, run away from godaddy

then check again if the user you have created has rights to read/write/modify the database (that's the most common problem)

Indeed, that's another option.

Haven't seen GoDaddy hosting in ages. In some control panels you can name a database xxx but the name they set it up under is prefix_xxx . If you don't put that right it will give the error you describe.

Godaddy's databases are named: something.godaddyservername.com
I had a few mainstream sites there a number of years ago, and I vaguely remember them not using 'localhost' but instead all MySQL databases are run vie their own system and name calling.

But if you do not want to trouble yourself with shit like this, get yourself a real host, save some money and get help when needed. Host with the best, host with Amerinoc right here. They will even move your existing site for you, so you can be up and running with them, trouble free in a few hours.

Check the permissions in your mysql database (it's called mysql), check the tables 'user' and 'db'. Make sure you've got everything set correctly, then reload privs with FLUSH PRIVILEGES;
(Note that in the db table, the fields 'host' and 'user' should correspond literally with the fields in the user table.)

That way you should be able to access your database.

</thread>

and yea, godaddy is not the best host choice :2 cents:

lol @ dedicated server with godaddy :|

Maybe you cannot use localhost with Godaddy?
Just guessing.
I did not even know they offered dedicated servers. *shuddering*

http://www.thewebhostinghero.com/tut...ddy-mysql.html

With Cpanel, you would be done a while ago :2 cents: