解压缩放倒目录下,改压缩包会生成多个文件
tar -xvf mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar
删除 mariadb
rpm -qa | grep mariadb --查看是否有mariadb
rpm -e mariadb-libs-5.5.44-2.el7.centos.x86_64 --nodeps --删除
安装
rpm -ivh mysql-community-common-5.7.12-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.12-1.el6.x86_64.rpm
rpm -ivh mysql-community-client-5.7.12-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.12-1.el6.x86_64.rpm
修改配置文件
cd /etc
vi my.cnf
增加服务端和客户端编码
服务端
[mysqld]
character-set-server=utf8
客户端
[client]
default-character-set=utf8
启动mysql
进入到/etc/init.d目录下
systemctl start mysqld --启动
systemctl start mysqld --停止
ps -ef|grep mysql --查看mysql进程
第一次登录密码的查看
more /var/log/mysqld.log
显示密码在下面的行,并记录下来
A temporary password is generated for root@localhost: 8O8TkU#mEqre
登录mysql
第一次登录mysql不能使用远程,需要进行设置
登录命令如下
mysql -uroot -p8O8TkU\#mEqre
修改root的密码
alter user 'root'@'localhost' identified by 'password';
flush privileges;
关闭防火墙,允许3306端口
systemctl status firewalld --查看状态
systemctl stop firewalld -- 关闭
systemctl start firewalld --打开防火墙
设置允许远程登录
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
flush privileges;
Centos7下安装mysql5.7
最新推荐文章于 2024-07-26 00:20:55 发布