You are not logged in.
Not sure where to look for some error reports. Since all my logs are empty.
I also did a yaourt -Rns mysql with no luck. This did not work either.
Could someone help me? This happend last time to. Not sure what I did to make it work.
Birger
P.S.: Solution will be added to the wiki.
Ed1t: Marked as solved.
Last edited by MindTooth (2009-06-24 14:50:51)
Offline
Try running it manually and see why it exits:
# mysqld_safe --datadir=/var/lib/mysql
Offline
try tail -f /var/log/everything.log
R.
Offline
Look for /var/lib/mysql/yourhostname.err
Is it there?
Offline
Try running it manually and see why it exits:
# mysqld_safe --datadir=/var/lib/mysql
I can start in safemode.
Look for /var/lib/mysql/yourhostname.err
Is it there?
It is there, and this is what I get in safemode:
090624 08:37:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
090624 8:37:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090624 8:37:07 InnoDB: Started; log sequence number 0 43685
090624 8:37:07 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
090624 8:37:07 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50068, now running 50135. Please use mysql_upgrade to fix this error.
090624 8:37:07 [ERROR] mysql.user has no `Event_priv` column at position 29
090624 8:37:07 [ERROR] Cannot open mysql.event
090624 8:37:07 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
090624 8:37:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.35' socket: '/tmp/mysql.sock' port: 3306 Source distribution
I am unable to start in mysqld when not using safemode. This is then outputed:
090624 8:40:58 InnoDB: Starting shutdown...
090624 8:40:59 InnoDB: Shutdown completed; log sequence number 0 43685
090624 8:40:59 [Warning] Forcing shutdown of 2 plugins
090624 8:40:59 [Note] /usr/sbin/mysqld: Shutdown complete
Birger
Offline
I would say it still looks like a privilege problem, but my guess is, that it was working well before the update. So it must be something else. More and more people gets some problem with this update. Like here:
http://bbs.archlinux.org/viewtopic.php?id=74224
http://bbs.archlinux.org/viewtopic.php?id=74295
If you have important data in the mysql database you should try to downgrade to 5.1.34
If you don't have any, then you can try:
rm -rf /var/lib/mysql/*
mysql_install_db --user mysql
/etc/rc.d/mysqld start
Offline
Ran the chmod line in the Wiki. But no help.
Have cleared my cache, is there a place where I can get the previous package?
Birger
Ed1t: Yes. I have some importan databases. I could try a backup, and remove them.
Ed2t: For some wicked reason. It worked now.
Last edited by MindTooth (2009-06-24 09:00:43)
Offline
Run mysql_upgrade as root like this: mysql_upgrade -u root -p
Then try /etc/rc.d/mysqld start
R.
Offline
I did, and added it to the wiki. Not sure however it is what this that fixed. Because I had MySQL running before I ran the command the first time.
Birger
Offline
I can guarantee it was what fixed the problem... because I had a similar problem and that did it
R
Offline