Bug #16215 | set password | ||
---|---|---|---|
Submitted: | 5 Jan 2006 8:08 | Modified: | 5 Jan 2006 12:49 |
Reporter: | mkysoft sofware | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.1.4 | OS: | Windows (Windows XP with all updates) |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[5 Jan 2006 8:08]
mkysoft sofware
[5 Jan 2006 8:14]
Valeriy Kravchuk
Sorry, but isn't it a duplicate of bug #16214 you just added?
[5 Jan 2006 8:28]
mkysoft sofware
It's like seem but different. One of is give an privilage error, the other one is crushes mysql. Sorry, I think like this.
[5 Jan 2006 12:49]
MySQL Verification Team
I was unable to repeat the behavior reported: C:\mysql\bin>mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 5.1.4-alpha-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create user "miguel"@"localhost"; Query OK, 0 rows affected (0.00 sec) mysql> set password for "miguel"@"localhost" = password("tester"); Query OK, 0 rows affected (0.00 sec) mysql> exit Bye C:\mysql\bin>mysql -umiguel -ptester Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 5.1.4-alpha-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> set password for "miguel"@"localhost" = password("tester2"); Query OK, 0 rows affected (0.00 sec) mysql> exit Bye C:\mysql\bin>mysql -umiguel -ptester2 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 5.1.4-alpha-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> exit Bye C:\mysql\bin>mysql -umiguel -ptester ERROR 1045 (28000): Access denied for user 'miguel'@'localhost' (using password: YES) C:\mysql\bin>