[TriLUG] Need Help with mysql start up on opensuse 12.1

[Paul Boyle]

Hi,

I've changed the user:group owner to mysql:mysql and I've, as Shawn
suggested made the permissions of all the subdirectories under
/var/lib/mysql/ the same (I set them to 660.  I've also tried 600
permissions as well.  In all cases tried so far the error is exactly the
same as I had originally posted -- something about mysql.sock not appearing
in 30 seconds.

In an off list reply, Shawn wanted me to post a copy of the mysqld.log.
This file indicates that the server can't find a plugin
(./mysql/plugin.frm) and that  mysql_upgrade needs to be run, but when I do
that, that also fails because it can't find the mysql.sock socket.  Here is
the log entry from the last invocation:

120210 11:23:07 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
^G/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
120210 11:23:07 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
120210 11:23:07 InnoDB: The InnoDB memory heap is disabled
120210 11:23:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120210 11:23:07 InnoDB: Compressed tables use zlib 1.2.5
120210 11:23:07 InnoDB: Initializing buffer pool, size = 128.0M
120210 11:23:07 InnoDB: Completed initialization of buffer pool
120210 11:23:07  InnoDB: Operating system error number 13 in a file
operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
120210 11:23:07 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid
ended
120210 11:26:04 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
^G/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
120210 11:26:04 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
120210 11:26:04 InnoDB: The InnoDB memory heap is disabled
120210 11:26:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120210 11:26:04 InnoDB: Compressed tables use zlib 1.2.5
120210 11:26:04 InnoDB: Initializing buffer pool, size = 128.0M
120210 11:26:04 InnoDB: Completed initialization of buffer pool
120210 11:26:04  InnoDB: Operating system error number 13 in a file
operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
120210 11:26:04 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid
ended


Any other suggestions?

Thanks,

Paul


-- 
Paul D. Boyle
Director, X-ray Structural Facility
Department of Chemistry - Box 8204
North Carolina State University
Raleigh, NC 27695-8204