RE: [PHP-DB] Can't connect to local MySQL server error

I'm also having trouble connecting to the MySQL server. I can connect as root, but not as a user from the command line. When connect to the mysql server as ROOT, I've granted all privileges to the user using 'user@localhost' and 'user@"%" '. Still no luck. I'm using MySQL on Redhat Linux. I'm having same problem connecting via a mysql_connect(---) call in PHP. What do I need to do to allow user interaction for MySQL? thanks rick Richard L. Emery IT Sr. Project Manager "There is no 'trying'... There is only 'Do' or 'Not Do' " -----Original Message----- From: Brunner, Daniel [mailto:daniel.brunner@duni.com] Sent: Friday, February 16, 2001 5:05 PM To: 'cweiss@casadelove.com' Cc: 'php-db@lists.php.net' Subject: RE: [PHP-DB] Can't connect to local MySQL server error Hello... Do a netstat -vatp To see if mysql is up and listening on your TCP. And it will give your PID/Program name as well... I remember reading something about if the mysql.sock didn't work...you needed to do something with mysql...I'll look into it this weekend..... If nobody can help you out sooner.... Well good luck... Dan > ---------- > From: Chris Weiss > Reply To: cweiss@casadelove.com > Sent: Friday, February 16, 2001 4:37 PM > To: php-db@lists.php.net > Subject: [PHP-DB] Can't connect to local MySQL server error > > Help! > I'm experimenting with several of the PHP based WebDatabase front ends > and > am getting the following errors from all of them: > > "Warning: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (111) in /home/httpd/html/pub/mainfile.php > on > line 9 > Unable to select database" > > I've tried the following: > [root@casadelove pub]# telnet localhost 3306 |strings > Trying 127.0.0.1... > Connected to casadelove.com. > Escape character is '^]'. > 3.23.27-beta > $Gu=m/>. > Connection closed by foreign host. > > The databases being requested do exist and are populated with the > default > data and WebMin (Perl-based web administration program) accesses the > test > databases just fine. > > This is on a RH6.2 system with Apache 1.3.14 and PHP 4.0.4. > > This strikes me as something really stupid that I'm missing, anyone > have any > bright ideas where to look? > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net