Linux 用tar包安装mysql

我是用Centos 6 64位安装mysql5.7.26

1.在mysql官网下载mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
https://dev.mysql.com/downloads/mysql/5.6.html#downloads


2.用xftp6上传到linux /home/xyd

3.解压安装包
[root@localhost xyd]# tar -zvxf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
将文件移动到 /usr/local 目录下，并重命名文件夹：
[root@localhost xyd]# mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql
[root@localhost xyd]# cd /usr/local/mysql

3.1、新建data目录
mkdir /usr/local/mysql/data

4.主目录权限处理
查看组和用户情况
cat /etc/group | grep mysql
cat /etc/passwd |grep mysql
若存在，则删除原mysql用户：userdel -r mysql，会删除其对应的组和用户。

5、新建mysql用户、mysql用户组
groupadd mysql
useradd mysql -g mysql

6、将/usr/local/mysql的所有者及所属组改为mysql
chown -R mysql.mysql /usr/local/mysql

7.配置
/usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data
***如果出现以下错误：

2018-07-14 06:40:32 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2018-07-14 06:40:32 [ERROR]   Child process: /usr/local/mysql/bin/mysqldterminated prematurely with errno= 32
2018-07-14 06:40:32 [ERROR]   Failed to execute /usr/local/mysql/bin/mysqld --bootstrap --datadir=/usr/local/mysql/data --lc-messages-dir=/usr/local/mysql/share --lc-messages=en_US --basedir=/usr/local/mysql
-- server log begin --

-- server log end --

***则使用以下命令：
/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize

***如果出现以下错误：

/usr/local/mysql/bin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory

*** 则执行以下命令：
yum -y install numactl

***完成后继续安装：
/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize

8.创建配置文件及相关目录
修改配置文件：my.cnf，配置不对的话,后面初始化不全,会拿不到默认密码。
vim /etc/my.cnf

[mysqld]
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
socket=/tmp/mysql.sock
user=mysql
port=3306
character-set-server=utf8
# 取消密码验证
skip-grant-tables
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# skip-grant-tables
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

:wq 保存退出

9、开启服务
#将mysql加入服务
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
# 开机自启
chkconfig mysql on
#开启
service mysql start

10、设置密码
#登录（由于/etc/my.cnf中设置了取消密码验证，所以此处密码任意）
/usr/local/mysql/bin/mysql -u root -p
#操作mysql数据库
>>use mysql;
#修改密码
>>update user set authentication_string=password(‘你的密码’) where user=‘root’;
>>flush privileges;
>>exit;

11、将/etc/my.cnf中的skip-grant-tables删除

12、登录再次设置密码（不知道为啥如果不再次设置密码就操作不了数据库了）
/usr/local/mysql/bin/mysql -u root -p
>>ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘修改后的密码’;
>>exit;

13、允许远程连接
/usr/local/mysql/bin/mysql -u root -p
>>use mysql;
>>update user set host=’%’ where user = ‘root’;
>>flush privileges;

14.查看用户
>> SELECT DISTINCT CONCAT(‘User: [’, user, ‘’’@’’’, host, ‘];’) AS USER_HOST FROM user;

15.查看端口：
mysql> show global variables like ‘port’;
mysql> quit

16.开启3306端口：
[root@localhost ~]# vim /etc/sysconfig/iptables
Firewall configuration written by system-config-firewall
Manual customization of this file is not recommended.
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
-A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited
COMMIT

注意：一定要加在后两行的前面

17.重启防火墙：
[root@localhost ~]# service iptables restart

本文主要是补充：https://www.cnblogs.com/daemon-/p/9009360.html（大部分来自这里！）