博客地址:http://www.lsk-ww.cn:8080
1、ECS 查看当前Mysql可以安装的资源
yum repolist enabled | grep "mysql.*-community.*"
查询结果:可以安装6.6版本
2、ECS 安装Mysql和设置开机启动
安装mysql:
yum -y install mysql-community-server
开机启动:
systemctl enable mysqld
systemctl list-unit-files | grep mysqld
3、ECS 启动Mysql和检测是否启动成功
systemctl start mysqld #启动mysql
ps -ef|grep mysql #查看启动是否成功
检测启动成功:
4、ECS 设置Mysql root 密码并登陆
mysql_secure_installation
优先设置root 密码:
Remove anonymous users? [Y/n] y [删除匿名用户]
Disallow root login remotely? [Y/n] y [禁止root远程登录]
Remove test database and access to it? [Y/n] y [删除test数据库]
Reload privilege tables now? [Y/n] y [刷新权限]
登陆Mysql:
mysql -u root -p
修改root密码:
update user set password=password("你的新密码") where user="root";
5、ECS 本地远程连接服务器上授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
IDENTIFIED BY '你的密码' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'
IDENTIFIED BY '你的密码' WITH GRANT OPTION;
FLUSH PRIVILEGES;
ECS 防火墙设置:阿里云ECS有安全组防火墙.默认只开了ICMP,22,3389. 在服务器控制台找到 安全组–配置规则–添加安全组规则
本地可以使用navicat 客户端连接。
6、ECS 创建项目的Mysql 用户和数据库
--创建数据库用户
CREATE USER 'shop'@'localhost' IDENTIFIED BY 'shop';
GRANT USAGE ON *.* TO '用户'@'localhost' IDENTIFIED BY '密码'
WITH GRANT OPTION;
--创建数据库
drop database if exists 数据库;
create database 数据库 DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
--赋值权限
grant all privileges on 数据库.* to 用户@"%" Identified by "密码"
WITH GRANT OPTION;
grant select,insert,update,delete,create,drop on 数据库.*
to 用户@localhost Identified by "密码";
use 数据库;
FLUSH PRIVILEGES;
添加用户 :ERROR 1364 (HY000): Field ‘ssl_cipher’ doesn’t have a default value
使用Insert脚本:
insert into mysql.user(Host,User,Password)
values("localhost","用户",password("密码"));
理由:mysql5.1以上版本操作的 mysql用户表的中某些字段不能为空,没有默认值
解决方式:
grant all privileges on 数据库.* to 用户@"%" Identified by "密码"
WITH GRANT OPTION;
参考文章:https://blog.csdn.net/formelo/article/details/79255353