MySQL

mysql> create database test;

Query OK, 1 row affected (0,01 sec)

mysql> quit

mysql> show databases;

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

| Database           |

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

| information_schema |

| test               |

| mysql              |

| performance_schema |

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

4 rows in set (0,00 sec)

mysql>

[root@sf-lenovo ~]# mysql -D test < ./test.sql

mysql> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';

Query OK, 0 rows affected (0,01 sec)

mysql> GRANT ALL PRIVILEGES ON test . * TO 'user'@'localhost';

Query OK, 0 rows affected (0,00 sec)

mysqldump --user user --password password test > test.sql

# service mysqld stop

# mysqld --skip-grant-tables &

# mysql

mysql> use mysql

mysql> update user set Password=PASSWORD('newpassword') WHERE User='root';

mysql> flush privileges;

# service mysqld start