win 10 上解压安装 MySQL 8

# 进入到mysql的bin目录底下操作:

# 初始化mysql

mysqld --initialize --console

# 安装mysql服务

mysqld --install mysql

# 启动mysql服务

net start mysql

# 停止mysql服务

net stop mysql

# 卸载mysql服务

mysqld --remove mysql

# 登录mysql

mysql -h localhost -u root -P 3306 -p

# 修改mysql密码

alter user 'root'@'localhost' identified with mysql_native_password by '123456';

flush privileges;

# 开启mysql远程访问

# 方式一：

use mysql;

create user 'root'@'%' identified by '123456';

grant all on *.* to 'root'@'%';

alter user 'root'@'%' identified with mysql_native_password by '123456';

flush privileges;

# 方式二:

use mysql;

select user,authentication_string,host from user;

update user set host = '%' where user = 'root';

flush privileges;

alter user 'root'@'%' identified with mysql_native_password by '123456';

巴特西

win 10 上解压安装 MySQL 8

win 10 上解压安装 MySQL 8

最新文章

热门文章