1、远程登录linux服务器进入home目录下载,即执行如下命令
cd /home
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
2、rpm安装mysql
rpm -ivh mysql80-community-release-el7-3.noarch.rpm
3、安装依赖
yum -y install yum-utils
4、查看系统安装的mysql repo
yum repolist all | grep mysql
5、激活mysql5.7
yum-config-manager --disable mysql80-community
yum-config-manager --enable mysql57-community
6、安装mysql
yum -y install mysql-community-server
7、启动mysql服务
service mysqld start
8、查看mysql版本
mysql -V
9、查看root账号的登录密码
grep tempo /var/log/mysqld.log
10、复制刚才的密码登录mysql数据库
mysql -uroot -pl!dpgrnir9dW
11、修改mysql的密码设置方案(如果不需要弱密码,可以忽略这一步)
set global validate_password_policy=0;
set global validate_password_length=1;
12、修改root账户的密码
alter user user() identified by "123456";
#13、创建可以远程访问mysql用户
create user 'abc'@'%' IDENTIFIED BY '123456';
如需指定ip的用户可以访问,把%改为可以访问的ip即可
14、赋予用户所有的权限
grant all privileges on *.* to "abc"@'%';
#15、刷新MySQL的系统权限相关表
flush privileges;
#16、退出连接
quit;
#17、其他
如果想让改用户只能访问某一个数据库,把上面命令中的*.改为‘数据库名.’即可
附:删除某个用户drop user 'abc'@'%';
如果查询报错which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by,添加一下内容即可
[mysqld]
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION