[21:30] <tintin> I have installed mysql 5.1.20. I can't start mysqld or mysqld_safe. I am getting following errors:
[21:30],tin> 070721 16:08:15 mysqld_safe Starting mysqld daemon with databases from /home/me/mysql/mysql-cluster
[21:30] <tintin> ^G/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
[21:30] <tintin> 070721 16:08:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
[21:30] <chadmaynard> !perror 13
[21:30] <the_wench> OS error code 13: Permission denied
[21:30] * rook2pawn has quit IRC ()
[21:30] <chadmaynard> set datadir owner to mysql user
[21:31] <tintin> ok...thanks.
[21:32] <tintin> also...i searched for mysql.sock, there is none on my system. Is this normal for 5.1.20?
[21:33] <chadmaynard> mysql.sock is created when mysqld starts and destroyed when it exits
[21:33] <chadmaynard> if mysqld isn't running it won't exist
[21:33] <tintin> okey dokey..thanks.
[21:33] <sm_force> I lost my mysql.sock before, just disappeared.....currently doing a backup restore
[21:33] <sm_force> I couldnt access my db at all
[21:33] <chadmaynard> sm_force: in the dryer?
[21:33] <cmorgan> chadmaynard: yeah i think datetime is fine for us. i don't see anything about how its stored in the database though, at least not on the date/time page in the mysql docs
[21:33] <sm_force> I think the dog ran off with it
[21:34] * drwhat (n=virsys@or-71-54-198-12.dhcp.embarqhsd.net) has joined #mysql
[21:34] * tintin has quit IRC ("Download Gaim: http://gaim.sourceforge.net/")
[21:34] <cmorgan> chadmaynard: oh now i see. datetime is 8 bytes, timestamp is 4 bytes
[21:34] <chadmaynard> cmorgan: maybe it's on the mysql performance page....
[21:34] <cmorgan> chadmaynard: ahh and how its packed makes sense too
[21:35] <cmorgan> chadmaynard: http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html