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:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 2:18 PM
To: 'Rick Emery'
Cc: '[EMAIL PROTECTED]'
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: '[EMAIL PROTECTED]'
> 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:[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]
>
>
--
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]
