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

[Glenn Hennessee]

In /var/lib/mysql/mysql I have the file plugin.frm. Do you have that
file there? The permissions on all files in /var/lib/mysql/mysql are
660.

On Fri, Feb 10, 2012 at 11:37 AM, Paul Boyle <boyle at ncsu.edu> wrote:
> 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
> --
> This message was sent to: glenn.hennessee at gmail.com <glenn.hennessee at gmail.com>
> To unsubscribe, send a blank message to trilug-leave at trilug.org from that address.
> TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
> Unsubscribe or edit options on the web  : http://www.trilug.org/mailman/options/trilug/glenn.hennessee%40gmail.com
> TriLUG FAQ          : http://www.trilug.org/wiki/Frequently_Asked_Questions



-- 
Glenn