MySQL常用命令_MySQL
- WBOYOriginal
- 2016-05-27 14:29:44997browse
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
Statement：
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
Previous article：DB 数据库水平切分的实现原理解析－－－分库，分表，主从，集群_MySQLNext article：ORA-27101,ORA-27102 错误解决方法_MySQL