linux的mysql离线安装
Mysql 离线安装:
1. 查看是否有mariadb,并卸载
在Centos 7上先要卸载mariadb
查看是否有mariadb,并卸载
rpm -qa|grep mariadb
$ rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64
$ rpm -e --nodeps mariadb-devel-5.5.60-1.el7_5.x86_64
$rpm -e --nodeps mariadb-5.5.60-1.el7_5.x86_64
2. 官方网站下载mysql community server
官方网站下载mysql community server
https://dev.mysql.com/downloads/mysql/5.7.html#downloads
3.下载后上传至服务器上,解压
[[email protected] yum]$ tar -xvf mysql-5.7.25-1.el7.x86_64.rpm-bundle.tar
4.安装,必须按照下面的顺序安装,有前后向依赖关系。
[[email protected] yum]$ sudo rpm -ivh mysql-community-common-5.7.25-1.el7.x86_64.rpm
[[email protected] yum]$ sudo rpm -ivh mysql-community-libs-5.7.25-1.el7.x86_64.rpm
[[email protected] yum]$ sudo rpm -ivh mysql-community-client-5.7.25-1.el7.x86_64.rpm
[[email protected] yum]$ sudo rpm -ivh mysql-community-server-5.7.25-1.el7.x86_64.rpm
[[email protected] yum]$ sudo rpm -ivh mysql-community-devel-5.7.25-1.el7.x86_64.rpm
[[email protected] yum]$ sudo rpm -ivh mysql-community-libs-compat-5.7.25-1.el7.x86_64.rpm
5.初始化
[[email protected] yum]$sudo mysqld --initialize --user=mysql
查看root账号mysql的密码
cat /var/log/mysqld.log
6.启动mysql服务
systemctl start mysqld
7.登录MySQL,修改密码
mysql> set password=password('123456');
Query OK, 0 rows affected, 1 warning (0.00 sec)
8.添加用户远程登录权限
(1)、新建用户远程连接mysql数据库
grant all on *.* to [email protected]'%' identified by '123456' with grant option;
flush privileges;
允许任何ip地址(%表示允许任何ip地址)的电脑用admin帐户和密码(123456)来访问这个mysql server。
注意admin账户不一定要存在。
(2)、支持root用户允许远程连接mysql数据库
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;
然后,用户可以通过客户端用root/admin连接到mysql服务。