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;