Starting mysql

Paul F. Johnson paul at all-the-johnsons.co.uk
Mon Dec 12 17:15:25 UTC 2011


Hi,

> > 111211 20:48:32 [ERROR] /usr/libexec/mysqld: Can't find file:
> > './mysql/proxies_priv.frm' (errno: 13)
> > 111211 20:48:32 [ERROR] Fatal error: Can't open and lock privilege
> > tables: Can't find file: './mysql/proxies_priv.frm' (errno: 13)
> 
> I think the nearby suggestions to run mysql_upgrade are probably right,
> especially if you're trying to upgrade from some pre-5.5 version of
> mysql.  But it occurs to me that there's some chance of SELinux
> interference; do you see any avc messages in /var/log/messages?
> If so, restorecon on the /var/lib/mysql tree ought to fix that.

Removed the entire mysql* rpms, installed fresh via yum, rm
-rf /var/lib/mysql, enabled the service, did the mysql_install_db and
all is good.

Trying to start the server gives me this though...

111212 07:49:18 mysqld_safe Starting mysqld daemon with databases
from /var/lib/mysql
111212  7:49:18 [Note] Plugin 'FEDERATED' is disabled.
111212  7:49:18 InnoDB: The InnoDB memory heap is disabled
111212  7:49:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
111212  7:49:18 InnoDB: Compressed tables use zlib 1.2.5
111212  7:49:18 InnoDB: Using Linux native AIO
111212  7:49:18 InnoDB: Initializing buffer pool, size = 128.0M
111212  7:49:18 InnoDB: Completed initialization of buffer pool
111212  7:49:18 InnoDB: highest supported file format is Barracuda.
111212  7:49:19  InnoDB: Waiting for the background threads to start
111212  7:49:20 InnoDB: 1.1.8 started; log sequence number 1589339
111212  7:49:20 [ERROR] /usr/libexec/mysqld: Can't find file:
'./mysql/proxies_priv.frm' (errno: 13)
111212  7:49:20 [ERROR] Fatal error: Can't open and lock privilege
tables: Can't find file: './mysql/proxies_priv.frm' (errno: 13)

Where should this proxies_priv.frm reside as it looks to be the same
missing file as before?

Thanks

PFJ
-- 
Vertraue mir, ich weiss, was ich mache...



More information about the devel mailing list