MySQL - Access denied
#1

Код:
[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.
Reply
#2

Did you allow remote access to the database?
Reply
#3

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

Btw, it works for another server..
Reply
#5

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...
Reply
#6

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.
Reply
#7

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"

Reply
#8

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

Quote:
Originally Posted by www
Посмотреть сообщение
For #define MySql_Host "localhost" use the IP adresse of MySQL host.
You mean 127.0.0.1?
Reply
#10

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


Forum Jump:


Users browsing this thread: 2 Guest(s)