- 赋予权限
chown -R mysql.mysql ./mysql-8.4.2
- 创建配置文件
vim ./mysql-8.4.2/my.cnf
“my.cnf”配置内容:[client]
port=3307
mysqlx_port=33070
socket=/tmp/mysql84.sock
mysqlx_socket=/tmp/mysqlx84.sock
[mysqld]
# skip-grant-tables
# mysql安装目录
basedir=/usr/local/mysql-8.4.2
# mysql数据库目录
datadir=/usr/local/mysql-8.4.2/data
port=3307
innodb_file_per_table=1
character-set-server=utf8
mysqlx_port=33070
socket = /tmp/mysql84.sock
mysqlx_socket=/tmp/mysqlx80.sock
[mysqld_safe]
# 错误日志
log-error=/usr/local/mysql-8.4.2/data/error.log
# pid文件
pid-file=/usr/local/mysql-8.4.2/data/mysqld.pid
tmpdir=/tmp/mysql84
- 赋予配置文件权限
chmod 755 ./mysql-8.4.2/my.cnf
- 修改服务器文件
vim ./mysql-8.4.2/support-files/mysql.server
“mysql.server”修改内容:basedir=/usr/local/mysql-8.4.2
datadir=/usr/local/mysql-8.4.2/data
lockdir='/var/lock/subsys'
lock_file_path="$lockdir/mysql84"
mysqld_pid_file_path=/usr/local/mysql-8.4.2/data/mysqld.pid
conf=/usr/local/mysql-8.4.2/my.cnf
- 复制注册连接服务文件
cp -i ./mysql-8.4.2/support-files/mysql.server /etc/init.d/mysql84
- 初始化数据库
./mysql-8.4.2/bin/mysqld --defaults-file=/usr/local/mysql-8.4.2/my.cnf --user=mysql --initialize
初始化成功,查看输出日志,找到初始密码2024-10-04T12:06:18.478525Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: XH>)njhBE5VC