首页 > 数据库技术 > 详细

centos8 安装mysql5.7.33

时间:2021-03-10 15:24:29      阅读:35      评论:0      收藏:0      [点我收藏+]

1 下载mysql

https://dev.mysql.com/downloads/mysql/

2 上传mysql压缩包到系统中

3 解压mysql压缩包 并移动到/usr/local文件夹下

tar zxvf mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz

mv mysql-5.7.33-linux-glibc2.12-x86_64 mysql

mv mysql /usr/local/

4 处理依赖

yum search libaio

yum install libaio

yum install libncurses*

5 设置权限

为centos添加mysql用户组和mysql用户(-s /bin/false参数指定mysql用户仅拥有所有权,而没有登录权限):

groupadd mysql useradd -r -g mysql -s /bin/false mysql

6 修改mysql目录权限

进入安装mysql软件的目录,命令如下:

cd /usr/local/mysql

修改当前目录拥有者为新建的mysql用户,命令如下:

chown -R mysql:mysql ./

7 创建数据存储目录 并授权

mkdir –p /usr/local/mysql/data

chown -R mysql:mysql ./

8 执行安装

./bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ –initialize

[root@mysql5 mysql]# ./bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --initialize
2021-03-10T13:34:43.269366Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-03-10T13:34:43.422428Z 0 [Warning] InnoDB: New log files created, LSN=45790
2021-03-10T13:34:43.452588Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-03-10T13:34:43.461956Z 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: 5f5f97d9-81a5-11eb-b807-000c2931e704.
2021-03-10T13:34:43.462977Z 0 [Warning] Gtid table is not ready to be used. Table ‘mysql.gtid_executed‘ cannot be opened.
2021-03-10T13:34:44.778920Z 0 [Warning] CA certificate ca.pem is self signed.
2021-03-10T13:34:44.959886Z 1 [Note] A temporary password is generated for root@localhost: v&C/WLrd4mC3
[root@mysql5 mysql]#

默认密码为 最后的随机字符串

本例子中为 v&C/WLrd4mC3

9 开启mysql服务

./support-files/mysql.server start

10 将mysql进程放入系统进程中,命令如下:

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

11.重新启动mysql服务,命令如下:

service mysqld restart

12 添加mysql环境变量

export PATH=$PATH:/usr/local/mysql/bin

13 修改root密码

mysql –u root –p

输入密码

alter user ‘root’@’localhost’ identified by ‘111111’;

flush privileges;

exit;

14 用新密码登录

mysql –u root –p111111

 

centos8 安装mysql5.7.33

原文:https://www.cnblogs.com/fb010001/p/14511673.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!