1、未登陆数据库的情况下
mysqldump -uroot -ppasswd --all-databases >mysql.sql 备份所有数据库
mysqldump -hip -uroot -ppasswd --databases databasename >mysql.sql 备份某个数据库到本地
mysqldump -uroot -ppasswd --databases name1 name2 >mysql.sql
2、搭建数据库
自己百度
3、数据库恢复
登陆新数据库 mysql -u root -p
source /home/username/mysql.sql 一定要是绝对路径
然后等待就行了
4、临时密码查看
sudo grep 'temporary password' /var/log/mysqld.log
5.然后复制临时密码登陆数据库
6、更改密码
方式一:格式:mysql> set password for 用户名@localhost = password('新密码');
例子:mysql> set password for root@localhost = password('123');
方式二:
mysql> use mysql;
mysql> update user set password=password('123') where user='root' and host='localhost';
mysql> flush privileges;
7、用户添加权限
查看用户权限:mysql> show grants for user;
授予所有权限给用户 grant all PRIVILEGES on *.* to username@localhost;
立即更新:mysql> flush privileges;
8、允许用户远程链接
mysql> use mysql;
查看用户允许的ip:mysql> SELECT User, Password, Host FROM user;
mysql> grant all privileges on *.* to 'root'@'%' identified by 'yourpassword' with grant option;
mysql> flush privileges;
9、创建数据库
create database 库名 default character set =utf8;