On Wed, 2002-03-13 at 08:08, b g wrote:
> when I m in root or mysql USER login.. then I can
> login to mySQL server.. its fine..
> but other than 'root' and 'mysql', i can not connect
> to the database server..

With which user are you trying to connect ?
Did you grant permissions to that user ?
Be more specific.

> thats why I am not able to run any web based database
> connection.. i get could not connect to database..
> 
> can u pls explain wht to do now?
> 
> I hv created one mysql user using this:
> 
> $ su
> passwd:
> shell> mysql --user=root mysql
> mysql> GRANT ALL PRIVILEGES ON *.* TO babul@localhost
>     ->     IDENTIFIED BY 'babul123' WITH GRANT OPTION;
>     -> \q
> $
> 
> then  i am able to connect using the database
> user/pass .. that too when i was in super-user mode..
> else frm other users, i m not able
> to conenct.. pls help..
> 
> the mysqld is running!
> 
> Babul
> in India..
> 
-- 
dsoares
(sql)

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to