系统:OL 6 X64
DB:Mysql 5.7下载安装文件,名称如:mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz 安装过程参考: https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html 稍有改动处有以下: 在运行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
完成。
