Re: unable to change password

2003-04-06 Thread B. van Ouwerkerk
At 08:28 06-04-2003 -0400, Devon Y. wrote: [Hisako:~] hisako% /usr/local/mysql/bin/mysql -u root -p mysql Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) This is the same thing that was happening to me! Then I discovered that my root password was not

Re: unable to change password

2003-04-06 Thread Devon Y.
[Hisako:~] hisako% /usr/local/mysql/bin/mysql -u root -p mysql Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) This is the same thing that was happening to me! Then I discovered that my root password was not set, even though I did everything that was

Re: unable to change password

2003-04-06 Thread B. van Ouwerkerk
try: mysql -u root -p then it will ask for your password. or mysql -u root -pmysql_root_password no spaces between -p and your mysql root password This is well documentee :http://www.mysql.com/doc/en/User_names.html please check the manual before asking questions. B. At 12:50 06-04-2003 +0100, His

Re: unable to change password; error: 'Lost connection to MySQL server d

2001-06-10 Thread bibe
Hi, I use MySQL on a Windows 2000 box and I usually change users and passwords from the MySQL shell, using: UPDATE user SET password=PASSWORD('newpassword') WHERE user='root'; I never had a single problem with this. bye, Bibe At 15.37 09/06/2001 -0700, you wrote: >I am getting a error after ins