MySQL problem after upgrade
Michael Satterwhite
michael at weblore.com
Wed Dec 23 15:24:32 UTC 2009
I've just done the upgrade to 9.10. Most things went very smoothly, but I've
got a snag. MySQL isn't running, and I can't figure out why.
When I run mysqld_safe (as root, of course), I get the following messages:
mysqld_safe Logging to syslog.
mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
Looking at syslog, I do see a statement that I should run mysql_upgrade. I
tried to do that, but it failed with the message Can't connect to local MySQL
server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect
Note that the .sock file doesn't exist.
Can anyone offer any help? I'd appreciate it greatly.
In syslog, I have the following messages from trying to run mysqld_safe:
mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
kernel: [58516.376931] type=1503 audit(1261581313.299:112): operation="open"
pid=9681 parent=9564 profile="/usr/sbin/mysqld" requested_mask="r::"
denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
kernel: [58516.377792] type=1503 audit(1261581313.299:113): operation="open"
pid=9681 parent=9564 profile="/usr/sbin/mysqld" requested_mask="::r"
denied_mask="::r" fsuid=0 ouid=1000 name="/home/michael/.my.cnf"
mysqld: 091223 9:15:13 [Warning] The syntax '--log' is deprecated and will be
removed in MySQL 7.0. Please use '--general_log'/'--general_log_file' instead.
mysqld: 091223 9:15:13 [Note] Plugin 'FEDERATED' is disabled.
mysqld: /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
mysqld: 091223 9:15:13 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
mysqld: 091223 9:15:13 InnoDB: Started; log sequence number 0 883394962
mysqld: 091223 9:15:13 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
mysqld: 091223 9:15:13 [ERROR] Aborting
mysqld:
mysqld: 091223 9:15:13 InnoDB: Starting shutdown...
mysqld: 091223 9:15:14 InnoDB: Shutdown completed; log sequence number 0
883394962
mysqld: 091223 9:15:14 [Warning] Forcing shutdown of 1 plugins
mysqld: 091223 9:15:14 [Note] /usr/sbin/mysqld: Shutdown complete
mysqld:
mysqld from pid file /var/run/mysqld/mysqld.pid ended
More information about the ubuntu-users
mailing list