CentOS7安装mysql教程_centos 7装msyql教程

$$CentOS7安装mysql教程$$

1、检查系统是否装有mysql

rpm -qa | grep mysql
1

返回空值，说明没有安装

2.删除可用

yum remove mysql
1

3.下载mysql的repo源

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
1

4.安装mysql-community-release-el7-5.noarch.rpm包

sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
1

安装这个包后，会获得两个mysql的yum repo源：

/etc/yum.repos.d/mysql-community.repo
/etc/yum.repos.d/mysql-community-source.repo
1
2

5.安装mysql

sudo yum install mysql-server
1

安装后再次查看mysql

rpm -qa | grep mysql
1

6.安装完成后，没有密码，需要重置密码

6.1赋权限

chown root /var/lib/mysql/
1

6.2 查看是否赋权

cd /var/lib/
ll
1
2

查看mysql服务是否启动

service mysqld status
1

如果未启动，则启动

service mysqld start

1
2

6.3登录

mysql -u root
1

6.4重置密码

use mysql;
1

update user set password=password('123456') where user='root';
1

exit;
1

service mysqld restart
1

7.测试

mysql -uroot -p123456
1

8.为root添加远程连接的能力

设置数据库用户在所有ip下以及在本地可访问,以下用root用户做演示

grant all privileges on *.* to root@"%" identified by "你的密码";
grant all privileges on *.* to root@"localhost" identified by "你的密码";
flush privileges;
1
2
3

9.查询数据库编码格式，确保是UTF-8

show variables like "%char%";
1

需要修改编码格式为UTF-8，导入数据库sql的时候，确保sql文件为utf8编码

set names utf8;
1

补充：

---

开发3306端口

firewall-cmd --reload ```
1

---

如果报错，内容含有
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
解决：

yum install glibc.i686
yum list libstdc++*