mysql5.7安装及设置root密码

[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

sudo yum install -y mysql-community-server

vi etc/my.cnf

[mysqld]
socket = data/mysql/mysql.sock
default-time-zOne= '+8:00'
key_buffer_size = 1024M
max_allowed_packet = 16M
table_open_cache = 1024
sort_buffer_size = 128M
read_buffer_size = 128M
read_rnd_buffer_size = 32M
myisam_sort_buffer_size = 364M
myisam_max_sort_file_size = 10G
thread_cache_size = 64
query_cache_size= 256M
query_cache_type=1
query_cache_limit=2M
innodb_thread_cOncurrency= 16
max_cOnnections=1000
max_connect_errors=10000
max_heap_table_size = 64M
tmp_table_size = 32M
ft_min_word_len=1
ft_stopword_file=
delay_key_write=ALL
tmp_table_size=800M
tmpdir = tmp/
skip-name-resolve
wait_timeout = 28800
interactive_timeout = 28800
group_concat_max_len = 102400


character-set-server=utf8
server-id = 81
binlog_format = row
log-error=/data/mysql/2_7_81-error.log
pid-file=/data/mysql/2_7_81.pid
datadir = data/mysql/


log-bin=/data/mysql/2_7_81-bin
log-bin-index=/data/mysql/2_7_81-bin.index
log_bin_trust_function_creators=1


log_slave_updates
expire_logs_days=15


relay-log=/data/mysql/2_7_81-srelay.log
relay_log_purge=1


slow_query_log = 1
slow_query_log_file=/data/mysql/2_7_81-slowquery.log
long_query_time=10


innodb_file_per_table=1
innodb_write_io_threads=8
innodb_read_io_threads=8
innodb_lock_wait_timeout=300
innodb_large_prefix=on


ft_min_word_len = 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




[mysqldump]
quick
max_allowed_packet=512M
default-character-set=utf8
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[client]
socket = /data/mysql/mysql.sock

service mysqld restart

[myslqd]
...
skip-grant-tables
...

service mysqld restart

mysql -uroot -p

update mysql.user set authentication_string=password('123456') where user= 'root';
FLUSH PRIVILEGES;

alter user 'root'@'localhost' identified by '123456';

set global validate_password.policy=0; #设置为弱口令

/ 微信号 / 程序老哥/