Home > Database > Mysql Tutorial > MySQL常用命令_MySQL

MySQL常用命令_MySQL

WBOY
Release: 2016-05-27 14:29:44
Original
1044 people have browsed it

bitsCN.com

1. 备份数据库

mysqldump -uroot -p test_db > test_db.sql

 

2. 恢复数据库

mysql -uroot -p test_db

 

3. 创建权限

 

grant all privileges on test_db.* to test_db@'localhost' identified by '123456';

兼容mysql4.1之前模式:
update mysql.user set password=old_password('123456')  where user='test_db';

 

4. 忘记密码

在“my.cnf”或“my.ini”文件的“mysqld”配置段添加“skip-grant-tables”,然后重新启动mysql即可登录修改root密码。

 

bitsCN.com
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template