官网地址:https://dev.Mysql.com/downloads/mysql/ 下载 Select Operating System: 选择 Red Hat ,Centos 是基于红帽的,Select OS
官网地址:https://dev.Mysql.com/downloads/mysql/
Select Operating System: 选择 Red Hat ,Centos 是基于红帽的,Select OS Version: 选择 linux 7
选择 RPM Bundle 点击 Download
tar -xvf mysql-8.0.21-1.el7.x86_64.rpm-bundle.tar
mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar解压后有如下8个文件:
[root@VM_0_2_centos home]# tar -xvf mysql-8.0.21-1.el7.x86_64.rpm-bundle.tar
mysql-commUnity-common-8.0.21-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.21-1.el7.x86_64.rpm
mysql-community-libs-8.0.21-1.el7.x86_64.rpm
mysql-community-devel-8.0.21-1.el7.x86_64.rpm
mysql-community-server-8.0.21-1.el7.x86_64.rpm
mysql-community-client-8.0.21-1.el7.x86_64.rpm
mysql-community-libs-compat-8.0.21-1.el7.x86_64.rpm
mysql-community-test-8.0.21-1.el7.x86_64.rpm
建议装之前先把之前的mysql相关包全部卸载,rpm -e --nodeps <包名>即可
rpm -qa | grep mariadb
rpm -e --nodeps mariadb-libs-5.5.65-1.el7.x86_64
rpm -ivh mysql-community-common-8.0.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.0.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compat-8.0.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-test-8.0.21-1.el7.x86_64.rpm
安装截图如下(注意顺序):
rpm -ivh mysql-community-common-8.0.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.0.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.21-1.el7.x86_64.rpm
yum install -y libnuma*
rpm -ivh mysql-community-server-8.0.21-1.el7.x86_64.rpm
yum install -y openssl-devel.x86_64 openssl.x86_64
rpm -ivh mysql-community-devel-8.0.21-1.el7.x86_64.rpm
yum install -y perl.x86_64 perl-devel.x86_64
yum install -y perl-JSON.noarch
yum -y install autoconf
rpm -ivh mysql-community-test-8.0.21-1.el7.x86_64.rpm
mysql -V
显示如下信息说明安装成功
ll /etc/my.cnf
-rw-r--r-- 1 root root 1243 Jun 17 01:58 /etc/my.cn
vim /etc/my.cnf
添加如下信息:
#配置MYSQL大小写敏感(1-不敏感,0-敏感)
lower_case_table_names=1
注意!MySQL8.0想要 大小写不敏感,必须在安装好MySQL后未启动之前 修改MySQL配置文件设置为不敏感,一旦启动后,再设置是无效的,而且启动会报错。
如果已经晚了,那必须把MySQL数据库文件全部 删除,修改配置文件再启动。
如果数据不重要,可以先关闭服务删掉数据,再执行以上操作:
service mysqld stop rm -rf /var/lib/mysql
mysqld --initialize --console
chown -R mysql:mysql /var/lib/mysql/
systemctl start mysqld
备注:
停止命令:service mysqld stop
service mysqld status
cat /var/log/mysqld.log
mysql -u root -p
+ 回车键
alter USER "root"@"localhost" IDENTIFIED BY "密码";
密码:必须包含数字及大小写字母特殊字符
依次执行下列mysql命令 授权远程连接
查看所有用户是否可以远程连接,依次执行下列命令:
show databases;
use mysql;
select host, user, authentication_string, plugin from user;
修改root用户host值,使root用户可以远程登录
update user set host = "%" where user="root";
flush privileges;
--结束END--
本文标题: 阿里云服务器 Centos 7 安装 MySQL Community Server 8.0.21
本文链接: https://www.lsjlt.com/news/7750.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-13
2024-05-13
2024-05-13
2024-05-13
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-12
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0