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]