service mysql start * Starting MySQL database server mysqld No directory, logging in with HOME=

最新推荐文章于 2024-01-09 14:48:39 发布
转载 最新推荐文章于 2024-01-09 14:48:39 发布 · 4.2k 阅读 · 6
文章标签：

#mysql #ubuntu

本文介绍了一种在Ubuntu 16环境下安装MySQL后遇到的启动错误，并提供了详细的解决步骤，包括停止MySQL服务、更改MySQL用户的家目录等操作。

在ubuntu 16的版本中，安装了mysql 后，启动时，程序提示  Starting MySQL database server mysqld    No directory, logging in with HOME=的错误。

解决办法：

  1. Stop MYSQL service:

    sudo service mysql stop

  2. Change home directory of mysql from nonexistent to original directory where it is supposed to be:

    sudo usermod -d /var/lib/mysql/ mysql

    3. Now start mysql server again with:

        sudo service mysql start
ubuntu18.04启动Mysql报错：No directory, logging in with HOME=/
weixin_43968936的博客
10-25 2081
报错：No directory, logging in with HOME=/ 解决方案：usermod -d /var/lib/mysql/ mysql ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock chown -R mysql:mysql /var/lib/mysql 亲测有效，不报那个没有目录的错了，但是还是没有启动成功 ...
WSL2 Ubuntu18.04 升级mysql8.0卸载安装踩坑全过程
m0_53277621的博客
10-08 1369
WSL2 Ubuntu18.04 升级mysql8.0卸载安装踩坑全过程，解决找不到mysqld服务、套接字连接失败等问题
Mysql5.7启动错误
小乔流水仁家的博客
09-02 440
错误消息： * Starting MySQL database server mysqld No director...
WSL Win10 子系统 Ubuntu 安装 mysql
qq_28597959的博客
12-12 556
WSL Win10 子系统 Ubuntu 安装 mysql 删除掉之前安装过的 mysql，之前没有安装过 mysql 可以忽略 sudo apt-get remove --purge *mysql* sudo rm -rf /etc/mysql /var/lib/mysql sudo apt-get remove --purge *mariadb* 然后更新软件列表 sudo apt update # 更新软件列表 sudo apt upgrade # 更新软件 安装 mysql-server sud
解决* Starting MySQL database server mysqld [fail]一种方法
MacwinWin的博客
03-30 9722
if: >>> service mysql start * Starting MySQL database server mysqld [fail] try: >>> sudo chown -R mysql:mysql /var/lib/mysql >>> service mysql start exce...
mysql无法启动启动服务器_Mysql服务器无法启动
weixin_30977485的博客
01-28 374
谷歌搜索两个小时,我需要你的帮助.我在Debian虚拟机上,我克隆了它.唯一的变化是它拥有的新IP地址.Mysql不再启动了：Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!没有名为mysql的进程./ var / log中的所有mysql日志文件都是空的.这是my.cnf文件：[client]po...
root@wenxijun-virtual-machine:~# docker logs 9c942d8d3e77 Starting Tomcat service... Using CATALINA_BASE: /opt/apache-tomcat-8.5.46 Using CATALINA_HOME: /opt/apache-tomcat-8.5.46 Using CATALINA_TMPDIR: /opt/apache-tomcat-8.5.46/temp Using JRE_HOME: /usr/lib/jvm/java-8-openjdk-amd64 Using CLASSPATH: /opt/apache-tomcat-8.5.46/bin/bootstrap.jar:/opt/apache-tomcat-8.5.46/bin/tomcat-juli.jar Tomcat started. Starting MySQL service... * Starting MySQL database server mysqld No directory, logging in with HOME=/ [ OK ] Waiting for MySQL to start... Initializing MySQL database... ERROR 1044 (42000) at line 1: Access denied for user 'root'@'localhost' to database 'information_schema' Starting Nginx service... * Restarting n
04-16
好的，我现在需要帮助用户解决Docker容器中Tomcat、MySQL和Nginx服务启动时遇到的权限问题，特别是错误1044。首先，我得理解用户的具体情况。用户提到在启动这些容器时出现权限被拒绝的问题，可能涉及到文件或目录的...
Beginning configuration step: Writing configuration file Saving my.ini configuration file... Saved my.ini configuration file. Ended configuration step: Writing configuration file Beginning configuration step: Updating Windows Firewall rules Adding a Windows Firewall rule for MySQL57 on port 3306. Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow 纭畾銆? Successfully added the Windows Firewall rule. Ended configuration step: Updating Windows Firewall rules Beginning configuration step: Adjusting Windows service Attempting to grant the required filesystem permissions to the 'NT AUTHORITY\NetworkService' account. Granted permissions to the data directory. Adding new service New service added Ended configuration step: Adjusting Windows service Beginning configuration step: Initializing database (may take a long time) Deleting the data directory from a previous (failed) configuration... Attempting to run MySQL Server with --initialize-insecure option... Starting process for MySQL Server 5.7.44... Starting process with command: F:\mysql\m\bin\mysqld.exe --defaults-file="F:\mysql\y\my.ini" --console --initialize-insecure=on --lower-case-table-names=1... TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). InnoDB: New log files created, LSN=45790 InnoDB: Creating foreign key constraint system tables. mysqld: File '.\姹熷鐪?slow.log' not found (Errcode: 2 - No such file or directory) Could not use 姹熷鐪?slow.log for logging (error 2 - No such file or directory). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server. No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 42751b4d-8dec-11f0-b5f1-025034608cb2. Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. CA certificate ca.pem is self signed. root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. Process for mysqld, with ID 19428, was run successfully and exited with code 0. Successfully started process for MySQL Server 5.7.44. MySQL Server 5.7.44 intialized the database successfully. Ended configuration step: Initializing database (may take a long time) Beginning configuration step: Updating permissions for the data folder and related server files Attempting to update the permissions for the data folder and related server files... Inherited permissions have been converted to explicit permissions. Full control permissions granted to: NETWORK SERVICE. Full control permissions granted to: Administrators. Full control permissions granted to: CREATOR OWNER. Full control permissions granted to: SYSTEM. Access to the data directory is removed for the users group. Permissions for the data folder and related server files are updated correctly. Ended configuration step: Updating permissions for the data folder and related server files Beginning configuration step: Starting the server Attempting to start service MySQL57.................... 只有在任务处于完成状态(RanToCompletion、Faulted 或 Canceled)时才能释放它。 Ended configuration step: Starting the server . Found existing data directory, no need to initialize the database. Found existing data directory, no need to initialize the database.帮我解决
最新发布
09-11
例如，将路径设置为英文路径，像`slow_query_log_file = E:\MySQL-5.7.44\data\slow.log` [^1][^3]。 - **创建对应目录和文件**：要保证配置文件里指定的目录和文件是存在的。若不存在，手动创建该目录和文件。 ###...
mysql5.6.41丢失pid文件和丢失mysql.sock
xinxizjz的博客
01-09 1396
mysql5.6.41丢失pid文件和丢失mysql.sock
docker Starting MySQL database server mysqld fail解决办法
黑面狐
12-18 6081
今天有一个ubuntu+mysql的测试环境，在容器重启的时候mysql启动失败，导致docker启动失败。 首先查看docker日志 docker logs 8a16 发现有如下报错：  * Stopping MySQL database server mysqld    ...done.  * Starting MySQL database server mysqld    .....
Starting MySQL database server: mysqld. Stopping MySQL database server: mysqld failed!)
雪狼基地
01-12 1354
数据库无法停止,无法启动 (Starting MySQL database server: mysqld.   Stopping MySQL database server: mysqld failed!) mysql -uroot -p登陆不了,以debian-sys-maint进入数据库,添加用户 mysql -u debian-sys-maint -p //cat /etc/mysq
启动mysql5.7报错 Directory nonexistent 解决方式
cocos2dGirl的专栏
10-27 3320
启动mysql5.7报错如下 sudo service mysql start * Starting MySQL database server mysqld
MySQL 5.7 No directory, logging in with HOME=/
热门推荐
JOSENHUANG的专栏
12-12 1万+
在ubuntu 14的版本中，安装了mysql 后，启动时，程序提示 “No directory, logging in with HOME=/” root@xxx:/etc/mysql# service mysql restart * Stopping MySQL Community Server 5.7.11 ... * MySQL Community Server 5.7.11 i
No directory, logging in with HOME=/
weixin_45848076的博客
09-13 392
启动mysql报这个 Starting MySQL database server mysqld No directory, logging in with HOME=/ Try usermod -d /var/lib/mysql mysql and then /etc/init.d/mysql restart
Mysql错误处理:Starting MySQL../data/server/mysql/bin/mysqld_safe: line 166: 5597 Killed
ths512的博客
01-16 902
今天朋友说数据库上不去了，我重启云服务器，报下面的错误，网上找了一些帖子分析了下，加了如下参数，重启服务器就ok了，出现该问题是内存不够导致！ 问题报错： 解决办法： 1，进入数据安装目录找到my.cnf 路径： /data/server/mysql 2，添加配置参数 key_buffer=16K table_open_cache=4 query_ca...
service mysql start 启动失败，日志报mysqld: File ‘./bin.index‘ not found (OS errno 13 - Permission denied)
IT小浣熊的博客
04-02 8848
解决方式： chown mysql:mysql -R /opt/apps/data/mysqldata 参考博客： mysqld: File ‘./mysql-bin.index’ not found (Errcode: 13 - Permission denied) MySQL启动失败 mysqld: File ‘./mysql-bin.index’ not found (Errcode: 13 - Permission denied)） 服务器因断电停机，MySQL未设置自启动，需手动重启 查看.
debian启动mysql_debian下的mysql服务突然启动失败
weixin_39689687的博客
12-19 251
该楼层疑似违规已被系统折叠隐藏此楼查看此楼就是突然启动不成功，终端下没有任何提示，只有一个失败root@debian76lei:/home/leinor# service mysql restart[ ok ] Stopping MySQL database server: mysqld.[FAIL] Starting MySQL database server: mysqld . . . . ...
mysql 5.6 服务启动_重装mysql 5.6 后，无法启动服务
weixin_32187075的博客
01-27 195
重装mysql 5.6 后，无法启动服务报错r如下：[root@localhost xtrabackup]# mysql -u root -pEnter password:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)[root@loca...
mysql开机跳出更新_mysql 启动出现问题.急等解决办法.
weixin_35225264的博客
02-18 423
你的位置:问答吧-> 数据库-> 问题详情mysql 启动出现问题.急等解决办法.ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)作者: zwangxi...
root@16ee2b20c90d:/# service mysql start * Starting MySQL database server mysqld su: warning: cannot change directory to /nonexistent: No such file or directory
06-13
当你在 Docker 容器中尝试启动 MySQL 服务时，遇到了错误 `su: warning: cannot change directory to /nonexistent: No such file or directory`。这个错误通常是因为容器内的用户配置问题或目录权限问题。 以下是...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值