MySql Driving me nuts, any experts here? - GoFuckYourself.com

RayVega · 10-25-2010, 07:01 AM

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.

BittieBucks Eric · 10-25-2010, 07:04 AM

Quote:

Originally Posted by RayVega

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)

UniqueD · 10-25-2010, 07:08 AM

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.

Klen · 10-25-2010, 07:15 AM

I refuse to answer anything related to godaddy.

redwhiteandblue · 10-25-2010, 07:16 AM

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.

HomerSimpson · 10-25-2010, 07:18 AM

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)

CyberHustler · 10-25-2010, 07:19 AM

I'd switch hosts... Move to amerinoc (see sig). You wouldn't need to come to GFY for help with them.

BittieBucks Eric · 10-25-2010, 07:21 AM

Quote:

Originally Posted by redwhiteandblue

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.

Indeed, that's another option.

stocktrader23 · 10-25-2010, 07:23 AM

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.

Adraco · 10-25-2010, 07:35 AM

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.

Dido · 10-25-2010, 07:50 AM

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.

woj · 10-25-2010, 08:11 AM

Quote:

Originally Posted by BittieBucks Eric

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)

</thread>

and yea, godaddy is not the best host choice

chronig · 10-25-2010, 08:14 AM

lol @ dedicated server with godaddy :|

Davy · 10-25-2010, 09:44 AM

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

directfiesta · 10-25-2010, 09:54 AM

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

With Cpanel, you would be done a while ago

10-25-2010, 07:01 AM	#1
RayVega Confirmed User Industry Role: Join Date: Jul 2004 Location: New York ICQ#348007554 Posts: 4,212	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. __________________ Ray "The Don" Vega Managing Director Private Equity Fund [email protected]

10-25-2010, 07:16 AM	#5
redwhiteandblue Bollocks Industry Role: Join Date: Jun 2007 Location: Bollocks Posts: 2,793	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. __________________ Interserver unmanaged AMD Ryzen servers from $73.00

10-25-2010, 07:18 AM	#6
HomerSimpson Too lazy to set a custom title Industry Role: Join Date: Sep 2005 Location: Springfield Posts: 13,826	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) __________________ Make a bank with Chaturbate - the best selling webcam program Ads that can't be block with AdBlockers !!! /// Best paying popup program (Bitcoin payouts) !!! PHP, MySql, Smarty, CodeIgniter, Laravel, WordPress, NATS... fixing stuff, server migrations & optimizations... My ICQ: 27429884 \| Email:

10-25-2010, 07:23 AM	#9
stocktrader23 Let's do some business. Industry Role: Join Date: Jan 2003 Location: The dirty south. Posts: 18,781	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. __________________ Hands Free Adult - Join Once, Earn For Life "I try to make a habit of bouncing my eyes up to the face of a beautiful woman, and often repeat “not mine” in my head or even verbally. She’s not mine. God has her set aside. She’s not mine. She’s His little girl, and she needs me to fight for her by keeping my eyes where they should be."

10-25-2010, 07:35 AM	#10
Adraco Confirmed User Industry Role: Join Date: May 2009 Location: Onboard an airplane around the globe Posts: 3,735	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. __________________ ---------------------------------------------------------------------------------- The truth is not affected by the beliefs, or doubts, of the majority.

10-25-2010, 07:08 AM	#3
UniqueD Confirmed User Industry Role: Join Date: Aug 2004 Location: Barcelona Posts: 1,022	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.

10-25-2010, 07:15 AM	#4
Klen Industry Role: Join Date: Aug 2006 Location: Little Vienna Posts: 32,235	I refuse to answer anything related to godaddy.

10-25-2010, 07:19 AM	#7
CyberHustler So Fucking Banned Industry Role: Join Date: Feb 2006 Posts: 26,062	I'd switch hosts... Move to amerinoc (see sig). You wouldn't need to come to GFY for help with them.

10-25-2010, 07:50 AM	#11
Dido Confirmed User Industry Role: Join Date: Sep 2006 Location: Netherlands Posts: 217	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. __________________ Dido ADAMO Advertising - Your ULTIMATE traffic partner! If you need traffic or have traffic, we'd love to help you make the best out of it! ICQ:24209500 - Skype:diederikvanschaik

10-25-2010, 08:14 AM	#13
chronig Registered User Industry Role: Join Date: Oct 2009 Posts: 2,653	lol @ dedicated server with godaddy :\|

10-25-2010, 09:44 AM	#14
Davy Confirmed User Industry Role: Join Date: Apr 2006 Location: Germany Posts: 4,323	Maybe you cannot use localhost with Godaddy? Just guessing. I did not even know they offered dedicated servers. shuddering __________________ --- ICQ 14-76-98 <-- I don't use this at all

10-25-2010, 09:54 AM	#15
directfiesta Too lazy to set a custom title Industry Role: Join Date: Oct 2002 Location: Montreal, Quebec Posts: 29,617	http://www.thewebhostinghero.com/tut...ddy-mysql.html With Cpanel, you would be done a while ago __________________ I know that Asspimple is stoopid ... As he says, it is a FACT ! But I can't figure out how he can breathe or type , at the same time ....