系统:OL 6 X64
DB:Mysql 5.7
下载安装文件,名称如:mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz
稍有改动处有以下:
在运行mysqld初始化以前,编辑/etc/my.cnf如下
[mysqld]
#datadir=/var/lib/mysql
basedir=/opt/mysql
datadir=/opt/mysql/data
socket=/opt/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/opt/mysql/mysqld.log
pid-file=/opt/mysql/mysqld.pid
[client]
socket=/opt/mysql/mysql.sock
以上目录需提前创建,并将整个basedir的owner/group改为mysql,同时提前创建mysqld.log
echo "" > /opt/mysql/mysqld.log
chown -R mysql:mysql /opt/mysql
出于方便,以如下方式初始化
bin/mysqld --initialize-insecure --user=mysql
安装完成后,无密码登录mysql并设置root密码:
mysql -u root --skip-password
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.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> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root密码';
Query OK, 0 rows affected (0.00 sec)
/etc/init.d/mysql.server文件需编辑环境变量
basedir=/opt/mysql
datadir=/opt/mysql/data
mysqld_pid_file_path=/opt/mysql/mysqld.pid
完成。