centos6.10 Mysql配置文件

[mysql]
port=3306
socket=/data/mysql-5.7.26/data/mysql.sock
default-character-set=utf8

[mysqld]
port=3306
basedir=/data/mysql-5.7.26
datadir=/data/mysql-5.7.26/data
socket=/data/mysql-5.7.26/data/mysql.sock
character-set-server=utf8
innodb_flush_log_at_trx_commit=0
innodb_buffer_pool_size=8G
lower_case_table_names=1
max_connections=500

[mysqldump]
socket=/data/mysql-5.7.26/data/mysql.sock

配置教程

shell> groupadd mysql
shell> useradd -r -g mysql -s /bin/false mysql
shell> cd mysql
shell> mkdir mysql-files
shell> chown mysql:mysql mysql-files
shell> chmod 750 mysql-files
shell> bin/mysqld --initialize --user=mysql 
shell> cp support-files/mysql.server /etc/init.d/mysql.server

重置密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
flush privileges;
quit;

刷新权限
创建服务 配置开机自启动