How to change the password of mysql

How does mysql change its password? Environment 1: windows? 1. Configure environment variables and add mysqlbin to path. 2. Then, enter the following command in DOS to modify the password (assuming the original password is empty) mysqladmin-uroot? Passwordroot ?? Refurl: blog.sina.com.cnsblog_53f716d40100kmr8.html

How does mysql change its password? Environment 1: windows? 1. Configure environment variables and add mysql \ bin to path. 2. Then, enter the following command in DOS to modify the password (assuming the original password is empty) mysqladmin-uroot? Password root? ? Refurl: http://blog.sina.com.cn/s/blog_53f716d40100kmr8.html

How to change the password of mysql

? Environment 1: windows

?

1. Configure environment variables and add mysql \ bin to path.

2. Enter the following command in DOS to modify the password (assuming that the original password is empty)

Mysqladmin-uroot? Password root

?

?

Refurl:

Http://blog.sina.com.cn/s/blog_53f716d40100kmr8.html

?

Http://www.2cto.com/database/201209/154363.html

?

?

Http://zhidao.baidu.com/link? Url = VR7e3Pj5Pfrpvr-ac3Xsl-JhYX7h6p8wFD0CLrxjpXXfIRGRJC4hZfebf11r2NLfwu709SPDsS8ZO8grZlqj5q

?

?

? Ps:

1. logon method with a blank password:

Run the following command to log on to mysql: the original password is null.

Mysql-uroot-p, and press Enter. On the Password Input page, press enter to enter the system.

?

2. logon method with a password not empty (assuming the password is root ):

Run the following command:

Mysql-uroot-proot

Press enter to log on to the system. You cannot add a colon at the end. Otherwise, you cannot log on to the system because the password is considered as root.

?

?

? Bytes ---------------------------------------------------------------------------------------------------------

Environment 2: linux (redflag6) + phpmyadmin

Connect to phpmyadmin, click localhost-> SQL, enter the following code, and click execute:

Update mysql. user set password = PASSWORD ('new password') where User = 'root'; flush privileges;

?

Refurl: http://hi.baidu.com/qidusky/item/505655de427847f793a974b7

?

Http://www.linuxidc.com/Linux/2008-02/11137.htm

?

?