1.建立数据目录

mkdir -pv /u01/app

mkdir -pv /u01/soft

mkdir -pv /u02/mysqldata

2.建立用户和组，授权

useradd -r mysql -s /sbin/nologin

chown -R mysql:mysql /u01/app/mysql

chown -R mysql:mysql /u02/mysqldata

3.解压链接文件

cd /u01/soft

tar -zxf mysql-5.7.10-linux-glibc2.5-x86_64.tar.gz

ln -sv /u01/soft/mysql-5.7.10-linux-glibc2.5-x86_64 /u01/app/mysql

4.初始化

cd /u01/app/mysql/bin

./mysqld --initialize --basedir=/u01/app/mysql --datadir=/u02/mysqldata --user=mysql --explicit_defaults_for_timestamp

ls /u02/mysqldata/ #看生成的文件

./mysql_install_db --basedir=/u01/app/mysql --datadir=/u02/mysqldata --user=mysql

记住临时密码

5.覆盖配置文件

cp /u01/app/mysql/support-files/my-default.cnf /etc/my.cnf

cp /u01/app/mysql/support-files/mysql.server /etc/init.d/mysqld

vim /etc/my.cnf

vim /etc/profile.d/mysql.sh

 

my.cnf:[mysqld]sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLESbasedir=/u01/app/mysqldatadir=/u02/mysqldatadefault_password_lifetime=0character_set_server=utf8skip-name-resolve		#禁止DNS解析max_connections = 800  max_connect_errors = 100user=mysqlport=3306[mysql]default-character-set=utf8mysql.sh:export MYSQL_HOME=/u01/app/mysqlexport PATH=$PATH:$MYSQL_HOME/bin

　　

6. 更改密码，删除匿名用户

update user set authentication_string=password('123123') where user='root' and Host='localhost'

ALTER USER 'root'@'localhost' IDENTIFIED BY '637h1m27h36r33K';

select Host,User,authentication_string,password_expired,password_lifetime from user; #查看用户

ALTER USER 'root'@'%' IDENTIFIED BY '637h1m27h36r33K'; #设置用户密码

alter user root@'%' password expire never; #设置root用户不过期

flush privilege;

7. 普遍用户建立，授权

CREATE USER 'bicd'@'%' IDENTIFIED BY '71m32ch4n6317';

grant select,update on mysql.* to 'bicd'@'%';

SHOW GRANTS FOR bicd

8. 系统参数优化

vim /etc/security/limits.conf #修改文件句柄限制

fdisk -l

cat /sys/block/sda/queue/scheduler

echo deadline > /sys/block/sda/queue/scheduler #磁盘调度策略

 

9. 管理命令

/usr/local/mysql/bin/mysqladmin -u root -p shutdown #安全关闭数据库

service mysqld start

service mysqld restart

df -h #查看磁盘

10.参数查看

show variables like '%innodb_file_per%'; #看是否是独立表空间，为on时是独立表空间（数据文件不在一起）

show variables like '%character_set_%'; #看数据库字符集是啥玩意儿

show create database bicd; #看建库过程

select @@sql_mode; #SQL模式，生产环境、测试环境统一使用严格模式

 

11. 详细参数有待根据实际情况调整。