Arch Linux

germandev

Member

Registered: 2009-11-15

Posts: 14

mysql doesnt start

Hi!

I am using Arch x64. I installed MySQL using pacman but I can't get it started.

When running /etc/rc.d/mysqld start

The message "Busy" stays for several seconds but then changes to "failed" finally. Unfortunately I didn't find any log entry.

Do you have any idea what the problem might be?

Thank you in advance!

wonder

Developer

From: Bucharest, Romania

Registered: 2006-07-05

Posts: 5,941

Website

Re: mysql doesnt start

it would be usefull to post the version: pacman -Q mysql

---

Give what you have. To someone, it may be better than you dare to think.

arkham

Member

From: Stockholm

Registered: 2008-10-26

Posts: 516

Website

Re: mysql doesnt start

Try also searching in /var/lib/myql for logs.

---

"I'm Winston Wolfe. I solve problems."

~ Need moar games? [arch-games] ~ [aurcheck] AUR haz updates? ~

Urfaust

Member

From: Germany

Registered: 2009-01-30

Posts: 164

Re: mysql doesnt start

Same problem here.

[2009-11-21 11:02] upgraded libmysqlclient (5.1.41-1 -> 5.1.41-3)
[2009-11-21 11:02] upgraded mysql-clients (5.1.41-1 -> 5.1.41-3)
[2009-11-21 11:02] upgraded mysql (5.1.41-1 -> 5.1.41-3)
[2009-11-21 11:02] warning: /etc/php/php.ini installed as /etc/php/php.ini.pacnew
[2009-11-21 11:02] upgraded php (5.3.0-5 -> 5.3.1-2)
[2009-11-21 11:02] upgraded php-apache (5.3.0-5 -> 5.3.1-2)
[2009-11-21 11:02] upgraded php-gd (5.3.0-5 -> 5.3.1-2)

Edited socket path in php.ini and my.cnf , mysql and mysqli section in php.ini. Did chown mysql:mysql /var/lib/mysql -R
and

sudo mysql_config --socket
/var/run/mysqld/mysqld.sock

There is an .err file under /var/lib/mysql but there are no suspicious entrys in it?

091121 12:02:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091121 12:02:20 [Note] Plugin 'FEDERATED' is disabled.
091121 12:02:20 [Note] Plugin 'ndbcluster' is disabled.
091121 12:02:20  InnoDB: Started; log sequence number 0 46439
091121 12:02:20 [Note] Event Scheduler: Loaded 0 events
091121 12:02:20 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Source distribution

Thanks in advance.

Urfaust

Member

From: Germany

Registered: 2009-01-30

Posts: 164

Re: mysql doesnt start

So now for the fun part:
MySQL says:

sudo /etc/rc.d/mysqld start
:: Starting MySQL                                                        [FAIL]

but everything is working. I can login to my databases, phpmyadmin is working and MySQL Administrator also works. O_o
What's going on?

jelly

Administrator

From: /dev/null

Registered: 2008-06-10

Posts: 714

Re: mysql doesnt start

So now for the fun part:
MySQL says:

sudo /etc/rc.d/mysqld start
:: Starting MySQL                                                        [FAIL]

but everything is working. I can login to my databases, phpmyadmin is working and MySQL Administrator also works. O_o
What's going on?

Then it's already running, so `restart` it.

---

dotfiles

Urfaust

Member

From: Germany

Registered: 2009-01-30

Posts: 164

Re: mysql doesnt start

So now for the fun part:
MySQL says:

sudo /etc/rc.d/mysqld start
:: Starting MySQL                                                        [FAIL]

but everything is working. I can login to my databases, phpmyadmin is working and MySQL Administrator also works. O_o
What's going on?

Then it's already running, so `restart` it.

Thanks for your answer. But it is not running in the first place.;)

╰─>ps -fC mysqld
UID        PID  PPID  C STIME TTY          TIME CMD

╰─>sudo /etc/rc.d/httpd start
:: Starting Apache Web Server                                                                              [DONE] 

╰─>ps -fC mysqld
UID        PID  PPID  C STIME TTY          TIME CMD

╰─>sudo /etc/rc.d/mysqld start
:: Starting MySQL                                                                                          [FAIL] 

╰─>ps -fC mysqld
UID        PID  PPID  C STIME TTY          TIME CMD
mysql     4935  4837  0 13:32 pts/1    00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=my

Last edited by Urfaust (2009-11-22 12:38:26)

Amine 7bal

Member

From: Tunis, Tunisia

Registered: 2009-06-05

Posts: 4

Re: mysql doesnt start

I had the same problem, MySQL doesnt start (version 5.1.41).
I solved the problem by removing it:

pacman -Rd mysql

and then re-installing it:

pacman -S mysql

I hope this will work for you too.

MW

Member

Registered: 2007-07-27

Posts: 127

Re: mysql doesnt start

I had the same problem, MySQL doesnt start (version 5.1.41).
I solved the problem by removing it:

pacman -Rd mysql

and then re-installing it:

pacman -S mysql

I hope this will work for you too.

This fixed it for me too, thanks.

andreamer

Member

Registered: 2009-08-11

Posts: 41

Re: mysql doesnt start

same for me, worked on reinstall... what could be the reason for this?

darose

Member

Registered: 2004-04-13

Posts: 158

Re: mysql doesnt start

I think this happened because you had no /var/lib/mysql directory.  It looks like the package doesn't create one when upgrading, but does create it on initial install:

[darose@daroselin puppet]$ sudo pacman -S mysql
resolving dependencies...
looking for inter-conflicts...

Targets (1): mysql-5.1.41-3  

Total Download Size:    0.00 MB
Total Installed Size:   59.62 MB

Proceed with installation? [Y/n] 
checking package integrity...
(1/1) checking for file conflicts                   [#############################################################################################################################] 100%
(1/1) installing mysql                              [#############################################################################################################################] 100%
Installing MySQL system tables...

...