Starting mysql
Dennis Jacobfeuerborn
dennisml at conversis.de
Tue Dec 13 12:33:27 UTC 2011
On 12/12/2011 06:15 PM, Paul F. Johnson wrote:
> 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?
What does 'which mysql_install_db' say? Maybe there is another older
version of that script in your path?
Also what does 'grep "CREATE TABLE.*proxies_priv"
/usr/share/mysql/mysql_system_tables.sql' say? That's what is used by
mysql_install_db to create the system tables.
Have you actually done an 'ls -l /var/lib/mysql/mysql' to verify that the
file is indeed missing? Do the MYD and MYI files for that table exist?
Regards,
Dennis
More information about the devel
mailing list