阿里云ECS服务器(CentOS7.3)安装MySQL数据库
Linux学习
下载rpm源forMySQL
如下,直接使用yum命令下载mysql来进行安装是不能成功的:
下载路径为:http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
rpm源地址:https://dev.mysql.com/downloads/repo/yum/rpm
源地址:https://dev.mysql.com/downloads/repo/yum/
MySQL5.7: https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
- 使用rpm命令来进行下载
#下载
rpm -Uvh https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
- 下载完成之后查看一下都有哪些mysql的文件
yum repolist enabled | grep "mysql.*-community.*"
- 使用yum方式进行安装,显示Complete即完成
yum repolist enabled | grep "mysql.*-community.*"
配置MySQL
- 启动MySQL并查看状态
[root@localhost ~]# systemctl start mysqld
[root@localhost ~]# systemctl status mysqld
- 查看MySQL默认密码
[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log
- 输入账户默认密码并登陆
[root@localhost ~]# mysql -uroot -p
- 修改自定义密码
mysql> SET PASSWORD = PASSWORD('密码');
- 添加远程访问权限
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Ls123456.' WITH GRANT OPTION;
#刷新系统权限表
mysql> flush privileges;
- 利用本机Navicat测试连接,主机:输入你的阿里云公网ip