centos7安装mysql和mysqlclient遇到的坑怎么解决

centos7安装mysql和mysqlclient遇到的坑怎么解决

1. 添加mysql yum源

mysql官网>downloads>mysql yum repository找到合适版本的yum源

$wget https://dev.mysql.com/get/mysql80-community-release-el7-2.noarch.rpm$sudo rpm -uvh mysql80-community-release-el7-2.noarch.rpm #查看mysql数据库各个版本信息$yum repolist all | grep mysql登录后复制

2. 选择安装版本

修改/etc/yum.repos.d/mysql-community.repo 文件，选择mysql5.7版本

# enable to use mysql 5.6[mysql56-community]name=mysql 5.6 community serverbaseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/7/$basearch/enabled=0 # 禁止gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/rpm-gpg-key-mysql # enable to use mysql 5.7[mysql57-community]name=mysql 5.7 community serverbaseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/enabled=1 # 安装gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/rpm-gpg-key-mysql [mysql80-community]name=mysql 8.0 community serverbaseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/7/$basearch/enabled=0 # 禁止gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/rpm-gpg-key-mysql登录后复制

3. 安装

#执行以下命令安装mysqlyum install mysql-community-server#启动mysql（centos7中）systemctl start mysqld.service#低版本的操作系统可用以下指令service mysqld start#查看mysql状态systemctl status mysqld.service#低版本操作系统可用以下指令service mysqld status登录后复制

4. 查看并修改密码

$grep "password" /var/log/mysqld.log2019-04-11t08:17:16.706096z 1 [note] a temporary password is generated for root@localhost: ux#bkam(k1q-$mysql -u root -p>ux#bkam(k1q- # 修改密码mysql>alter user 'root'@'localhost' identified by 'complex password';mysql>set global validate_password_policy=0;mysql>set global validate_password_length=1;mysql>alter user 'root'@'localhost' identified by 'simple password';登录后复制

5. 配置开放3306端口

授权的方式允许任何主机访问mysql服务器：【一般采用这个即可，限制端口访问交由firewalld来做】

mysql>grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;登录后复制

限定ip访问：

mysql>grant all privileges on *.* to 'jack'@'10.10.50.127' identified by 'password' with grant option;登录后复制

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。