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:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 5:05 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
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: [EMAIL PROTECTED]
> Sent: Friday, February 16, 2001 4:37 PM
> To: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
