Basic mysql database operations 3 _ MySQL

Mysql database basic operation environment 3: msyql version 5.0, windows OS

Mysqladmin command to change password

034039-> 123456

C:/Users/ASUS>mysqladmin -u root -p034039 password 123456C:/Users/ASUS>mysql -u root -p123456Welcome to the MySQL monitor.  Commands end with ; or /g.Your MySQL connection id is 32Server version: 5.0.96-community-nt MySQL Community Edition (GPL)Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.mysql>

Pitfall:

This statement C:/Users/ASUS> mysqladmin-u root-p123456 password '123456 ';

In fact, the new password is'123 ';

That is to say, single quotes are interpreted as part of the password.

You say it's okay

C:/Users/ASUS>mysqladmin -u root -p123456 password '034039';C:/Users/ASUS>mysql -u root -p'034039'ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)C:/Users/ASUS>mysql -u root -p'034039';Welcome to the MySQL monitor.  Commands end with ; or /g.Your MySQL connection id is 35Server version: 5.0.96-community-nt MySQL Community Edition (GPL)Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.mysql>

Similar

C:/Users/ASUS>mysqladmin -u root -p'034039'; password "123456"C:/Users/ASUS>mysql -u root -p"123456"Welcome to the MySQL monitor.  Commands end with ; or /g.Your MySQL connection id is 37Server version: 5.0.96-community-nt MySQL Community Edition (GPL)Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.mysql> Ctrl-C -- exit!Bye

What is the current mysql password? In fact, it is 123456, without double quotation marks

Then:

C:/Users/ASUS>mysqladmin -u root -p034039 password "123456"C:/Users/ASUS>mysql -u root -p123456Welcome to the MySQL monitor.  Commands end with ; or /g.Your MySQL connection id is 44Server version: 5.0.96-community-nt MySQL Community Edition (GPL)Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.mysql>Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statemenmysql>

That is to say, double quotation marks must be used in Windows. double quotation marks are not interpreted as part of the password. Use double quotation marks when the password contains spaces.

If the password is incorrect, the following error occurs:

C:/Users/ASUS>mysql -u root -p123ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Mysql forgot password

Stop mysql service

D:/> net stop mysqlMySQL service is stopping. MySQL service has been stopped successfully.

Open mysql configuration file my. ini

Add this statement under [mysqld]

Skip-grant-tables

Save and exit

Then restart mysql

D:/> net start mysqlMySQL service is starting. MySQL service has been started successfully.

Log on to mysql. you can log on directly without a password.

D:/>mysql -h localhost -u root -pEnter password:Welcome to the MySQL monitor.  Commands end with ; or /g.Your MySQL connection id is 1Server version: 5.0.96-community-nt MySQL Community Edition (GPL)Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.mysql>

Run the following command:

mysql> use mysql;Database changedmysql> update user set password = password("123456") where user = "root";Query OK, 2 rows affected (0.06 sec)Rows matched: 2  Changed: 2  Warnings: 0mysql> flush privileges;Query OK, 0 rows affected (0.01 sec)mysql> exitBye

The logon password is now set to 123456. Delete the skip-grant-tables statement and restart it. now you can use the new password to log on.