Originally Posted by cecilchamp
The following error comes up when I use phpGrid. I've seen this error on the Internet several times but no one seems to have a decent solution to it. Any ideas?
Warning: mysqli_real_connect(): (28000/1045): Access denied for user 'root'@'localhost' (using password: NO) in /var/www/html/phpGrid_Enterprise/server/adodb5/drivers/adodb-mysqli.inc.php on line 113
Error: Could not connect to the database
Oh come now! I just did a search for "'Access denied for user 'root'@'localhost'" and got 417,000 results... pick one!
Answer: Configure it to use the mysql 'root' user's password.
(or any valid mysql user/pass combination with access permission to your database).
On the off-chance that you do not yet have a user configured in mysql, read on...
If you are not familiar with mysql and have not set up a mysql user, search for "mysql grant syntax". But to make it very, very easy for you it will be something like this...
GRANT ALL ON database.table TO user@host IDENTIFIED BY 'password';
...then in your application configuration file use these same parameters to connect with mysqli_real_connect().
And welcome to LQ!