How to reset the root password of the MySQL server in Ubuntu

Source: Internet
Author: User
Mysql5server is installed in Ubuntu. The result is unknown. The root account and password entered during installation cannot be verified by the database server in any way. Instead, you only need to reset the password of the mysql root Account. Check that the root account password is successfully reset using the following methods. First stop mysql service: root @ webserver:/home/webmaster # servicemysqlstop and then ignore Password Authentication Mode

Mysql 5 server is installed in Ubuntu. The result is unknown. The root account and password entered during installation cannot be verified by the database server in any way. Instead, you only need to reset the password of the mysql root Account. Check that the root account password is successfully reset using the following methods.

First stop the mysql service:

Root @ webserver:/home/webmaster # service mysql stop

Then, a new mysql service is created in the ignore Password Authentication Mode:

Root @ webserver:/home/webmaster # mysqld -- user = mysql -- skip-grant-tables -- skip-networking &

After successful startup, the PID and other startup information are returned:

[1] 3591
Root @ webserver:/home/webmaster #121005 2:59:27 [Note] Plugin 'federated 'is disabled.
121005 2:59:27 InnoDB: The InnoDB memory heap is disabled
121005 2:59:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121005 2:59:27 InnoDB: Compressed tables use zlib 1.2.3.4
121005 2:59:27 InnoDB: Initializing buffer pool, size = 128.0 M
121005 2:59:27 InnoDB: Completed initialization of buffer pool
121005 2:59:27 InnoDB: highest supported file format is Barracuda.
121005 2:59:27 InnoDB: Waiting for the background threads to start
121005 2:59:28 InnoDB: 1.1.8 started; log sequence number 1595685
121005 2:59:28 [Note] mysqld: ready for connections.
Version: '5. 5.24-0ubuntu0. 12.04.1 'socket: '/var/run/mysqld. sock' port: 0 (Ubuntu)

Connect to the mysql database:

Root @ webserver:/home/webmaster # mysql-u root mysql

After connecting to the mysql database, directly change the root account password to the new password 'mynewpasswd ':

Type 'help; 'or' \ H' for help. type' \ C' to clear the current input statement.

Mysql> update user set Password = PASSWORD ('mynewpasswd') where user = 'root ';
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3 Changed: 3 Warnings: 0

Mysql> flush privileges;

Mysql> quit;
Bye

Stop the mysql service process (for PID 3591, see the screen information before starting the Service ):

Root @ webserver:/home/webmaster # kill 3591

Start the mysql service normally and log on to the mysql server with the new password:

Root @ webserver:/home/webmaster # service mysql start

Root @ webserver:/home/webmaster # mysql-u root-pmynewpasswd

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.