mysql yum rpm包这么小_MySQL（二）yum源与rpm包方式安装

以下实践操作是在 liux-centos7 上安装配置

1、官网下载包

2、安装yum mysql 仓库

[[email protected] ~]# yum install -y https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm

#查看yum mysql仓库[[email protected] ~]# ls /etc/yum.repos.d/

2.1、如果想使用本地rpm文件，则修改文件 mysql.community.repo文件

[[email protected] ~]# cat /etc/yum.repos.d/

[[email protected] ~]# vim /etc/yum.repos.d/mysql-community.repo

[mysql-connectors-community]

name=MySQL Connectors Community

baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/7/$basearch/ #这里配置成本地文件路径

enabled=1 #1 开启 0关闭gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql # 设置成0不用检查

[mysql-tools-community]

name=MySQL Tools Community

baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/7/$basearch/ #这里配置成本地文件路径

enabled=1 # 1-开启 0-关闭gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql # 设置成0不用检查

3、查看过滤mysql包

[[email protected] ~]# yum list | grep "mysql-community"mysql-community-server.x86_64 5.7.19-1.el7 mysql57-community

mysql-community-client.x86_64 5.7.19-1.el7 mysql57-community

4、安装服务端和客户端

[[email protected] ~]# yum install mysql-community-client mysql-community-server -y

或

yum install mysql-community-server

5、启动mysql服务

[[email protected] ~]# systemctl start mysqld

6、登录mysql

#查看密码

[[email protected] ~]# grep ‘temporary password‘/var/log/mysqld.log

[[email protected] ~]# mysql -uroot -p

Enter password:

[[email protected] ~]# set global validate_password_policy=0;

[[email protected] ~]# set global validate_password_length=1;

[[email protected] ~]# ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘123456‘;

8、重启服务并登录

[[email protected] ~]# systemctl restart mysqld

[[email protected] ~]# mysql-uroot -p

Enter password:123456

9、授权远程登录并刷新权限

GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘your_root_password‘ WITH GRANT OPTION;

FLUSH PRIVILEGES;

10、默认配置文件路径：

配置文件：/etc/my.cnf

日志文件：/var/log//var/log/mysqld.log

服务启动脚本：/usr/lib/systemd/system/mysqld.service

socket文件：/var/run/mysqld/mysqld.pid

#(a)数据库目录

/var/lib/mysql/

#(b)配置文件

/usr/share /mysql(mysql.server命令及配置文件)

#(c)相关命令

/usr/bin(mysqladmin mysqldump等命令)

#(d)启动脚本

/etc/rc.d/init.d/(启动脚本文件mysql的目录)

如果忘记root密码，则按如下操作恢复

#在[mysqld]的段中加上一句：skip-grant-tables 保存并且退出vi。

mysql-u root

update mysql.userset authentication_string=password(‘123qwe‘) where user=‘root‘ and Host = ‘localhost‘;

flush privileges

如此文对你有帮助，请打赏作者或推荐此文，在此多谢了~

      

原文：https://www.cnblogs.com/louby/p/10207310.html