centos7非root下安装mysql5.7.29

1.环境准备

1.mysql-5.7.29下载

#提前准备mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz安装包，或者采用wget下载：
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz

2.解压MySQL

#解压
tar -zxvf mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz
#移动mysql
mv mysql-5.7.29-linux-glibc2.12-x86_64 mysql 

3.创建实例数据目录

#进入mysql目录，创建data数据文件夹
cd mysql 
mkdir data

4.在mysql目录下创建my.cnf配置文件，内容如下：

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
# 配置端口号 默认3306，这里配置为3305
character-set-server = utf8
port=3305

# cluster 用户名目录，需要改为自己的用户名
basedir=/home/cluster/mysql
datadir=/home/cluster/mysql/data
socket=/home/cluster/mysql/mysql.sock
log_error=/home/cluster/mysql/error.log
pid-file=/home/cluster/mysql/mysql.pid

[client]
port=3305  
default-character-set=utf8
socket=/home/cluster/mysql/mysql.sock  

5.初始化Mysql数据库

# cluster改为自己的用户名
bin/mysqld --defaults-file=/home/cluster/mysql/my.cnf --initialize --user=cluster --basedir=/home/cluster/mysql --datadir=/home/cluster/mysql/data
#初始化完成后，检查/home/cluster/mysql/error.log日志是否初始化成功

6.通过mysqld_safe模式启动数据库，然后修改默认密码

bin/mysqld_safe --defaults-file=/home/cluster/mysql/my.cnf  --user=cluster &

进入用户的mysql目录，获取数据库生成的默认密码：

cat error.log | grep root@localhost
2020-03-02T07:30:32.189865Z 1 [Note] A temporary password is generated for root@localhost: wcl4=)Tn2,HV

登陆mysql：

$ bin/mysql -u root -p
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

不存在/tmp/mysql.sock，我们在my.cnf配置的mysql.sock路径是/home/cluster/mysql/mysql.sock，通过软连接在/tmp/连接mysql.sock文件：

ln -s /home/cluster/mysql/mysql.sock /tmp/mysql.sock

再次登录，输入之前拿到的密码wcl4=)Tn2,HV后登陆成功：

bin/mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.29

Copyright (c) 2000, 2020, 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>

修改密码：

mysql> set password for 'root'@'localhost' = password('123456');
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

7.停止mysqld_safe模式改为正常启动

#通过查找mysql进程
ps -ef|grep mysql 
cluster  25169 23838  0 15:31 pts/0    00:00:00 /bin/sh bin/mysqld_safe --defaults-file=/home/cluster/mysql/my.cnf --user=cluster
cluster  30397 25169  2 16:02 pts/0    00:00:00 /home/cluster/mysql/bin/mysqld --defaults-file=/home/cluster/mysql/my.cnf --basedir=/home/cluster/mysql --datadir=/home/cluster/mysql/data --plugin-dir=/home/cluster/mysql/lib/plugin --log-error=/home/cluster/mysql/error.log --pid-file=/home/cluster/mysql/mysql.pid --socket=/home/cluster/mysql/mysql.sock --port=3305
#结束进程
kill -9 30379

8.正常启动mysql服务

bin/mysqld --defaults-file=/home/cluster/mysql/my.cnf  --user=cluster &