5
MySQL-5.7.16(rpm)安装文档
source link: https://blog.51cto.com/simplelife/5092106
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
MySQL-5.7.16(rpm)安装文档
原创1. 卸载系统自带的MySQL
# 检查mariadb安装包
rpm -qa | grep -i mysql
rpm -qa | grep -i mariadb
# 卸载查找到的mariadb安装包
rpm -e mariadb-libs-5.5.50-1.el7_2.x86_64
#注：如上命令删除不成功，有别的软件依赖无法删除时，如下操作：
yum -y remove mariadb-libs-5.5.50-1.el7_2.x86_64
rpm -qa | grep -i mysql
rpm -qa | grep -i mariadb
# 卸载查找到的mariadb安装包
rpm -e mariadb-libs-5.5.50-1.el7_2.x86_64
#注：如上命令删除不成功，有别的软件依赖无法删除时，如下操作：
yum -y remove mariadb-libs-5.5.50-1.el7_2.x86_64
2. 下载
官网下载：
https://www.mysql.com/downloads/
百度云下载：
链接: https://pan.baidu.com/s/1MtnytvmfEWwCxAA8fz3Dng 提取码: mrng
3. 解压
# 下载完后放到/opt/mysql目录下，解压
tar -xvf mysql-5.7.16-1.el7.x86_64.rpm-bundle.tar
tar -xvf mysql-5.7.16-1.el7.x86_64.rpm-bundle.tar
4. 安装服务
rpm -ivh mysql-community-common-5.7.16-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.16-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.16-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.16-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.16-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.16-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.16-1.el7.x86_64.rpm
5. 数据库初始化
在 Liunx 系统中，为了保证数据库目录为与文件的所有者为 mysql 登陆用户，如果你是以 root 身份运行 mysql 服务，需要执行下面的命令初始化
mysqld --initialize --user=mysql
如果是以 mysql 身份运行，则可以去掉 --user 选项。
另外 --initialize 选项默认以“安全”模式来初始化，则会为 root 用户生成一个password并将该password标记为过期，登陆后你需要设置一个新的password，而使 用 --initialize-insecure 命令则不使用安全模式，则不会为 root 用户生成一个password。
这里演示使用的 --initialize 初始化的，会生成一个 root 账户临时password，临时password在log文件里
6. 启动MySQL服务
# 启动
systemctl start mysqld
# 查看状态
systemctl status mysqld
# 停止
systemctl stop mysqld
systemctl start mysqld
# 查看状态
systemctl status mysqld
# 停止
systemctl stop mysqld
7. 临时password登录
mysql -uroot -p
[输入临时password]
[输入临时password]
8. 修改password、授权
mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
# 因为该password被标记为过期了，如果想正常使用还需要修改password。
# 修改password
SET PASSWORD = PASSWORD('123456');
# 授权远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
# 刷新权限
FLUSH PRIVILEGES;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
# 因为该password被标记为过期了，如果想正常使用还需要修改password。
# 修改password
SET PASSWORD = PASSWORD('123456');
# 授权远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
# 刷新权限
FLUSH PRIVILEGES;
- 打赏
- 赞
- 收藏
- 评论
- 分享
- 举报
上一篇：Flume部署文档
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK