mysql reset root password_编程经验：mysql reset root password

//************************************************

#停止mysql服务，以及启动mysql时不启动grant-tables(授权表)

C:\Program Files\MySQL\MySQL Server 5.5\bin>net stop mysql

MySQL服务正在停止..

MySQL服务已成功停止。

C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqld --skip-grant-tables

//************************************************

#另开一个cmd命令行,不需要密码

C:\Program Files\MySQL\MySQL Server 5.5\bin>mysql -uroot

Welcome to the MySQL monitor.Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.5.5-m3 MySQL Community Server (GPL)

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

This software comes with ABSOLUTELY NO WARRANTY. This is free software,

and you are welcome to modify and redistribute it under the GPL v2 license

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

#重置mysql的root用户密码

mysql> update mysql.user set password=password('root') where user='root';

Query OK, 2 rows affected (0.77 sec)

Rows matched: 2Changed: 2Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.39 sec)

mysql>\q

//************************************************

#命令行Mysql数据库操作

mysql> show databases;

+--------------------+

| Database|

+--------------------+

| information_schema |

| mysql|

| performance_schema |

| test|

+--------------------+

4 rows in set (0.00 sec)

mysql>CREATE DATABASE `ework` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Query OK, 1 row affected (0.08 sec)

mysql>show databases;

+--------------------+

| Database|

+--------------------+

| information_schema |

| ework|

| mysql|

| performance_schema |

| test|

+--------------------+

5 rows in set (0.00 sec)

mysql>use ework;

Database changed

mysql>show tables;

+--------------------------+

| Tables_in_ework|

+--------------------------+

| jbpm4_deployment|

| jbpm4_deployprop|

| jbpm4_execution|

…|

| v_processview|

| v_processview_task|

+--------------------------+

131 rows in set (0.05 sec)