mysql8 安装 恢复常用知识

 mysql8 命令行安装

mysqld --initialize --user=mysql --console   //提供默认密码
mysqld --defaults-file=D:\mysql-8.0.21-winx64\my.ini --initialize --console
mysqld --install mysql3318 --defaults-file="D:\mysql\mysql-8.0.21-winx64\my.ini"
net start mysql
mysql -u root -p --protocol=tcp --host=localhost --port=3318

创建用户、授权、密码编码

select host,user from user;  
create user 'bar'@'%' identified by 'password';  
alter user 'bar'@'%'  identified with mysql_native_password by 'password';  
grant all privileges on *.* to 'bar'@'%'  with grant option  
flush privileges  
  
alter user 'root'@'%'  identified with mysql_native_password by 'password';  
alter user 'root'@'localhost' identified with mysql_native_password by 'password'

The user specified as a definer ('root'@'%') does not exist
8.0.11版本之后移除了grant 语句添加用户的功能，也就是说grant...只能适用于已存在的账户，不能通过 grant... 来添加账号了。

mysql> create user 'root'@'%' identified by '密码';  
Query OK, 0 rows affected (2.35 sec)  
   
mysql> grant all privileges on *.* to 'root'@'%';  
Query OK, 0 rows affected (0.06 sec)  
   
mysql> flush privileges;  
Query OK, 0 rows affected (0.06 sec)  

恢复数据库

use backdatabase；
source d:\20200101.db

删除数据库实例
管理员启动命令行

sc delete 实例名