一、下载
地址:https://dev.mysql.com/downloads/mysql/
版本:
或者在linux中下载:
wget http://dev.MySQL.com/get/Downloads/MySQL-5.7/mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz
二、安装
安装libaio
yum install libaio
解压并复制
tar -zxvf mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz mkdir -p /usr/local/mysql mkdir -p /usr/local/mysql/data mv mysql-5.7.21-linux-glibc2.12-x86_64/* /usr/local/mysql/
创建mysql用户并修改权限
groupadd mysql useradd -r -g mysql mysql chown -R mysql.mysql /usr/local/mysql/
初始化数据,需要记住最后一段登录密码
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
如果报libnuma.so.1的错误就
yum remove libnuma.so.1 yum -y install numactl.x86_64
修改my.cnf
vi /etc/my.cnf max_allowed_packet = 20M
增加软链接
cd /usr/local/bin ln -fs /usr/local/mysql/bin/mysql mysql ln -fs /usr/local/mysql/bin/mysqld mysqld
三、启动
启动
/usr/local/mysql/bin/mysqld --user=root
登录、输入密码
mysql -u root -p
修改密码
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
允许远程登录
use mysql; update user set host = '%' where user = 'root';
增加root访问权限
grant all privileges on *.* to root@'%' identified by '******'; //***表示数据库连接密码 flush privileges;
四、Navicat连接阿里云
如果没有增加root访问权限,就需要:Navicat升级到11.2以上,新建连接,在常规里填写信息,其中主机名localhost,在SSH里填写信息,保存连接
如果已经增加,就只要在常规里填写信息,连接