linux安装mysql5.5步骤

原创于 2023-04-17 11:41:58 发布 · 581 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#运维

该文详细描述了在Linux系统中卸载MariaDB，安装MySQL5.7社区版的过程，包括启动和检查服务状态，设置root用户密码，修改配置文件以实现表名不区分大小写，以及开启防火墙3306端口的步骤。

/mysql安装开始/
cmd> rpm -qa | grep mariadb
cmd> sudo rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64
cmd> sudo yum -y install wget
cmd> wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm;
cmd> sudo yum -y install mysql57-community-release-el7-10.noarch.rpm;
cmd> sudo yum -y install mysql-community-server;
cmd> sudo systemctl start mysqld.service;
cmd> sudo systemctl status mysqld.service;
cmd> sudo yum -y remove mysql57-community-release-el7-10.noarch;
cmd> sudo grep “password” /var/log/mysqld.log;
//打印日志，查看生成的root用户的随机密码
cmd> generated for root@localhost: uQONW%*#k4D#
cmd> mysql -u root -p
//输入随机密码
mysql>set global validate_password_policy=0;
mysql>set global validate_password_length=1;
mysql>ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘1234#1234’;
mysql>use mysql
mysql>UPDATE user SET Host = ‘%’ where User = ‘root’;
mysql>flush privileges;

//设置MySQL不区分表名大小写
cmd>sudo vi /etc/my.cnf
增加一行 lower_case_table_names=1
cmd> sudo systemctl stop mysqld.service;
cmd> sudo systemctl start mysqld.service;
/mysql安装完成/

/防火墙开放3306端口/
cmd>systemctl status firewalld
cmd>sudo firewall-cmd --add-port=9080/tcp --permanent
cmd>sudo systemctl stop firewalld.service
cmd>sudo systemctl start firewalld.service