安装mysql5.7出现的问题

最新推荐文章于 2025-06-20 09:59:40 发布

原创最新推荐文章于 2025-06-20 09:59:40 发布 · 755 阅读

0 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

3 篇文章

订阅专栏

本文详细介绍了在执行MySQL数据库安装过程中遇到的错误及解决方案，包括处理mysql_install_db警告，解决因链接库缺失导致的mysqld进程异常终止问题，以及应对文件权限和目录不存在等启动错误。

执行/usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data时，出现如下错误

2018-12-10 10:31:32 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2018-12-10 10:31:32 [ERROR]   Child process: /usr/local/mysql/bin/mysqldterminated prematurely with errno= 32
2018-12-10 10:31:32 [ERROR]   Failed to execute /usr/local/mysql/bin/mysqld --bootstrap --datadir=/usr/local/mysql/data --lc-messages-dir=/usr/local/mysql/share --lc-messages=en_US --basedir=/usr/local/mysql
-- server log begin --

-- server log end --

表明系统中没有该链接库，使用命令yum install libaio-devel.x86_64进行安装。

出现如下错误

Starting MySQL.2018-12-10T02:39:32.071467Z mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log', however file don't exists. Create writable for user 'mysql'.
The server quit without updating PID file (/var/lib/mysql/i[FAILED]4czny0ed1pe9hz.pid).

此为文件权限问题
一次执行如下命令

# mkdir /var/log/mariadb
# touch /var/log/mariadb/mariadb.log
# chown -R mysql:mysql /var/log/mariadb/

出现如下错误

Starting MySQL.2018-12-10T02:42:01.619794Z mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exists.
The server quit without updating PID file (/var/lib/mysql/i[FAILED]4czny0ed1pe9hz.pid).

查看/etc目录下是否存在文件my.cnf