How to set the MySQL root password

Source: Internet
Author: User
Tags reserved

How to set the MySQL root password:


1, first install root initial password is empty, note is no password, directly hit enter
D:\wamp\bin\mysql\mysql5.6.17\bin> mysql-uroot-p
Enter password: [Direct return]
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 7
Server version:5.6.17 MySQL Community Server (GPL)


Copyright (c), the Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.


Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.


Mysql>


2. Several ways to change the root password:
1) Use Set password command
First log in to MySQL.
Format:mysql> set password for user name @localhost = password (' new password ');

For example:


Mysql> Set password for [email protected] = password (' root ');
Query OK, 0 rows Affected (0.00 sec)


Mysql> quit
Bye


D:\wamp\bin\mysql\mysql5.6.17\bin> Mysql-uroot-proot
Warning:using a password on the command line interface can is insecure.
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 8
Server version:5.6.17 MySQL Community Server (GPL)


Copyright (c), the Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.


Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.


Mysql>


2) Use Mysqladmin
Format: Mysqladmin-u username-P Old password password new password
For example:
D:\wamp\bin\mysql\mysql5.6.17\bin> mysqladmin-uroot-proot Password root123
Warning:using a password on the command line interface can is insecure.


D:\wamp\bin\mysql\mysql5.6.17\bin> mysql-uroot-proot123
Warning:using a password on the command line interface can is insecure.
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 10
Server version:5.6.17 MySQL Community Server (GPL)


Copyright (c), the Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.


Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.


Mysql>


3) Edit user table directly with update
First log in to MySQL.
   mysql> use MySQL;
mysql> Update user Set Password=password (' root ') where user= ' root ' and host= ' localhost ';
mysql> flush Privileges;

--Attention must be flush privileges;
MySQL new setup user or change password after use flush privileges refresh the MySQL system permission related table, otherwise there will be denied access, there is another way, is to restart the MySQL server for the new settings to take effect.


4) When you forget the root password, you can do so.
Take windows as an example:
1. Close the running MySQL service.
2. Open the DOS window and go to the Mysql\bin directory.
3. Enter Mysqld--skip-grant-tables carriage return. --skip-grant-tables means skipping permission table authentication when starting the MySQL service.
4. Open a DOS window again (because the DOS window is no longer moving), go to the Mysql\bin directory.
5. Enter MySQL return and, if successful, the MySQL prompt > will appear.
6. Connection rights database: use MySQL;.
6. Change Password: Update user set Password=password (' root123 ') where user= ' root '; (don't forget the last semicolon).
7. Refresh permissions (required steps): flush Privileges;
8. Exit the current CMD from quit and close the DOS window in 2

9. Using the username root, the new password root123 in the 4 DOS window login.


-----------------------------

Dylan presents.


How to set the MySQL root password

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.