如何在阿里云服务器(centos7)安装、卸载mysql数据库
先谈如何卸载再说如何安装吧
卸载mysql数据库
-
使用以下命令查看当前安装mysql情况,查找以前是否装有mysql
- rpm -qa|grep -i mysql
[[email protected] ~]# rpm -qa|grep -i mysql
- 如果有可以卸载删除
- rpm -ev mysql57-community-release-el7-8.noarch.rpm
[[email protected] ~]# rpm -ev mysql57-community-release-el7-8.noarch.rpm
要是删除不了报如下错:
error: package mysql57-community-release-el7-8.noarch.rpm is not installed
[email protected] ~]# rpm -ev mysql-community-libs-compat-5.7.25-1.el7.x86_64
error: Failed dependencies:
libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.10.1-7.el7.x86_64
libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.10.1-7.el7.x86_64
2.可以试第二种方案
yum remove mysql-community mysql-community-server mysql-community-libs mysql-community-common
[[email protected] ~]# yum remove mysql-community mysql-community-server mysql-community-libs mysql-community-common
接下来再按Y 往下执行
再次查看是否卸载完毕
rpm -qa |grep -i mysql
[[email protected] ~]# rpm -qa |grep -i mysql
如果rpm –ev 删除不干净 这时候可以考虑直接暴力删除 rm –rf 文件名
接下来查看是否还有残余的数据库文件
find / -name mysql
[[email protected] ~]# find / -name mysql
/opt/zbox/tmp/mysql
/opt/zbox/bin/mysql
/opt/zbox/run/mysql
/opt/zbox/run/mysql/mysql
/opt/zbox/etc/mysql
/opt/zbox/data/mysql
/opt/zbox/data/mysql/mysql
/etc/rc.d/init.d/mysql
/usr/share/mysql
再次执行 rm –rf 文件名
rm –rf /usr/share/mysql
安装Mysql数据库
- 首先选择一个地方放置一下我们下载的数据库
我这里是安装在 usr/local/development 路径下
[[email protected] local]# mkdir development
- 接着执行命令
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
【该数据库是5.6版本】
2.接着会再次问你是否继续 输入 Y
出现complete! 表示已经成功安装完成!恭喜你
3.可以查看一下安装是否成功!
rpm -qa | grep -i mysql
[[email protected] development]# rpm -qa | grep -i mysql
4.设置开启启动mysql服务:systemctl enable mysqld
[[email protected] development]# systemctl enable mysqld
5.启动MySQL服务:systemctl restart mysqld
[[email protected] development]# systemctl restart mysqld
6.查看MySQL初始密码:grep 'A temporary password' /var/log/mysqld.log
[[email protected] development]# grep 'A temporary password' /var/log/mysqld.log
7.进入数据库 新安装的数据库是默认没有密码的
[[email protected] development]# mysql -u root -p
8.可以查看数据信息等
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)
10.设置mysql能够远程访问:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root123' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root123' WITH GRANT
Query OK, 0 rows affected (0.00 sec)
mysql> quit;
Bye
11.登录进MySQL:mysql -uroot -p密码 至此数据库已近成功安装完毕
- 配置阿里云服务器
- 打开管理后台
- 看这里,打开创建的实例,点击右边更多
点击最右边安全组配置,需要配置入口端口。
- 选择配置规则,对入方向进行配置
- 选择添加安全组规则,开启3306端口。授权对象选择0.0.0.0/0所有ip可访问,如果添加限制可以点击旁面的小叹号。
- 一定要重启服务器,必须要。。。
好了,本地连接试下。