CentOS 安装Mysql 5.7
Windows下安装请跳转:
https://dev.mysql.com/downloads/installer/
参考:https://www.linuxidc.com/Linux/2016-09/135288.htm
CentOS 6.x安装Mysql5.7(下载安装)
CentOS 6使用yum安装Mysql5.7会出现libc相关的错误。故使用下载安装。
首先卸载旧的MySql5.1
- 查看是否安装有mysql
yum repolist all|grep mysql
yum repolist enabled|grep mysql
rpm -qa|grep -i mysql
- 删除旧的mysql
rpm -e --nodeps mysql-community-server-*
rpm -e --nodeps mysql-community-common-*
rpm -e --nodeps mysql-community-client-*
rpm -e --nodeps mysql-community-libs-*
- 删除mysql老版本的残留文件
rm -rf /usr/lib/mysql
rm -rf /usr/include/mysql
注意:卸载后/var/lib/mysql
和/etc/my.cnf
不会删除,如果确定没用后就手工删除;rm -rf /etc/my.cnf
rm -rf /var/lib/mysql
安装Mysql5.7
- 下载:
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.23-1.el6.x86_64.rpm-bundle.tar
- 解压:
tar -xvf mysql-5.7.23-1.el6*
- 安装:
rpm -ivh mysql-community-common* rpm -ivh mysql-community-libs* rpm -ivh mysql-community-client* rpm -ivh mysql-community-server*
- 修改配置
vi /etc/my.cnf
:[client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] port = 2433 character-set-server = utf8mb4 collation-server = utf8mb4_general_ci init_connect='SET NAMES utf8mb4' lower_case_table_names = 1 max_connections = 400 max_connect_errors = 1000 max_allowed_packet = 1G validate_password=OFF tmp_table_size=256M max_heap_table_size=256M
- 如果不想将数据存到默认路径下,建立软链接:
mv /var/lib/mysql /data/mysqldata
chown -R mysql:mysql /data/mysqldata
ln -s /data/mysqldata /var/lib/mysql
- 查看默认密码:
grep 'temporary password' /var/log/mysqld.log
- 启动:
services mysqld start
- 设置开机自启动:
chkconfig mysqld on
- 登陆:
mysql -uroot -p
- 修改默认密码:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpassword');
- 创建远程用户:
grant all on *.* to root@'%' identified by'newpassword';
- 刷新权限表:
flush privileges;
- 创建数据库
CentOS 7.x安装Mysql5.7(Yum安装)
1. 配置YUM源
#下载mysql源安装包
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
#安装mysql源
yum localinstall mysql57-community-release-el7-8.noarch.rpm
检查mysql源是否安装成功
yum repolist enabled | grep mysql
看到上图所示表示安装成功。
可以修改vim /etc/yum.repos.d/mysql-community.repo
源,改变默认安装的mysql版本。比如要安装5.6版本,将5.7源的enabled=1改成enabled=0。然后再将5.6源的enabled=0改成enabled=1即可。改完之后的效果如下所示:
2. 安装MySQL
yum install -y mysql-community-server
3. 启动MySQL服务
systemctl start mysqld
(CenteOS6是:service mysqld start
)
4. 开机自启
systemctl enable mysqld
systemctl daemon-reload
(CentOs6下用:chkconfig mysqld on
设置开机自启动,chkconfig --list|grep mysqld
检查状态)
5. 修改root本地登陆密码
mysql安装完成之后,在/var/log/mysqld.log
文件中给root生成了一个默认密码。通过下面的方式找到root默认密码,然后登录mysql进行修改:grep 'temporary password' /var/log/mysqld.log
如图,随机密码为:kq?,-Zq_5m+w
然后根据得到的密码登陆:
mysql -uroot -p
修改密码:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
这时候修改本地密码会报错,因为mysql5.7对默认密码有复杂度限制。
如果不需要修改配置关闭校验。
6. 修改/etc/my.cnf
添加如下字段:
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
port = 3306
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
init_connect='SET NAMES utf8mb4'
lower_case_table_names = 1
max_connections = 400
max_connect_errors = 1000
max_allowed_packet = 1G
validate_password=OFF
tmp_table_size=256M
max_heap_table_size=256M
7. 配置修改后需要重启
CentOS7: systemctl restart mysqld
CentOS6: service mysqld restart
转载请注明来源,欢迎对文章中的引用来源进行考证,欢迎指出任何有错误或不够清晰的表达。可以在下面评论区评论,也可以邮件至 using1174@foxmail.com
文章标题: CentOS 安装Mysql 5.7
文章字数: 808
本文作者: Jun
发布时间: 2018-06-15, 11:03:00
最后更新: 2022-05-06, 23:36:31
原始链接: http://yoursite.com/2018/06/15/CentOS-7安装Mysql-5-7/版权声明: "署名-非商用-相同方式共享 4.0" 转载请保留原文链接及作者。