Home Database Mysql Tutorial The server quit without updating PID file (/[FAILED]l/mysql/

The server quit without updating PID file (/[FAILED]l/mysql/

Jun 07, 2016 pm 03:24 PM
server the

[root@localhost var]# vi /etc/my.cnf log-bin=/usr/local/mysql/data/mylog --添加log-bin参数 [root@localhost var]# service mysqld stop mysqld: unrecognized service [root@localhost var]# service mysql stop Shutting down MySQL.... [ OK ] [root

[root@localhost var]# vi /etc/my.cnf 

log-bin=/usr/local/mysql/data/mylog    --添加log-bin参数
[root@localhost var]# service mysqld stop
mysqld: unrecognized service
[root@localhost var]# service mysql stop
Shutting down MySQL....                                    [  OK  ]
[root@localhost var]# service mysql start
Starting MySQL.The server quit without updating PID file (/[FAILED]l/mysql/var/localhost.localdomain.pid).
[root@localhost var]# service mysql start
Starting MySQL.The server quit without updating PID file (/[FAILED]l/mysql/var/localhost.localdomain.pid).

[root@localhost var]# tail -25 localhost.localdomain.err 

140805 13:43:22 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/bin/mysqld: File '/usr/local/mysql/data/mylog.index' not found (Errcode: 13)
140805 13:43:22 [ERROR] Aborting

140805 13:43:22 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

140805 13:42:53 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended

[root@localhost mysql]# ll /usr/local/mysql/    

total 80
-rw-r--r--  1 root  mysql 17987 Aug 29  2012 COPYING
-rw-r--r--  1 root  mysql  7604 Aug 29  2012 INSTALL-BINARY
-rw-r--r--  1 root  mysql  2552 Aug 29  2012 README
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 bin
drwxr-xr-x  4 root  mysql  4096 Dec 26  2013 data
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 docs
drwxr-xr-x  3 root  mysql  4096 Dec 26  2013 include
drwxr-xr-x  3 root  mysql  4096 Dec 26  2013 lib
drwxr-xr-x  4 root  mysql  4096 Dec 26  2013 man
drwxr-xr-x 10 root  mysql  4096 Dec 26  2013 mysql-test
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 scripts
drwxr-xr-x 27 root  mysql  4096 Dec 26  2013 share
drwxr-xr-x  4 root  mysql  4096 Dec 26  2013 sql-bench
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 support-files
drwx------  5 mysql mysql  4096 Aug  5 13:46 var
[root@localhost mysql]# chown -R mysql /usr/local/mysql/data   --更改data目录属主
[root@localhost mysql]# ll /usr/local/mysql/
total 80
-rw-r--r--  1 root  mysql 17987 Aug 29  2012 COPYING
-rw-r--r--  1 root  mysql  7604 Aug 29  2012 INSTALL-BINARY
-rw-r--r--  1 root  mysql  2552 Aug 29  2012 README
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 bin
drwxr-xr-x  4 mysql mysql  4096 Dec 26  2013 data
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 docs
drwxr-xr-x  3 root  mysql  4096 Dec 26  2013 include
drwxr-xr-x  3 root  mysql  4096 Dec 26  2013 lib
drwxr-xr-x  4 root  mysql  4096 Dec 26  2013 man
drwxr-xr-x 10 root  mysql  4096 Dec 26  2013 mysql-test
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 scripts
drwxr-xr-x 27 root  mysql  4096 Dec 26  2013 share
drwxr-xr-x  4 root  mysql  4096 Dec 26  2013 sql-bench
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 support-files
drwx------  5 mysql mysql  4096 Aug  5 13:46 var
[root@localhost mysql]# service mysql start
Starting MySQL..                                           [  OK  ]
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

After 2 months, the humanoid robot Walker S can fold clothes After 2 months, the humanoid robot Walker S can fold clothes Apr 03, 2024 am 08:01 AM

Editor of Machine Power Report: Wu Xin The domestic version of the humanoid robot + large model team completed the operation task of complex flexible materials such as folding clothes for the first time. With the unveiling of Figure01, which integrates OpenAI's multi-modal large model, the related progress of domestic peers has been attracting attention. Just yesterday, UBTECH, China's "number one humanoid robot stock", released the first demo of the humanoid robot WalkerS that is deeply integrated with Baidu Wenxin's large model, showing some interesting new features. Now, WalkerS, blessed by Baidu Wenxin’s large model capabilities, looks like this. Like Figure01, WalkerS does not move around, but stands behind a desk to complete a series of tasks. It can follow human commands and fold clothes

How to install, uninstall, and reset Windows server backup How to install, uninstall, and reset Windows server backup Mar 06, 2024 am 10:37 AM

WindowsServerBackup is a function that comes with the WindowsServer operating system, designed to help users protect important data and system configurations, and provide complete backup and recovery solutions for small, medium and enterprise-level enterprises. Only users running Server2022 and higher can use this feature. In this article, we will explain how to install, uninstall or reset WindowsServerBackup. How to Reset Windows Server Backup If you are experiencing problems with your server backup, the backup is taking too long, or you are unable to access stored files, then you may consider resetting your Windows Server backup settings. To reset Windows

Windows Server 2025 preview version welcomes update, Microsoft improves Insiders testing experience Windows Server 2025 preview version welcomes update, Microsoft improves Insiders testing experience Feb 19, 2024 pm 02:36 PM

On the occasion of releasing the build 26040 version of Windows Server, Microsoft announced the official name of the product: Windows Server 2025. Also launched is the Windows11WindowsInsiderCanaryChannel version build26040. Some friends may still remember that many years ago someone successfully converted Windows NT from workstation mode to server mode, showing the commonalities between various versions of Microsoft operating systems. Although there are clear differences between Microsoft's current version of the server operating system and Windows 11, those who pay attention to the details may be curious: why Windows Server updated the brand,

How to modify the Nginx version name to disguise any web server How to modify the Nginx version name to disguise any web server May 14, 2023 pm 09:19 PM

How to modify the default name of nginx, you can disguise it a little, or you can install Tip: Generally, modifications are made before nginx is compiled. After modification, the code needs to be recompiled as follows: scr/core/nginx.conf#definenginx_version"1.4.7"#definenginx_ver"nginx/"n

Microsoft releases Windows Server vNext preview version 25335 Microsoft releases Windows Server vNext preview version 25335 Jan 10, 2024 am 08:49 AM

While Microsoft released the Win11 preview update for the desktop, today it also released the Windows Server Long Term Service Channel (LTSC) preview Build 25335. As usual, Microsoft did not publish a complete change log, or even provide a corresponding blog post. Microsoft has adjusted the Windows Server preview version update log to make it the same as the Canary channel version. If no new content is introduced, the official blog post will not be posted. Note from IT Home: The server brand has not been updated and is still Windows Server 2022 in the preview version. In addition, Microsoft calls these versions Windows Server vNext instead of the Windows version that is already on the market.

Microsoft releases Windows Server 26080 preview update: Fixes Feedback Hub failure Microsoft releases Windows Server 26080 preview update: Fixes Feedback Hub failure Mar 14, 2024 pm 07:11 PM

IT House reported on March 14 that in addition to the Windows 11 Build 26080 preview update for the desktop, Microsoft also updated and launched the Windows Server Build 26080 preview update. As the latest preview version of the upcoming Windows Server Long Term Servicing Channel (LTSC), Windows Server Build 26080 provides Data Center Edition and Standard Edition, and users can choose desktop experience and Server Core installation options. This release also includes an annual channel for container hosts, and an Azure release specifically for virtual machine evaluation. IT House queries X social media. User feedback clicks the Copilot button in the lower right corner.

What is the matching logic of Server and Location in Nginx? What is the matching logic of Server and Location in Nginx? May 12, 2023 am 11:10 AM

Server matching logic When nginx determines which server block to execute a request, it mainly focuses on the listen and server_name fields in the server block. The listen command listen field defines the IP and port of the server response. If the listen field is not explicitly configured, the default listening 0.0.0.0:80 (root) or 0.0.0.0:8080 (non-root) listen can be configured as: a combination of ip and port, a single ip, listening on port 80 by default, a single port, and listening on all ip interfaces by default A unixsocket path where the last entry is usually only used in different

Steps to install GNOME 3 on Ubuntu Server 11.04 Steps to install GNOME 3 on Ubuntu Server 11.04 Dec 31, 2023 pm 03:59 PM

If you think there is no need to install a graphical interface when installing Ubuntu Server 11.04, let alone GNOME 3, which is not yet complete. . Or it should be built with ARCH+GNOME3. So please don't waste your time reading any more. It took 2 nights and a day and reinstalled N times. Finally something has come of it. It's not easy. Without further ado, let’s get to the point: Hardware: One ThinkPad (For X61) 2. Enter the boot options interface, select USB boot, and then choose to install Ubu

See all articles