文件名称:mysql8.0 X64 安装文件和手动安装脚本
文件大小:183.31MB
文件格式:ZIP
更新时间:2021-10-11 12:18:56
Mysql8.0
mysql8.0 X64 安装文件和手动安装脚本 --命令行依次执行下面代码 C:\Windows\system32>D: D:\>cd D:\mysql-8.0.11-winx64 D:\mysql-8.0.11-winx64>cd bin D:\mysql-8.0.11-winx64\bin>mysqld --initialize-insecure --console D:\mysql-8.0.11-winx64\bin>mysqld --install mysql811 D:\mysql-8.0.11-winx64\bin>net start mysql811 D:\mysql-8.0.11-winx64\bin>mysql -uroot -p mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'p assword'; Query OK, 0 rows affected (0.14 sec) mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'p assword{}'; Query OK, 0 rows affected (0.19 sec) mysql> CREATE USER 'sa'@'%' IDENTIFIED BY 'csbt7.ydhl12s'; Query OK, 0 rows affected (0.19 sec) mysql> GRANT ALL ON *.* TO 'sa'@'%'; Query OK, 0 rows affected (0.10 sec)