mysql运维-window安装(8)

下载

MySQL :: Download MySQL Community Server (Archived Versions)https://downloads.mysql.com/archives/community/

 配置文件my.ini (位于安装的根目录)

[mysqld]
port=3306
max_connections=200
max_connect_errors=10
character-set-server=utf8mb4
default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password
explicit_defaults_for_timestamp=true
default-time_zone = '+8:00'
log-bin=mysql-bin 
binlog-format=ROW 
server_id=188
[mysql]
# 设置 mysql 客户端默认字符集
default-character-set=utf8mb4
[client]
# 设置 mysql 客户端连接服务端时默认使用的端口
port=3306
default-character-set=utf8mb4

安装

sc delete mysql 命令
mysqld --initialize --console    这条命令会自动生成 data 文件夹，且生成临时密码，一定要记住临时密码
mysqld --install

启停

net start mysql

net stop mysql

远程登录

mysql -u root -p
mysql -h10.10.10.10 -uroot -p123456

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '100200'