2018-04-12

安装在/usr/local/下，配置文件在/etc/my.ini

1.下载mysql安装包到 /usr/local/software

cd /usr/local/software

wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz

2.安装依赖环境

yum -y install perl perl-devel autoconf libaio

yum install -y perl-Data-Dumper

3.解压安装包

tar zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz

4.复制安装包至 /usr/local 下 并修改文件夹名为 mysql

cp mysql-5.6.33-linux-glibc2.5-x86_64 /usr/local/mysql -r

5.添加系统mysql组和mysql用户

groupadd mysql

useradd -r -g mysql -s /bin/false mysql

6.进入 /usr/local/mysql 修改目录拥有者为mysql用户

cd mysql/

chown -R mysql:mysql ./

7.进行安装

./scripts/mysql_install_db --user=mysql

8.修改当前目录拥有者为root用户

chown -R root:root ./

9.修改当前data目录拥有者为mysql用户

chown -R mysql:mysql data

10.添加mysql服务开机自启动

cp support-files/mysql.server /etc/init.d/mysql

# 赋予可执行权限

# 添加服务

# 显示服务列表

chmod +x /etc/init.d/mysql

chkconfig --add mysql

chkconfig --list

11.启动mysql服务

#创建缺少的文件夹

mkdir /var/log/mariadb

service mysql start

12.添加软连接

ln -s /usr/local/mysql/bin/mysql /usr/local/bin/mysql

ln -s /usr/local/mysql/bin/mysqldump /usr/local/bin/mysqldump

13.解决ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

建立一个软连接：ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

14.配置my.ini 打开/etc/my.cnf

在[mysqld]后面任意一行添加“skip-grant-tables”在[mysqld]上面加入下面两句话

[client]

default-character-set=utf8

在[mysqld]最下面加入下面几句话

default-storage-engine=INNODB

character-set-server=utf8

collation-server=utf8_general_ci

skip-grant-tables #用来跳过密码验证的过程

15.保存 /etc/my.cnf 并重启mysql 服务器

service mysql restart

 

16.修改root登录密码

mysql

use mysql;

update user set password=password("新密码") where user="root";

flush privileges;

17.删除匿名用户，使用root用户登陆数据库

delete from mysql.user where User=''; flush privileges;

18.修改其他客户端连接数据库权限

UPDATE user SET `Host` = '%' WHERE `User` = 'root' LIMIT 1;

flush privileges;

19.阿里云服务器开启3306端口，外部才能连接3306

网络和安全-安全组-配置规则-添加安全规则