Modify the MySql database root password and mysqlroot Password

Source: Internet
Author: User

Modify the MySql database root password and mysqlroot Password

Method 1:
Add the following to the [mysqld] field of my. ini:
Skip-grant-tables
Restart the mysql service. mysql can log on to the database without a password.
Then go to mysql
Mysql> use mysql;
Mysql> Update user set password = password ('new password') WHERE User = 'root ';
Mysql> flush privileges;
After running the command, remove skip-grant-tables from my. ini and restart mysqld.
 

Method 2:
Without modifying my. ini to restart the service, add skip-grant-tables in non-service mode to run mysql to change the mysql password.
Stop mysql Service
Open the command line window and start it with mysqld-nt.exe in the bindirectory. That is, execute mysqld-nt -- skip-grant-in the command line window-

Tables
Open a command line window and log on to mysql. You do not need to enter the mysql password.
After changing the password, close the window in which the command line runs mysql. In this case, mysql is closed. If mysql is still running

You can stop the corresponding process.
Start mysql Service


How can I change the root password of mysql?

Step 1: log on to MYSQL
Mysql-u root-p
Then press enter to enter (equivalent to entering with a blank password)
Step 2:
Use mysql;
Update user set password = password ('new password') where user = 'root ';
In this step, the password is updated.
Step 3:
Flush privileges;
Refresh permission.

OK. modified.
 
What if I forget the root password of MySql? How can I retrieve my password? How can I change the root password? Thanks

For the root password:

Method 1:
MySQL provides command line parameters for skipping access control and starts the MySQL server by running the following command:
Safe_mysqld -- skip-grant-tables &
You can skip MySQL Access Control. Anyone can enter the MySQL database as an administrator on the console.
It should be noted that after the password is changed, the MySQL server should be stopped and restarted to take effect.
First find mysql. server and then stop mysql Service
# Mysqld_safe -- skip-grant-tables -- skip-networking &
# Mysql
> Use mysql;
> Update user set password = PASSWORD ("new-password") where user = "root ";
> Flush privileges;

Method 2:
Follow these steps to reset the MySQL root Password:
1. First confirm that the server is in a secure state, that is, no one can connect to the MySQL database at will.
Because, during the resetting of the MySQL root Password, the MySQL database is completely out of password-free
Other users can log on to and modify MySQL information as needed. You can use
The external port is closed, and Apache and all user processes are stopped to implement server quasi-security.
Status. The safest status is to operate on the server Console and unplug the network cable.
2. Modify MySQL Logon Settings:
# Vi/etc/my. cnf
In the [mysqld] section, add skip-grant-tables.
For example:
[Mysqld]
Datadir =/var/lib/mysql
Socket =/var/lib/mysql. sock
Skip-name-resolve
Skip-grant-tables
Save and exit vi.
3. Restart mysqld
#/Etc/init. d/mysqld restart
Stopping MySQL: [OK]
Starting MySQL: [OK]
4. log on to and modify the MySQL root Password
#/Usr/bin/mysql
Welcome to the MySQL monitor. Commands end with; or \ g.
Your MySQL connection id is 3 to server version: 3.23.56
Type 'help; 'or' \ H' for help. Type '\ C' to clear the buffer.
Mysql> USE mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with-
Database changed
Mysql> UPDATE user SET Password = password ('new-password') WHERE User = 'root ';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Wa... the remaining full text>

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.