mysql8绿化配置教程

mysql8绿化教程
一、初始化
1.配置系统变量
“系统变量”path加mysql的bin目录

2.初始化配置文件my-small.ini如下
[client]
port = 3306
socket = MySQL
default-character-set = utf8
[mysqld]
port = 3306
socket = MySQL
skip-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K

#根目录
basedir= F:/mysql
#数据文件存放目录
datadir= F:/mysql/data

default-character-set=utf8
#跳过账号，重置登录密码后注掉
#skip-grant-tables
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
explicit_defaults_for_timestamp = true
sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

3.以管理员身份运行cmd窗口，进入bin目录

二、执行脚本：
mysqld –remove MySQL
mysqld --install MySQL
sc config MySQL start= auto
mysqld --initialize-insecure
net stop MySQL
net start MySQL
mysql -uroot
use mysql;
update user s set s.host=’%’ where s.user=‘root’;
flush privileges;
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘root’;
flush privileges;
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ WITH GRANT OPTION;
flush privileges;

4.移除，安装服务，开机启动
mysqld –remove MySQL
mysqld --install MySQL
sc config MySQL start= auto

6.初始化 mysql，创建一个具有空密码的root用户，自动生成data文件夹，必须执行，有则先删除再执行
mysqld --initialize-insecure

4.启动与关闭
net stop MySQL
net start MySQL
mysql启动后。在任务管理器当中可以看到mysqld.exe这个进程。说明mysql已经安装好了。并且已经成功的启动！

6.初始化数据库：
给root用户赋予了初始密码"root"，并且可以不限制本机登录。localhost为本地访问，变为%，所有IP可以访问
mysql -uroot
use mysql;
update user s set s.host=’%’ where s.user=‘root’;
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘root’;
flush privileges;

总管理员权限授权：
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ WITH GRANT OPTION;
flush privileges;