系统平台:腾讯云服务器:CentOs 7.4
参考文档:https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/#repo-qg-yum-fresh-install
附
docker安装一步到位
docker run -itd --name dante -p 3306:3306 -e MYSQL_ROOT_PASSWORD=Strive@009 mysql:5.7
一、安装
1.执行yum list |grep mysql,查看是否存在mysql的yum源,查看是否存在mysql-community-*
2.下载repo源,源地址:https://dev.mysql.com/downloads/repo/yum/
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
3.安装
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum -y install mysql-server
二、启动及初始配置
查看mysql版本:mysql -V
1.启动
service mysqld start #启动
service mysqld status #查看状态
2.重置密码,初始状态,root是没有密码的,回车即可登录,登录后重置密码
mysql -uroot -p #提示输入密码,回车即可
mysql> update user set password=password("123456") where user="root"; #重置密码
mysql>update user set host = '%' where user = 'root'; #允许远程连接
mysql>select host, user from user; #查看
mysql> flush privileges;
mysql> quit
3.安装navicat,https://www.navicat.com.cn/products/navicat-for-mysql