CentOS安装MySQL 5.7.9

最新推荐文章于 2021-03-03 20:57:51 发布

持盾的紫眸

最新推荐文章于 2021-03-03 20:57:51 发布

阅读量532

点赞数

分类专栏：数据库 Linux 文章标签： centos mysql 数据库安装 mysql5-7-64位

本文链接：https://blog.csdn.net/zimou5581/article/details/78772224

版权

本文档详细介绍了如何在CentOS服务器上安装MySQL 5.7.9，包括上传安装包、创建用户组和目录、安装依赖、初始化数据库、设置配置文件、解决启动问题、配置开机自启、设置root密码、开启远程访问及防火墙端口开放等步骤。

摘要由CSDN通过智能技术生成

在CentOS数据库服务器上安装MySQL 5.7.9
上传mysql安装包：mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz

创建mysql的用户组/用户，用户目录，data目录

groupadd mysql
useradd -g mysql -d /home/mysql mysql
mkdir /home/mysql/data

tar -zxf mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz
cd mysql-5.7.9-linux-glibc2.5-x86_64 
mv * /home/mysql

检查安装依赖库，初始化mysql数据库

cd /home/mysql
yum install libnuma* -y
./bin/mysqld --user=mysql --basedir=/home/mysql --datadir=/home/mysql/data --initialize

2017-12-08T11:36:43.333530Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-12-08T11:36:43.523991Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-12-08T11:36:43.553143Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-12-08T11:36:43.676686Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 10bf176f-dc0c-11e7-aa05-000c2939f216.
2017-12-08T11:36:43.677511Z 0 [Warning] Gtid table is not ready to be used. Table ‘mysql.gtid_executed’ cannot