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

I tried: Grant ALL ON *.* to user@localhost IDENIFIED BY "password"; so as to provide access to all tables. I should have stated that the error I got was that I could not connect to the /var/lib/mysql/mysql.sock socket. 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: Monday, February 26, 2001 2:18 PM To: 'Rick Emery' Cc: 'php-db@lists.php.net' Subject: RE: [PHP-DB] Can't connect to local MySQL server error Hello... Try this instead... Grant ALL ON Database_name.* to user@localhost IDENIFIED BY "password"; You can use Grant whatever ON Database_name.*...As well.... The .* after the Database_name will allow all tables to be accesed by the users, on that Database... It worked great for me... Dan > ---------- > From: Rick Emery > Sent: Monday, February 26, 2001 1:16 PM > To: 'php-db@lists.php.net' > Subject: 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 > > -- > 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 > >