MySQL - Access denied - Printable Version

MySQL - Access denied - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQL - Access denied (/showthread.php?tid=532773)

MySQL - Access denied - Gogorakis - 20.08.2014

Код:

[Wed Aug 20 16:06:14 2014] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).
[Wed Aug 20 16:06:14 2014] Error (0): Function: mysql_ping called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).

Does anyone know how to fix this? The database is set up successfully..

Btw, I am not using password.

Re: MySQL - Access denied - Chilli9434 - 20.08.2014

Did you allow remote access to the database?

Re: MySQL - Access denied - Gogorakis - 20.08.2014

I suck on MySQL. Can you explain more..? How to see that? How to allow/disallow it?

Re: MySQL - Access denied - Gogorakis - 20.08.2014

Btw, it works for another server..

AW: MySQL - Access denied - Mellnik - 20.08.2014

Why in the hell would you login with user "root"????? omg
Probably root login is blocked for security reasons. Create a db and assign privileges to a new user in phpMyAdmin.

****** answers your question on how to do so...

Re: MySQL - Access denied - Gogorakis - 20.08.2014

The username was "samp_dsz" .. I tried it with this username and then I tried with the name "root"..Access denied with both of them..btw, how to change the username when I connect to localhost to build a database..?

As I said..I suck on MySQL.

Re: MySQL - Access denied - Gogorakis - 20.08.2014

I just change the username from root to gregory on the script..idk if it needs more but when I loggin it appears this:

Quote:

#1044 - Access denied for user ''@'localhost' to database 'samp_dsz'

Quote:

#define MySql_Host "localhost"
#define MySql_User "gregory" // Liveserver richtige
#define MySql_Password ""
#define MySql_Database "samp_dsz"

Re : MySQL - Access denied - www - 20.08.2014

For #define MySql_Host "localhost" use the IP adresse of MySQL host.

Re: Re : MySQL - Access denied - Gogorakis - 20.08.2014

Quote:

Originally Posted by www

For #define MySql_Host "localhost" use the IP adresse of MySQL host.

You mean 127.0.0.1?

Re : MySQL - Access denied - www - 20.08.2014

The MySQL data-base is hosted on your localhost or on a remote server?