mysql5.7免安装配置
进入mysql目录:E:\Project\SMC\mysql_not_setup\mysql-5.7.12-winx64
重命名my-default.ini为my.ini
进入bin目录
--------------
mysqld --install mysql2
mysqld --initialize-insecure --user=mysql
mysqld --console
net start mysql2
net stop mysql2
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('111111');
重载授权表:
FLUSH PRIVILEGES;
删除服务 :mysqld --remove mysql3
跨域授权:GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '111111' WITH GRANT OPTION;
mysqld --install mysql3 --defaults-file="../my.ini"
mysqld --initialize-insecure --user=mysql
mysqld --console
set MYSQL_HOME=E:\Project\SMC\mysql_not_setup\mysql-5.7.12-winx64
set path=%MYSQL_HOME%\bin;%path%;
mysqld --remove mysql3
# mysqld --console
mysqld --install mysql2
net start mysql2
net stop mysql2