You are not logged in.
Pages: 1
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!
Offline
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.
Offline
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? ~
Offline
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.
Offline
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?
Offline
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.
Offline
Urfaust wrote: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)
Offline
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.
Offline
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.
Offline
same for me, worked on reinstall... what could be the reason for this?
Offline
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...
...
Offline
Pages: 1