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
[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
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
for help. Type '\c' to clear the buffer.
-
I tried to reset password with code below after I removed startupitem
from library and left it at desltop,
then typed the following code after restarting computer.
but I failed.
I
update user set Password = PASSWORD('mypassword') where User = 'myuserid';
http://www.mysql.com/doc/P/a/Passwords.html
C:ya
-Original Message-
From: Yuxia Li [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 4:54 PM
To: [EMAIL PROTECTED]
Subject: Change
Hi:
The administor created a mysql database "library" for me at my home
directry. He didn't set a password for me. I don't know how to set my
password for my database. I tried using:
->mysql library
mysql -> set PASSWORD=PASSWORD('mypassword');
in the command but it didn't work. I need a help!
Hi:
The administor created a mysql database "library" for me at my home
directry. He didn't set a password for me. I don't know how to set my
password for my database. I tried using:
->mysql library
mysql -> set PASSWORD=PASSWORD('mypassword');
in the command but it didn't work. I need a help!
setup for a NT network for intranet
>development
>locally.
>
>I'd appreciate if you would consider this a bug, and please reply with any
>possible
>resolutions that you may have. I thank you for your courtesy and any hasty
>information you
>can give me on this.
>
>
i don't
know. I have
shizniz> never had this problem under FreeBSD.
Which MySQL version are you using ?
I have seen this error once before in an older MySQL 3.23 version on
windows, but this should work with 3.23.38.
shizniz> F:\mysql\bin>mysqladmin -u root password x
shizni
d xxxxx
mysqladmin: unable to change password; error: 'Lost connection to MySQL server d
uring query'
Thanks in advance.
ShizNiz
Director of Development & Administration
HNC Network
http://www.hncnetwork.com
http://www.hack-net.com
-
7.0.0.1 -p password newpassword
>
>
> - Original Message -
> From: "Ardianto Rustandi" <[EMAIL PROTECTED]>
> To: "Rolf Hopkins" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, May 30, 2001 11:16
> Subject: Re: Can't change p
;[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 11:16
Subject: Re: Can't change password in MySQL Windows version
> This was what I did:
>
> As root:
> mysql>GRANT ALL ON mydb.* to [EMAIL PROTECTED] identified by
'mypassword';
> mysql>FLUSH PRIVILEGES;
>
\MYSQLA~1.EXE: unable to change password; error: 'Can't find any
matching row in the user table'
Trying to change myaccount's password from mysql console (as myaccount):
mysql> SET PASSWORD = PASSWORD('newpassword');
ERROR 1133: Can't find any matching row in t
ssage -
From: "Ardianto Rustandi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 23:32
Subject: Can't change password in MySQL Windows version
> Hello all!
>
> Can anyone help me why I cannot change a user's password in the W
Hello all!
Can anyone help me why I cannot change a user's password in the Windows
version of MySQL (except for the root account)? I keep getting the "ERROR
1133: Can't find any matching row in the user table" error message everytime
I try to change a user's password, both from mysqladmin and fro
15 matches
Mail list logo
