下载yum repository
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm装置yum repository
yum -y localinstall mysql57-community-release-el7-11.noarch.rpm在线装置mysql
yum -y install mysql-community-server批改配置
#cat /etc/my.cnf[mysqld]user=mysqlport=3306log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid#数据目录basedir=/data/mysqldatadir=/data/mysql/datasocket=/data/mysql/lib/mysql.sock#符号链接symbolic-links=0#设置最大连接数max_connections=1000#skip-grant-tablessql_mode =STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION#设置mysql默认字符集character-set-server=utf8collation-server=utf8_general_ci##开启binlog日志性能server-id=1log_bin=my-binbinlog_format = row##开启慢查问slow_query_log=ONslow_query_log_file=/var/lib/mysql/slow.loglong_query_time=1#敞开明码复杂度#validate_password=off #default_password_lifetime=0#表名不辨别大小写lower_case_table_names=1innodb_buffer_pool_instances=4#长期表大小tmp_table_size = 256Mmax_heap_table_size = 256M[client]socket=/data/mysql/lib/mysql.sock配置开机自启
systemctl start mysqld.servicesystemctl enable mysqld.service查看root用户默认生成的长期明码
grep "password" /var/log/mysqld.log应用默认明码登录mysql
mysql -u root -p批改root明码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword';flush privileges;
附1：常用命令
--创立用户CREATE USER 'username'@'host' IDENTIFIED BY 'password';--删除用户DROP USER 'username'@'host';--创立数据库CREATE DATABASE databasename;--删除数据库DROP DATABASE databasename;--用户受权GRANT privileges ON databasename.tablename TO 'username'@'host';--撤销用户权限REVOKE privilege ON databasename.tablename FROM 'username'@'host';#导出数据库mysqldump -u root -p --databases databasename >/root/databasename.sql#数据库单项同步（笼罩）mysqldump --host=sdbip --port=3306 -uroot -ppassword --set-gtid-purged=off --opt databasename | mysql --host=ddbip --port=3306 -uroot -ppassword -C databasename附2：重置明码
进行服务
systemctl stop mysqld && systemctl status mysqld- 批改my.cnf配置，增加
skip_grant_tables=1 启动服务，登录批改明码
[root@192-168-1-207 pack]# mysqlmysql> update mysql.user set authentication_string=password('password') where user='root' and host='%';