SA-MP Forums

Go Back   SA-MP Forums > SA-MP Server > Server Support

Reply
 
Thread Tools Display Modes
Old 03/12/2013, 11:33 PM   #1
Mattakil
Gangsta
 
Mattakil's Avatar
 
Join Date: Jan 2012
Location: Canada
Posts: 691
Reputation: 15
Default MYSQL Access Denied with right user and pass

my mysql denies the connection on localhost, im positive I've got the correct password and the account can access the database, i've tested in phpmyadmin.

Anyone know what can cause this?

Code:
Tue Dec 03 18:34:01 2013]      Logging Started
[Tue Dec 03 18:34:01 2013] -------------------------
[Tue Dec 03 18:34:01 2013] Function: mysql_init executed with result: "0".
[Tue Dec 03 18:34:01 2013] Error (0): Failed to connect. Access denied for user 'USER@'localhost' (using password: YES).
[Tue Dec 03 18:34:01 2013] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'USER'@'localhost' (using password: YES).
Mattakil is offline   Reply With Quote
Old 03/12/2013, 11:38 PM   #2
Mattakil
Gangsta
 
Mattakil's Avatar
 
Join Date: Jan 2012
Location: Canada
Posts: 691
Reputation: 15
Default Re: MYSQL Access Denied with right user and pass

NOTE: If I tried ROOT with pasword "" it denied access USING PASSWORD(YES)...I dunno how tf that happens lol
Mattakil is offline   Reply With Quote
Old 03/12/2013, 11:46 PM   #3
Leak
Little Clucker
 
Join Date: Nov 2013
Posts: 4
Reputation: 1
Default Re: MYSQL Access Denied with right user and pass

Got Teamviewer matt? if not maybe skype i can help out!
Leak is offline   Reply With Quote
Old 03/12/2013, 11:48 PM   #4
Mattakil
Gangsta
 
Mattakil's Avatar
 
Join Date: Jan 2012
Location: Canada
Posts: 691
Reputation: 15
Default Re: MYSQL Access Denied with right user and pass

PM me please :P
Mattakil is offline   Reply With Quote
Old 04/12/2013, 12:25 AM   #5
Mattakil
Gangsta
 
Mattakil's Avatar
 
Join Date: Jan 2012
Location: Canada
Posts: 691
Reputation: 15
Default Re: MYSQL Access Denied with right user and pass

Couldnt figure out, this is really starting to piss me off D:
Mattakil is offline   Reply With Quote
Old 04/12/2013, 12:51 AM   #6
Mattakil
Gangsta
 
Mattakil's Avatar
 
Join Date: Jan 2012
Location: Canada
Posts: 691
Reputation: 15
Default Re: MYSQL Access Denied with right user and pass

sorry for the triple fucking post, but My password is returning "null" when there is no pass entered.
Mattakil is offline   Reply With Quote
Old 04/12/2013, 09:55 AM   #7
ReApZ
Big Clucker
 
ReApZ's Avatar
 
Join Date: Nov 2013
Location: The Third Planet
Posts: 117
Reputation: 7
Default Re: MYSQL Access Denied with right user and pass

try to do it as root
not a user but root
__________________
__________________________________________________ _
>~~~~~~~~~~~My Works~~~~~~~~~~<
~~~~~~~~~~[Map]Glass TDM~~~~~~~~
~~~~~~~~~[Map]Vip-Lounge~~~~~~~~~
~~~~~~~~[Map]Loop-RaceTrack~~~~~~~
~~~~~~~~~~[Map]Derby~~~~~~~~~~
~~~~~~~~~[Map]PartyLounge~~~~~~~~
~~~~~~[Tutorial]Vps Server Hosting~~~~~~
Left Samp
ReApZ is offline   Reply With Quote
Old 04/12/2013, 03:17 PM   #8
BizzyD
Gangsta
 
BizzyD's Avatar
 
Join Date: Jan 2011
Location: Home
Posts: 880
Reputation: 66
Default Re: MYSQL Access Denied with right user and pass

I can try to help you through teamviewer if you want.
Just give me a PM with your contact information
__________________
We never fail, we only shine with brilliance. One king one faith one religion. And if you hear me come and join the revolution
BizzyD is offline   Reply With Quote
Old 04/12/2013, 05:21 PM   #9
Astralis
Guest
 
Posts: n/a
Default Re: MYSQL Access Denied with right user and pass

Quote:
Originally Posted by Mattakil View Post
my mysql denies the connection on localhost, im positive I've got the correct password and the account can access the database, i've tested in phpmyadmin.

Anyone know what can cause this?

Code:
Tue Dec 03 18:34:01 2013]      Logging Started
[Tue Dec 03 18:34:01 2013] -------------------------
[Tue Dec 03 18:34:01 2013] Function: mysql_init executed with result: "0".
[Tue Dec 03 18:34:01 2013] Error (0): Failed to connect. Access denied for user 'USER@'localhost' (using password: YES).
[Tue Dec 03 18:34:01 2013] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'USER'@'localhost' (using password: YES).
You need to allow connections from the server IP, to do this in easiest way, if you are root admin in phpmyadmin, go on add users > "USER" > choose: allow connections from any host, enter your password also and click on check all the privileges. Check again for these details in your script, restart the server and it should work.
  Reply With Quote
Old 04/12/2013, 08:36 PM   #10
Mattakil
Gangsta
 
Mattakil's Avatar
 
Join Date: Jan 2012
Location: Canada
Posts: 691
Reputation: 15
Default Re: MYSQL Access Denied with right user and pass

I tried as root, stated it, and its on a localhost...so the IP is the same as the sql server, I also did config it to localhost as well as trying to allow from ALL.
Mattakil is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access denied for user 'root'@'localhost' (using password: YES). munsee Server Support 7 29/06/2013 05:10 AM
MySQL permission issues/access denied V1ceC1ty Scripting Help 7 19/12/2012 03:09 AM
File access denied dadsy Client Support 1 08/07/2010 06:59 PM
SA-MP .3a file access denied tjskier247 Client Support 1 22/12/2009 09:54 AM


All times are GMT. The time now is 02:08 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.