LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 01-02-2015, 02:30 PM   #1
cecilchamp
LQ Newbie
 
Registered: Jan 2015
Location: Texas and Arizona
Posts: 6

Rep: Reputation: Disabled
phpGrid Error


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
 
Old 01-03-2015, 11:05 PM   #2
astrogeek
Moderator
 
Registered: Oct 2008
Distribution: Slackware [64]-X.{0|1|2|37|-current} ::12<=X<=15, FreeBSD_12{.0|.1}
Posts: 6,263
Blog Entries: 24

Rep: Reputation: 4194Reputation: 4194Reputation: 4194Reputation: 4194Reputation: 4194Reputation: 4194Reputation: 4194Reputation: 4194Reputation: 4194Reputation: 4194Reputation: 4194
Quote:
Originally Posted by cecilchamp View Post
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...

Code:
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!

Last edited by astrogeek; 01-03-2015 at 11:30 PM. Reason: Clarity, typos...
 
Old 01-06-2015, 09:24 AM   #3
cecilchamp
LQ Newbie
 
Registered: Jan 2015
Location: Texas and Arizona
Posts: 6

Original Poster
Rep: Reputation: Disabled
Path wasn't right for phpGrid

When I dropped the phpGrid folder into the Linux box, I had a new name for it other than phpGrid, that being phpGrid_Enterprise, because I didn't want to overwite the previous folder. Once I corrected that little issue in several PHP programs, things worked perfectly. I had alrady set up the MySQL database, and rights, etc. I appreciate your response, because what you wrote are things that I may sometimes forget in a rush to get something done. Thank you, AstroHGeek for your response.
Cecil
 
  


Reply



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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Fatal error in MPI_Init: Other MPI error, error stack:gethostbyname failed(errno 1) turbo67 Linux - Networking 2 10-17-2018 04:06 AM
Fatal error in MPI_Init: Other MPI error, error stack:gethostbyname failed(errno 1) turbo67 Red Hat 1 06-15-2014 05:53 AM
Fatal error in MPI_Init: Other MPI error, error stack:gethostbyname failed(errno 1) shilpiiitr Linux - Software 0 01-13-2014 02:44 PM
Error 502 : Display Fatal Error Message, Error pushing image, dbpaCT failed! HaloCheng Linux - Newbie 1 09-12-2012 12:02 PM
Sendmail: eocket wedge , 504 error , dsn error, mail relay connection error djcs Debian 0 03-03-2009 12:41 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 12:32 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration