- mkdir -p /data/mysql
- chown mysql.mysql /data/mysql/
- /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql/ --user=mysql --datadir=/data/mysql
- /usr/local/mysql/bin/mysqld_safe -user=mysql &
- service mysqld start
- netstat -lantp
- /usr/local/mysql/bin/mysql -uroot -p
- delete from mysql.user where user='';
- delete from mysql.user where user='root' and host='127.0.0.1';
- delete from mysql.user where user='root' and host='::1';
- delete from mysql.user where user='root' and host='localhost.localdomain';
- GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
- create database Databasename;
- drop database test;
- show databases;
- select user,host,password from mysql.user;
- use beeeye;
- update t_userregister set `passWord`='e10adc3949ba59abbe56e057f20f883e';
- flush privileges;
- gunzip < B.tar.gz | /usr/local/mysql/bin/mysql -uroot Databasename
数据库重置后的操作记录
原创
©著作权归作者所有:来自51CTO博客作者xlogin的原创作品,请联系作者获取转载授权,否则将追究法律责任
好记性不如烂笔头,哈哈!
上一篇:memcached简易安装
下一篇:RedHat 密码策略加固
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
数据库常用操作记录
mysqldump -B 在备份数据库的时候会在备份的语句中写入create database的语
Mysql 导出表 mysql 数据库 -
数据库的简单操作-学习记录
后台程序: ///<summary> ///数据库操作摘要 ///</summary> &nb
.net 代码 程序 数据库 休闲