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 实例名