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]

Reply via email to