Re: login root problem

2002-07-04 Thread Victoria Reznichenko

Ivan,
Thursday, July 04, 2002, 8:33:31 AM, you wrote:

IP I can't login using root to mysql server from my pc-client...
IP I have tried to use this command but still have a problem...

IPmysql -u root -p -h 192.168.x.xxx

IP i already created one user which have all privileges
IP so, if i check into mysql database and user tables, i found two user, root
IP and user_1.

IP should i give grant privilege to root with all privileges or not?

IP anybody can help me?

Ivan, what exactly error did you receive? Did you specify password for
your user 'root' after installation or no? If no, remove -p option.
Does user 'root' have permissions to connect from host
'192.168.x.xxx'?




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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




login root problem

2002-07-03 Thread Ivan Paul

I can't login using root to mysql server from my pc-client...
I have tried to use this command but still have a problem...

   mysql -u root -p -h 192.168.x.xxx

i already created one user which have all privileges
so, if i check into mysql database and user tables, i found two user, root
and user_1.

should i give grant privilege to root with all privileges or not?

anybody can help me?

Sorry for my bad English and thanks for advance

Ivan Paul


-
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