Home > other > MySQL-related problem

MySQL-related problem

June 18Hits:0
Advertisement

I don't understand what happened. I haven't touched the server in a while, and when I typed the code

Code:

service mysqld start

CentOS 6.3 replies with an

Code:

MySQL Daemon failed to start.  Starting mysqld: [FAILED]

I looked though the log files, and it gave me this...

Code:

121005 18:05:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql  121005 18:05:42 [Note] Plugin 'FEDERATED' is disabled.  /usr/libexec/mysqld: Table 'plugin' is read only  121005 18:05:42 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.  121005 18:05:42 InnoDB: The InnoDB memory heap is disabled  121005 18:05:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins  121005 18:05:42 InnoDB: Compressed tables use zlib 1.2.3  121005 18:05:42 InnoDB: Using Linux native AIO  /usr/libexec/mysqld: Can't create/write to file '/tmp/ibwnGp95' (Errcode: 13)  121005 18:05:43  InnoDB: Error: unable to create temporary file; errno: 13  121005 18:05:43 [ERROR] Plugin 'InnoDB' init function returned error.  121005 18:05:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.  121005 18:05:43 [ERROR] Unknown/unsupported storage engine: InnoDB  121005 18:05:43 [ERROR] Aborting

I have been searching around Google for a day now, and every single solution I land upon, it didn't help me with my problem.

Additional note...
- typing mysql_upgrade results in this...

Code:

Looking for 'mysql' as: mysql  Looking for 'mysqlcheck' as: mysqlcheck  Running 'mysqlcheck with default connection arguments  mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect  FATAL ERROR: Upgrade failed

Another note...
- the latest version of MySQL is version 5.5.28. Is there a way to let CentOS download and install MySQL version 5.5.25* ?

Any help would be greatly appreciated. Thank you.

--------------Solutions-------------

Can you run

Code:

df -h

to check if any of your partitions is full?
Thank you for the reply.
And yes, I can check the partitions, but none of them are full. None are even beyond 20% of usage as of this moment.

Can you post the output of

Code:

 ls -la /tmp/

?
Thanks for the reply, and yes, here it is.
Quite long though...

Code:

total 354772
drwxrwxrwx.  8 root       root            4096 Oct  9 09:54 .
drwx------. 28 apache     root            4096 Oct  9 09:54 ..
-rw-r--r--.  1 root       root           14496 May 10 23:04 epel-release-6-7.noarch.rpm
-rw-r--r--   1 root       root           14496 May 10 23:04 epel-release-6-7.noarch.rpm.1
-rw-r--r--   1 root       root           14496 May 10 23:04 epel-release-6-7.noarch.rpm.2
drwx------.  2 devuser    devuser         4096 Aug 17 12:05 .esd-500
drwxrwxrwt   2 root       root            4096 Oct  9 09:54 .ICE-unix
drwxr-xr-x.  8 root       root            4096 Jun 18 22:31 ispconfig3_install
-rw-r--r--   1 root       root         2711250 Jun 18 22:31 ISPConfig-3-stable.tar.gz
-rw-r--r--   1 root       root         2711250 Jun 18 22:31 ISPConfig-3-stable.tar.gz.1
-rw-r--r--   1 root       root       357283840 Oct  4 18:36 mysql-5.5.2-m2-linux-i686-glibc23.tar
drwxr-xr-x   6 root       root            4096 Oct  3 17:56 mysql_backup_oct3
drwx------.  2 gdm        gdm             4096 Oct  2 09:14 pulse-DkNw0mZCgMcC
-rw-r--r--   1 root       root           12700 Nov 13  2010 rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
-rw-r--r--   1 root       root           12700 Nov 13  2010 rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm.1
-r--r--r--   1 root       root              11 Oct  9 09:54 .X0-lock
drwxrwxrwt   2 root       root            4096 Oct  9 09:54 .X11-unix
-rw-------   1 root       root             303 Aug 31 12:01 yum_save_tx-2012-08-31-12-01QAuEn6.yumtx
-rw-------   1 root       root             299 Sep 10 11:02 yum_save_tx-2012-09-10-11-02VjE7Sv.yumtx
-rw-------   1 root       root             289 Sep 12 18:11 yum_save_tx-2012-09-12-18-11cqsiXI.yumtx
-rw-------   1 root       root             304 Sep 13 12:39 yum_save_tx-2012-09-13-12-39bk4ED3.yumtx
-rw-------   1 root       root            2841 Sep 20 14:32 yum_save_tx-2012-09-20-14-32E3Xg9z.yumtx
-rw-------   1 root       root             300 Sep 20 16:14 yum_save_tx-2012-09-20-16-14kioNyQ.yumtx
-rw-------   1 root       root           11322 Sep 21 11:16 yum_save_tx-2012-09-21-11-16Tl7fC8.yumtx
-rw-------   1 root       root             299 Sep 21 13:02 yum_save_tx-2012-09-21-13-0222AwND.yumtx
-rw-------   1 root       root             516 Sep 21 15:08 yum_save_tx-2012-09-21-15-08R9GxT6.yumtx
-rw-------   1 root       root             516 Sep 21 15:10 yum_save_tx-2012-09-21-15-10YDd07F.yumtx
-rw-------   1 root       root             516 Sep 21 15:13 yum_save_tx-2012-09-21-15-13sB_26z.yumtx
-rw-------   1 root       root            1451 Sep 21 15:16 yum_save_tx-2012-09-21-15-16HXR_sp.yumtx
-rw-------   1 root       root             516 Sep 21 15:17 yum_save_tx-2012-09-21-15-17ljS4V5.yumtx
-rw-------   1 root       root           56199 Sep 21 15:22 yum_save_tx-2012-09-21-15-22tNzfmH.yumtx
-rw-------   1 root       root            8131 Sep 28 11:56 yum_save_tx-2012-09-28-11-56RwBhCi.yumtx
-rw-------   1 root       root            8343 Oct  3 16:22 yum_save_tx-2012-10-03-16-22yNzUUd.yumtx
-rw-------   1 root       root            8343 Oct  3 16:31 yum_save_tx-2012-10-03-16-31RuiN93.yumtx
-rw-------   1 root       root            8343 Oct  3 16:32 yum_save_tx-2012-10-03-16-32uOjqn2.yumtx
-rw-------   1 root       root            8283 Oct  3 16:51 yum_save_tx-2012-10-03-16-51yGBWpl.yumtx
-rw-------   1 root       root            8343 Oct  3 16:52 yum_save_tx-2012-10-03-16-52_0COYu.yumtx
-rw-------   1 root       root            8307 Oct  3 16:55 yum_save_tx-2012-10-03-16-55ZmuVSv.yumtx
-rw-------   1 root       root            8343 Oct  3 17:05 yum_save_tx-2012-10-03-17-05xDzPMJ.yumtx
-rw-------   1 root       root            8307 Oct  3 17:18 yum_save_tx-2012-10-03-17-18eWeaxV.yumtx
-rw-------   1 root       root           14991 Oct  3 17:31 yum_save_tx-2012-10-03-17-31E6pP33.yumtx
-rw-------   1 root       root            8343 Oct  4 10:27 yum_save_tx-2012-10-04-10-27oVQjbA.yumtx
-rw-------   1 root       root            8343 Oct  4 10:45 yum_save_tx-2012-10-04-10-452GW5ka.yumtx
-rw-------   1 root       root            8307 Oct  4 12:01 yum_save_tx-2012-10-04-12-01WnzpoY.yumtx
-rw-------   1 root       root           14991 Oct  4 12:02 yum_save_tx-2012-10-04-12-027MBN6v.yumtx
-rw-------   1 root       root            8283 Oct  4 15:45 yum_save_tx-2012-10-04-15-45HTNkJA.yumtx
-rw-------   1 root       root             291 Oct  4 16:31 yum_save_tx-2012-10-04-16-31eCnxtg.yumtx
-rw-------   1 root       root            8283 Oct  4 18:21 yum_save_tx-2012-10-04-18-21DeCo1h.yumtx
-rw-------   1 root       root            8283 Oct  4 18:25 yum_save_tx-2012-10-04-18-25xEeehY.yumtx
-rw-------   1 root       root            8283 Oct  4 18:26 yum_save_tx-2012-10-04-18-26Ce2_pV.yumtx
-rw-------   1 root       root             299 Oct  5 12:35 yum_save_tx-2012-10-05-12-35MyY3Rz.yumtx
-rw-------   1 root       root             977 Oct  5 12:35 yum_save_tx-2012-10-05-12-35TDvVRy.yumtx
-rw-------   1 root       root             995 Oct  5 13:56 yum_save_tx-2012-10-05-13-56qbqbCD.yumtx
-rw-------   1 root       root             456 Oct  5 13:56 yum_save_tx-2012-10-05-13-56yrfhyR.yumtx
-rw-------   1 root       root             890 Oct  5 14:00 yum_save_tx-2012-10-05-14-00BpI1J_.yumtx
-rw-------   1 root       root            1548 Oct  5 14:02 yum_save_tx-2012-10-05-14-02AZmN9r.yumtx
-rw-------   1 root       root             757 Oct  5 14:03 yum_save_tx-2012-10-05-14-03VN72l7.yumtx
-rw-------   1 root       root             757 Oct  5 14:08 yum_save_tx-2012-10-05-14-08UIfLnN.yumtx
-rw-------   1 root       root             522 Oct  5 14:11 yum_save_tx-2012-10-05-14-11wOufX9.yumtx
-rw-------   1 root       root            3138 Oct  5 14:13 yum_save_tx-2012-10-05-14-13OUvUsz.yumtx
-rw-------   1 root       root             634 Oct  8 12:50 yum_save_tx-2012-10-08-12-507pu1F7.yumtx
-rw-------   1 root       root             616 Oct  8 12:55 yum_save_tx-2012-10-08-12-55x6nAlq.yumtx
-rw-------   1 root       root             990 Oct  8 12:57 yum_save_tx-2012-10-08-12-57tfkVG2.yumtx
-rw-------   1 root       root            2321 Oct  8 12:58 yum_save_tx-2012-10-08-12-58fbDbqH.yumtx
-rw-------   1 root       root            1636 Oct  8 12:58 yum_save_tx-2012-10-08-12-58j1XSwY.yumtx
-rw-------   1 root       root            2346 Oct  8 12:58 yum_save_tx-2012-10-08-12-58ZlMesz.yumtx
-rw-------   1 root       root            2321 Oct  8 13:00 yum_save_tx-2012-10-08-13-007CNuna.yumtx
-rw-------   1 root       root             990 Oct  8 13:00 yum_save_tx-2012-10-08-13-00PqUhTT.yumtx
-rw-------   1 root       root             949 Oct  8 15:18 yum_save_tx-2012-10-08-15-18DNzsyi.yumtx
-rw-------   1 root       root             585 Oct  8 15:33 yum_save_tx-2012-10-08-15-33hu4El1.yumtx
-rw-------   1 root       root             585 Oct  8 15:33 yum_save_tx-2012-10-08-15-33ztJa1Z.yumtx
-rw-------   1 root       root             586 Oct  8 15:56 yum_save_tx-2012-10-08-15-56oZDvnT.yumtx
-rw-------   1 root       root             891 Oct  8 15:56 yum_save_tx-2012-10-08-15-56y1avnT.yumtx
-rw-------   1 root       root             586 Oct  8 16:06 yum_save_tx-2012-10-08-16-06M6cEFl.yumtx
-rw-------   1 root       root             586 Oct  8 16:40 yum_save_tx-2012-10-08-16-402COFDC.yumtx
-rw-------   1 root       root             522 Oct  8 16:47 yum_save_tx-2012-10-08-16-47hx578d.yumtx
-rw-------   1 root       root             522 Oct  8 16:47 yum_save_tx-2012-10-08-16-47KtluB1.yumtx

Your / directory is owned by the user apache and has 700 permissions which is wrong. For me it looks like this:

Code:

drwxr-xr-x 22 root  root      4096 Oct  8 17:00 ..

Did you do a chmod and chown on the / directory?
Thanks for the reply, and for your questions, yes, I think I did.
Should I return it to root? If so, what would be the proper code to use?

Thanks~

---edit---

Okay, so I used

Code:

chmod 755 /

and now it displays this...

Code:

total 354844
drwxrwxrwx.  8 root       root            4096 Oct 10 11:22 .
drwxr-xr-x.  28 root       root            4096 Oct 10 09:34 ..

Is this okay now?
I still cannot run MySQL...

Code:

MySQL Daemon failed to start.
Starting mysqld: [FAILED]

---edit 2---

Okay, I think I have fixed it. MySQL will now start when I type

Code:

service mysqld start

.
I think I should post here the things I did, for future reference?

The first thing I did was reinstall both mysql and mysql-server through yum.
And then, after reinstalling was done, I typed these following codes...

Code:

chown -R mysql.mysql /var/lib/mysql

Code:

su - mysql

I am not sure if those set of codes really fixed it, but those are the ones I used, and the MySQL Daemon error message is no longer appearing, and MySQL is starting with no problems.

Tags:

Related Articles

  • PHP and MySQL related ProblemJune 10

    I have a local LAN to my office. Recently I designed a New Software system using PHP, MySQL for my office. My boss wants to see the reports from online. My problem is, my network connection is often failed to my office. But I have to input all time.

  • MySQL-related problemJune 18

    I don't understand what happened. I haven't touched the server in a while, and when I typed the code Code: service mysqld start CentOS 6.3 replies with an Code: MySQL Daemon failed to start. Starting mysqld: [FAILED] I looked though the log files, an

  • Mysql password problems

    Mysql password problemsNovember 15

    I have problems when i create databases in my ispconfig, when i create a database, i se that it gets created with mysql client but the password is not set! I saw that i my ispconfig account (when i installed ispconfig) only had access to ispconfig da

  • CPU load locks up box. Apache or MYSQL related.

    CPU load locks up box. Apache or MYSQL related.May 6

    Code: top - 14:53:01 up 2 days, 1:09, 1 user, load average: 52.22, 68.57, 37.83 Tasks: 346 total, 1 running, 343 sleeping, 0 stopped, 2 zombie Cpu(s): 26.4%us, 11.2%sy, 0.2%ni, 0.0%id, 61.7%wa, 0.0%hi, 0.4%si, 0.0%st Mem: 2063384k total, 1940664k use

  • Am I right thinking that UEFI and GPT eliminate all the sector size related problems?June 22

    Am I right thinking that UEFI and GPT completely deprecate all the CHS/MBR legacy and eliminate all the sector size related problems (alignment, max drive size, etc.) as well as partitioning limitations (like the maximum of 4 primary partitions)? ---

  • Does the Canon EOS Rebel T5/1200D have any dust related problems?October 4

    I'm planning on purchasing the Canon EOS Rebel T5/1200D very soon. It's the only DSLR that fits my budget (other one is the Nikon D3100 which I don't plan to get). I like everything about the camera except that it does not have any Sensor Cleaning Sy

  • MySQL related Installation ProblemSeptember 16

    Hello all, I have run into a stumbling block in my installation of ISPConfig and I am hoping somebody can help. I have done everything as described in "The Perfect Setup" guide for SUSE.... the only complication being that I am running SUSE 10.0

  • MySql Server ProblemApril 24

    I am trying to connect a remote mysql server but when I try to connect then I get following error: ERROR 2003 (HY000): Can't connect to MySQL server on 'My Server IP' (110) Possibilities (Found over the web) : 1. May be local computer's outgoing conn

  • MySQL Database Problems - Growing too quick, PerformanceJanuary 29

    I have some problems with my database setup: The MySQL Database is written to every few seconds and it grows in size very quickly. My disk space is limited though, so I have to work around that. However, the data should not be that big. It's 3 tuples

  • Total newb having SSH tunnel and remote MySQL access problems November 8

    I don't often work with linux or need to SSH tunnel into remote MySQL databases, so pardon my ignorance. I'm using Windows 7 and am needing to connect to a remote MySQL instance on a Linux server. For months I had been using the HeidiSQL client appli

  • Careful with re-creating Websites or anything MYSQL related

    Careful with re-creating Websites or anything MYSQL relatedMarch 10

    Hi all, here is a, as I think, strange behaviour that I encountered within my system setup. After I was done re-creating, all seemd to work fine, at least so I thought. A local user, with different IPS reported that he could not reach my web sites. M

  • Another MySQL start problemJuly 31

    Hello all, I recently upgraded my Etch server to Lenny. At the same time, I also messed with the /var directory, trying to symlink it to another partition to save space. At some point, mysql stopped working, and I can't manage to start it again. Star

  • MySQL performance problems on particular vhostsAugust 9

    I have a dedicated server setup (8 cores, 16 GB of RAM), running Ubuntu 12.04 LTS with latest updates, and I am experiencing some performance problems related to MySQL. I have multiple vhosts active. Did some basic performance tuning. See below. Prob

  • SSL related problems

    SSL related problemsMarch 15

    I am having trouble accessing my server in https mode, I can access it fine via http, but not in secure mode. I have configured a public (CA) Certificate and I believe it is correct because apache2 asks for the passphrase and I can go into secure mod

  • error mysql #2002 - problems of permissions ?

    error mysql #2002 - problems of permissions ?April 30

    Hi, I'll try to explain my (big) problem with my bad english. I tried to change permissions of files on one website, but i used a bad line. So now it's impossible for me to have an access on my phpmyadmin... All my websites are down (Database connect

  • Dell PowerEdge IO and performance related problemsOctober 21

    I have an Dell PowerEdge 830, but after installing a 4:th disk and while copying backup files to this new disk the overall performance of the server just plummet. The system degrades to a point where it can not be accessed remotely over the network a

  • Mysql charset problemJune 11

    I'm trying to import some data from one server to another. But when I do it, I'm having problems with charset. Words like Goiânia became Goiâni and conceição became conceição My Application was set to use latin1 charset Server 1 : MySQL Charset :

  • mysql install problemsSeptember 12

    My MySQL is not working. I have recently reinstalled windows 7 on my machine and want to install Mysql and phpMyAdmin, but I fail already at Mysql. the service won't start and the error file is showing this info: 100912 11:36:28 [Note] Plugin 'FEDERA

  • Monitoring solution to help fix slow MySQL queries problemSeptember 15

    I have two servers: one that runs Apache and another one just for MySQL. I don't have any monitoring tools installed on any of them. Every once in a while it appears that my SQL queries are running very very slow (queries that would normally run in 0

  • Mysql performance problem & Failed DIMMMarch 14

    I have a dedicated mysql database server which has been having some performance problems recently, under normal load the server will be running fine, then suddenly out of the blue the performance will fall off a cliff. The server isn't using the swap

Copyright (C) 2017 ceus-now.com, All Rights Reserved. webmaster#ceus-now.com 14 q. 0.543 s.