Windows环境下安装Mysql5.7.35&远程授权命令
1.下载
https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.35-winx64.zip
2.解压
解压Mysql到D:\Program Files (x86)\mysql-5.7.35-winx64
3.准备my.ini
准备好my.ini,放在D:\Program Files (x86)\mysql-5.7.35-winx64目录下,目录下没有my.ini,新建即可。my.ini内容如下:
[client]
port=3306
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld]
basedir = "D:\Program Files (x86)\mysql-5.7.35-winx64"
datadir = "D:\Program Files (x86)\mysql-5.7.35-winx64\data"
port = 3306
server_id = 1
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
character-set-server=utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
default-storage-engine=InnoDB
max_connections=2000
max_allowed_packet = 128M
innodb_file_per_table=1
lower_case_table_names=1
max_heap_table_size=16M
4.配好mysql环境变量
windows下加入环境变量Path: D:\Program Files (x86)\mysql-5.7.35-winx64\bin
步骤(win10):此电脑->属性->高级系统设置->环境变量->用户变量->新建path,然后填写。
5.安装MySQL的windows服务
mysqld install MySQL --defaults-file="D:\Program Files (x86)\mysql-5.7.35-winx64\my.ini"
6.删除MySQL服务
如果需要卸载mysql,删除D:\Program Files (x86)\mysql-5.7.35-winx64目录,同时进行 mysql服务的卸载
mysqld --remove MySQL
7.启动与停止mysql
cmd命令下执行:
net start mysql
net stop mysql
8.未安装服务的情况下,如何进行启动
####.mysql手动启动与停止,无服务的情况
D:\Program Files (x86)\mysql-5.7.35-winx64\bin
mysqld --defaults-file="D:\Program Files (x86)\mysql-5.7.35-winx64\my.ini"
pause
####停止mysql命令
mysqladmin -u root shutdown(在设置了密码的情况下的命令为mysqladmin -u root -p shutdown)
9.远程授权命令
grant all privileges on *.* to 'webuser'@'%' identified by '123456' with grant option;
flush privileges;