Linux MySQL 5.6.43 安装

Linux MySQL 5.6.43 安装

【注意】
1.首先安装在默认目录 /usr/local/mysql，如需更改数据存储目录，进行2、3两步
2.如果需要修改数据目录，将my.nf 中的 datadir=/usr/local/mysql/data 进行修改
3.将 /usr/local/mysql/data 中的文件复制到修改后的目标 datadir 目录中

【 卸载原有的】
看看有没有自带的，有的话卸载，没有就跳过，直接安装

[root@localhost ~]#  rpm -qa | grep mariadb
mariadb-5.5.56-2.el7.x86_64
mariadb-libs-5.5.56-2.el7.x86_64
[root@localhost ~]# rpm -e --nodeps mariadb-5.5.56-2.el7.x86_64
[root@localhost ~]# rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

删除文件夹

[root@localhost ~l]#find / -name mysql
 /var/lib/mysql
 /usr/lib64/mysql
[root@localhost ~l]#rm -rf /var/lib/mysql

【开始安装 5.6.43 】
注意要装在 /usr/local/mysql 目录下，默认的就不要动它了，防止有坑。

[root@localhost ~l]# tar -zvxf mysql-5.6.43-linux-glibc2.12-x86_64.tar.gz 
[root@localhost ~l]# mv mysql-5.6.43-linux-glibc2.12-x86_64 /usr/local/mysql
[root@localhost ~]# cd /usr/local/mysql/
[root@localhost mysql]# groupadd mysql
[root@localhost mysql]# useradd -r -g mysql mysql
[root@localhost mysql]# chown -R mysql:mysql /usr/local/mysql/

修改配置文件

[root@localhost mysql]# vi /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data #先安装再修改
port = 3306
socket=/tmp/mysql.sock
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/tmp/mysqld/mysqld.pid
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
log-bin=mysql-bin 
binlog-format=ROW 
server_id=1 
max_connections=1000
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake

创建配置文件中，需要的文件

[root@localhost mysql]# mkdir /tmp/mysqld
[root@localhost mysql]# touch /tmp/mysqld/mysqld.pid
[root@localhost mysql]# chown -R mysql:mysql /tmp/mysqld/
[root@localhost mysql]# chmod -755 /tmp/mysqld/mysqld.pid
[root@localhost mysql]# touch /var/log/mysqld.log
[root@localhost mysql]# chown -R mysql:mysql /var/log
[root@localhost mysql]# chmod 755 /var/log/mysqld.log

初始化数据库
[root@localhost mysql]# ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

[root@localhost mysql]# ./bin/mysqld_safe --user=mysql &
或者
[root@localhost mysql]# ./support-files/mysql.server start
[root@localhost ~]# ps -ef|grep mysql

[root@localhost mysql]# ./bin/mysqladmin -u root password ‘123456’
[root@localhost mysql]# ./bin/mysql -uroot -p123456

允许远程访问：

mysql> grant all privileges on *.* to 'root'@'%'identified by '123456' with grant option;
mysql> flush privileges;
也可以登录后改密码：
mysql>update mysql.user set password=password('root') where user='root'; flush privileges;

【自启动】

[root@localhost ~]# vi /etc/rc.d/rc.local 
#!/bin/bash
# THIS FILE IS ADDED FOR COMPATIBILITY PURPOSES
#
# It is highly advisable to create own systemd services or udev rules
# to run scripts during boot instead of using this file.
#
# In contrast to previous versions due to parallel execution during boot
# this script will NOT be run after all other services.
#
# Please note that you must run 'chmod +x /etc/rc.d/rc.local' to ensure
# that this script will be executed during boot.

#touch /var/lock/subsys/local

echo "rc.d/rc.local start running "$(date+%Y%m%d) >> /tmp/redis.log
/usr/local/iron/redis/redis.sh >> /tmp/redis.log
/usr/local/iron/tomcat8085/bin/startup.sh >> /tmp/tomcat.log
/usr/local/mysql/support-files/mysql.server start