How do you login to mysql ?

mysql -u user -p -h localhost

should do it.

You dont even need "-h localhost" in this case.

Best regards

Nils Valentin
Tokyo/Japan



2003年 6月 3日 火曜日 11:31、Kalin Mintchev さんは書きました:
> hi everybody...
>
> i just installed mysql 4.0.13 on a redhat linux 8.0
> when i create a database as root and then grant privileges to another user
> like this:
> GRANT ALL ON somedb.* TO [EMAIL PROTECTED] IDENTIFIED BY "passwd";
>
> everything seems to be fine but then if i log in as "user" and try to get
> to the mysql client on the command line i get this:
> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:NO)
>
>
> if as root i su - user i can get to the mysql prompt but can't see
> somedb...
>
> it's not the first time i install mysql but this is the first time i get
> into this problems...
>
> what is the problem? please help...
>
> thanks...

-- 
================================================
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
================================================


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to