About MySQL changing the password record

Source: Internet
Author: User

After the initial installation, use the administrator to enter the CMD interface,

Enter "Mysql-u root-p", "Enter Password:", direct carriage return
Enter "show databases; "And you'll see the MySQL database, and we'll switch to this database
Enter "use MySQL; ", switch to MySQL database
Enter "Update user set Password=password (' 123456 ') where user= ' root ';" To set the root user's password, which is set to 123456
Enter "flush privileges" to refresh the permissions
Enter "Quit" to sign out
Enter "Mysql-u root-p", "Enter Password:", enter the password you just set, return, login successful.
At this point, the root password has been modified successfully.

About MySQL changing the password record

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.