You can try one or the other

mysql -h localhost -u root -ppasswd db
or
mysql -h `uname -n` -u root -ppasswd db

in solaris

On Mon, 30 Jun 2003, Twibell, Cory L wrote:

> Did you flush the privileges after you gave root a password?
> The error you get is a result of not using a password to login.
>
> -----Original Message-----
> From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 30, 2003 6:05 PM
> To: [EMAIL PROTECTED]
> Subject: Access Denied for User: [EMAIL PROTECTED](Using password: NO)
>
>
> Please somebody help me.
>
> I have installed MySql 4.0.13 and it works up until I try to apply security
> settings to the root user at localhost.
>
> I see the mysql database and I check the privileges and there is no password
> for the roo user. But when I assign a password to make it secure, I can run
> phpmyadmin, but I cannot get into the database anymore. All I get is:
>
> MySql Said:
> Access Denied for user: [EMAIL PROTECTED] (Using password: NO)
>
> This situation has happened 3 times and I had to reinstall MySql and start
> from scratch.
>
> Can someone please point me in the right direction, this is my first try and
> it has been quite a serious learning experience.
>
> Thank you in advance.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>

-- 
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There's no place like 127.0.0.1


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

Reply via email to