liunx二进制包安装5.6MySQL数据库

 
官网下载对应的二进制版本安装包   https://downloads.mysql.com/archives/community/
 
# 解压二进制压缩包
[root@localhost ~]# wget https://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.20-linux-glibc2.5-x86_64.tar.gz
[root@localhost ~]# tar xf mysql-5.5.32-linux2.6-x86_64.tar.gz -C /usr/local/
[root@localhost ~]# cd /usr/local/mysql-5.5.32-linux2.6-x86_64/
[root@localhost mysql-5.5.32-linux2.6-x86_64]# cd ..
 
# 给解压后的包改一个简短的名字
[root@localhost local]# mv mysql-5.5.32-linux2.6-x86_64/ mysql
[root@localhost local]# cd mysql/
 
# 创建mysql用户组
[root@localhost mysql]# groupadd mysql
 
# 创建mysql系统用户
[root@localhost mysql]# useradd mysql -g mysql -M -s /sbin/nologin
 
# 进行账户信息授权
[root@localhost mysql]# chown -R mysql.mysql /usr/local/mysql/data/
 
# 开始编译mysql
[root@localhost mysql]#  ./scripts/mysql_install_db  --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
# 出现两个OK表示成功
Installing MySQL system tables...
OK
Filling help tables...
OK
......
..........
#如编译报错如下：
[root@localhost /usr/local/mysql]
#./scripts/mysql_install_db  --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
FATAL ERROR: please install the following Perl modules before executing ./scripts/mysql_install_db:
Data::Dumper
 
#因为缺少 autoconf库
 
yum安装autoconf库后再次编译即可：yum -y install autoconf 
 
# 复制mysql文件到开机启动项
[root@localhost mysql]# \cp support-files/mysql.server  /etc/init.d/mysqld
 
#修改配置文件
[root@localhost mysql]# vim /etc/init.d/mysqld
basedir=/usr/local/mysql
 
datadir=/usr/local/mysql/data
[root@localhost mysql]# cp support-files/my-small.cnf  /etc/my.cnf
 
# 启动mysql
[root@localhost mysql]# /etc/init.d/mysqld start
Starting MySQL.. SUCCESS!
[root@localhost mysql]# ss -antup | grep mysql
[root@localhost mysql]# ss -antup | grep 3306
tcp    LISTEN     0      50        *:3306                  *:*                   users:(("mysqld",pid=51774,fd=10))
total 76
drwxr-xr-x  2 root  root   4096 Mar 27 13:09 bin
 
注释：# 如果无法登录mysql进入/tmp目录修改文件权限 
[root@localhost /]# cd tmp/
[root@localhost tmp]# chmod 777 mysql.sock
[root@localhost tmp]# ll
total 8
srwxrwxrwx 1 mysql mysql    0 Mar 27 13:17 mysql.sock
drwx------ 3 root  root  4096 Mar 25 05:50 systemd-private-ff745f55df9148699f5cdffdd3b127e8-vgauthd.service-erHGUR
drwx------ 3 root  root  4096 Mar 25 05:50 systemd-private-ff745f55df9148699f5cdffdd3b127e8-vmtoolsd.service-uPpjWH
 
# 给mysql设置密码
[root@localhost tmp]# /usr/local/mysql/bin/mysqladmin -u root password '123456'
 
# 设置软连接使mysql命令可以被系统找到
[root@localhost sbin]# ln -s /usr/local/mysql/bin/* /usr/local/bin/
[root@localhost sbin]# which mysql
/usr/local/bin/mysql
 
# 登录MySQL
[root@localhost sbin]# mysql -uroot -p123456
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.5.32 MySQL Community Server (GPL)
 
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
 
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)
 
mysql> exit
Bye