引言:很多新手同学不会用linux安装MySql,看文档就是做不出来。
如何在阿里云linux CentOS7快速安装Mysql?教你用简单的方式搞定!
安装MySQL5.7(注意,MySQL和系统务必保持一致,不然存在不一致)
开启MySQL远程连接(如果是准线上,建议不要开启远程连接)
开放阿里云网络安全组配置3306端口
导入测试数据到MySQL
1.下载MySQL的Yum仓库
wget -i -c [/get/mysql57-community-release-el7-10.noarch.rpm](/get/mysql57-community-release-el7-10.noarch.rpm)
yum -y install mysql57-community-release-el7-10.noarch.rpm
2.安装MySQL服务
yum -y install mysql-community-server
3.启动数据库服务, systemctl 该命令可用于查看系统状态和管理系统及服务,centos7上开始使用
systemctl start mysqld.service
4.查看状态
systemctl status mysqld.service
5.在日志文件中查看初始密码
grep "password" /var/log/mysqld.log
6.进入修改Mysql密码
mysql -uroot -p
7.新密码设置必须由大小写字母、数字和特殊符号组成
ALTER USER 'root'@'localhost' IDENTIFIED BY '168';
8.开启mysql的远程访问, %是指全部
grant all privileges on *.* to 'root'@'%' identified by '168' with grant option;
9.刷新权限
flush privileges;
注:视频版请查看“https://mp./s?__biz=MzUyMDg1MDE2MA==&mid=2247488021&idx=1&sn=92ac745008f2ec960a84f8419f59e4f5&chksm=f9e54d8ace92c49cb6ef6e96ffa26cc71c70ca07655a2956281ecbea4f939a8f053907159e14&mpshare=1&scene=1&srcid=0803pJREk0F6cHSb82BBrppz&sharer_sharetime=1596506995577&sharer_shareid=0c279111e5844f7ce24ca50e9a07a50f&key=461d0d4ae0561348d31629ffcfa55224e2322fbf094be5dc0f50955bf1d0aa60451a5b754a95dddb17ecd60cee2e7dce08b05de88377d3fc220cd2cc35fc1295b63da6274c3899079ffa3637be6eda36&ascene=1&uin=Mjc1MzQ5MjgzOQ%3D%3D&devicetype=Windows+10+x64&version=62090070&lang=zh_CN&exportkey=A4vp91ZliwBB98JPzZ%2BtFAk%3D&pass_ticket=h%2Fr7zXQD4BQqdjmtbp%2FgRpr%2Fx64KmYaNWikm1K%2BFqWudM%2FOsA8lZwd%2Bnbj8FN%2BbT”
如果觉得《linux云安装mysql_1.Linux系统安装MySql数据库(阿里云)》对你有帮助,请点赞、收藏,并留下你的观点哦!