mysql tar 包 完美安装

1.先下载tar包安装放入linux 目录，然后解压并移动到/usr/local/mysql目录下

tar -zxvf mysql-5.6.44-linux-glibc2.12-x86_64.tar.gz 
mv  mysql-5.6.44-linux-glibc2.12-x86_64.tar.gz  msyql  
mv mysql  /usr/local/

2.创建mysql组和用户

# 创建mysql用户组
[root@VMTest ~]# groupadd mysql
 
# 创建一个用户名为mysql的用户，并加入mysql用户组
[root@VMTest ~]# useradd -g mysql mysql

3.更改所属的组和用户

# 更改所属的组和用户
[root@VMTest local]# chown -R mysql mysql/
[root@VMTest local]# chgrp -R mysql mysql/
[root@VMTest local]# cd mysql/
     
[root@VMTest mysql]# mkdir data
     
[root@VMTest mysql]# chown -R mysql:mysql data

4.在/etc下创建my.cnf文件

# 进入/etc文件夹下
[root@VMTest mysql]# cd /etc
 
# 创建my.cnf文件
[root@VMTest etc]# touch my.cnf
 
# 编辑my.cnf
[root@VMTest etc]# vim my.cnf

5.my.cnf添加如下内容

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8
 
[mysqld]
# 设置3306端口
port = 3306
 
# 设置mysql的安装目录
basedir=/usr/local/mysql
 
# 设置mysql数据库的数据的存放目录
datadir=/usr/local/mysql/data
 
# 允许最大连接数
max_connections=200
 
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
 
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
lower_case_table_names=1
max_allowed_packet=16M
# 表不区分大小写
lower_case_table_names=1
user = mysql
tmpdir = /tmp

[mysqld_safe]
log-error = /usr/local/mysql/data/error.log
pid-file = /usr/local/mysql/data/mysql.pid

6.初始化mysql

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/mysql.pid  --tmpdir=/tmp

7.启动mysql

# 启动mysql
[root@VMTest mysql]# /etc/init.d/mysqld start

8.设置开机启动

#设置开机启动
[root@VMTest mysql]# chkconfig --level 35 mysqld on
[root@VMTest mysql]# chkconfig --list mysqld
 
[root@VMTest mysql]# chmod +x /etc/rc.d/init.d/mysqld
[root@VMTest mysql]# chkconfig --add mysqld
[root@VMTest mysql]# chkconfig --list mysqld
[root@VMTest mysql]# service mysqld status
SUCCESS! MySQL running (4475)

9.配置变量

# 进入/etc/profile文件夹
[root@VMTest mysql]# vim /etc/profile
# 修改/etc/profile文件
#set mysql environment
export PATH=$PATH:/usr/local/mysql/bin
 
# 使文件生效
[root@VMTest mysql]# source /etc/profile

10.获得mysql初始密码

# 1、获得mysql初始密码
[root@VMTest bin]# cat /root/.mysql_secret
# Password set for user 'root@localhost' at 2017-04-17 17:40:02
_pB*3VZl5T<6
 
# 2、修改密码
[root@VMTest bin]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 53
Server version: 5.7.22 MySQL Community Server (GPL)
 
Copyright (c) 2000, 2018, 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> set PASSWORD = PASSWORD('root');
Query OK, 0 rows affected, 1 warning (0.00 sec)
 
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

11.添加远程访问权限

# 添加远程访问权限
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
 
mysql> update user set host='%' where user='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
 
mysql> select host,user from user;
+-----------+---------------+
| host | user |
+-----------+---------------+
| % | root |
| localhost | mysql.session |
| localhost | mysql.sys |
+-----------+---------------+
3 rows in set (0.00 sec)

12.重启mysql生效

# 重启mysql
[root@VMTest bin]# /etc/init.d/mysqld restart
Shutting down MySQL..
Starting MySQL.