A: mysql5.7静默安装
参考: https://my.oschina.net/u/2007391/blog/808656
1.下载
1 2 3 4 |
cd /opt wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz tar xvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql |
2.路径配置
1 2 |
basedir=/opt/mysql datadir=/opt/mysql/data |
2.新增mysql用户
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
groupadd mysql useradd -r -g mysql mysql cd /opt mkdir /opt/mysql/data chown -R mysql:mysql mysql //mysql初始化 ./bin/mysql_install_db --user=mysql --basedir=/opt/mysql/ --datadir=/opt/mysql/data/ -- 如遇错误-- /opt/mysql/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory yum install libaio |
3.配置文件修改
1 2 3 4 5 6 7 8 9 10 |
cp -a ./support-files/my-default.cnf /etc/my.cnf cp -a ./support-files/mysql.server /etc/init.d/mysqld //修改以上文件,修改以下内容 basedir=/opt/mysql datadir=/opt/mysql/data //非默认安装目录还需配置mysqld mkdir -p /usr/local/mysql/bin ln -s /opt/mysql/bin/mysqld /usr/local/mysql/bin/mysqld |
4.mysql权限配置
1 2 3 4 5 6 7 8 9 |
cat /root/.mysql_secret //启动mysql /etc/init.d/mysqld start //客户端登录 ./mysql -uroot -p SET PASSWORD = PASSWORD('root'); use mysql update user set host = '%' where user = 'root'; |
B: yum 安装
在CentOS7上使用yum安装MySQL 5.7 https://blog.frognew.com/2017/05/yum-install-mysql-5.7.html
CentOS 7 下 MySQL 5.7 的安装与配置 https://www.jianshu.com/p/1dab9a4d0d5f
mysql 安装完成之后,生成的默认密码在
/var/log/mysqld.log
文件中。使用 grep 命令找到日志中的密码。安装: https://blog.frognew.com/2017/05/yum-install-mysql-5.7.html
1 2 3 4 5 |
wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm yum localinstall mysql57-community-release-el7-11.noarch.rpm yum repolist enabled | grep "mysql.*-community.*" yum repolist all | grep mysql yum -y install mysql-community-server |
1 |
vim /etc/my.cnf |
1 2 3 4 5 6 7 8 9 |
#加入 [mysqld] character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci default-storage-engine=INNODB [client] default-character-set=utf8mb4 [mysql] default-character-set=utf8mb4 |
开机启动和启动mysql
1 2 |
systemctl enable mysqld systemctl start mysqld |
查看初始密码:
1 |
grep 'temporary password' /var/log/mysqld.log |
//客户端登录,第一次要修改账号和创建默认账户,否则以后很难搞
1 2 3 4 5 6 7 8 9 |
mysql -uroot -p mysql>set global validate_password_policy=0; mysql>set global validate_password_length=4; mysql>SET PASSWORD = PASSWORD('123456'); mysql>use mysql mysql>update user set host = '%' where user = 'root'; mysql>CREATE USER 'pandy'@'%' IDENTIFIED BY '123456'; mysql>GRANT ALL PRIVILEGES ON *.* TO 'pandy'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; mysql>flush privileges; |