Hi,
No idea why I can't get mysql running on my rawhide box. When I try to start it up, I get the infamous
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
This looks like the daemon isn't running or the service isn't running.
service mysql or service mysqld is giving nothing and I can't find mysqld anywhere either.
There are some mysql-mmm entries in /etc/init.d but nothing else.
How do I get it running?
Paul
Since recent rawhide changes, default mysql-server installation does not install service bindings (rc.*, checkconfig, etc.) anymore.
First initialize mysql databases in /var/lib/mysql using mysql_install_db then run mysqld_safe if you want a quick installation running. Otherwise, unpack old rc.* and checkconfig files from old packages. They still work.
On Sun, 2011-12-11 at 17:25 +0000, Paul F. Johnson wrote:
Hi,
No idea why I can't get mysql running on my rawhide box. When I try to start it up, I get the infamous
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
This looks like the daemon isn't running or the service isn't running.
service mysql or service mysqld is giving nothing and I can't find mysqld anywhere either.
There are some mysql-mmm entries in /etc/init.d but nothing else.
How do I get it running?
Paul
Vertraue mir, ich weiss, was ich mache...
"Paul F. Johnson" paul@all-the-johnsons.co.uk writes:
No idea why I can't get mysql running on my rawhide box. When I try to start it up, I get the infamous ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) This looks like the daemon isn't running or the service isn't running.
Yup, that's what it looks like.
service mysql or service mysqld is giving nothing and I can't find mysqld anywhere either.
Ummm ... do you have mysql-server RPM installed? But in any case, Fedora's mysql package was converted to systemd some time ago, so you might have better luck using the native systemd service management commands:
systemctl enable mysqld.service systemctl start mysqld.service systemctl status mysqld.service
If "start" fails, there might be relevant info in either or both of /var/log/messages and /var/log/mysqld.log.
(One of the prime reasons forcing conversion to systemd was that systemd's handling of SysV init scripts is so utterly user-unfriendly. It surprises me not at all that the emulated "service" commands aren't telling you anything useful. They pretty much suck, so you should learn the new ones ASAP.)
regards, tom lane
Hi Tom,
Ummm ... do you have mysql-server RPM installed?
Yep.
But in any case, Fedora's mysql package was converted to systemd some time ago, so you might have better luck using the native systemd service management commands:
systemctl enable mysqld.service systemctl start mysqld.service systemctl status mysqld.service
If "start" fails, there might be relevant info in either or both of /var/log/messages and /var/log/mysqld.log.
start fails - it's telling me...
[root@PB3 paul]# systemctl status mysqld.service mysqld.service - MySQL database server Loaded: loaded (/lib/systemd/system/mysqld.service; enabled) Active: activating (start-post) since Sun, 11 Dec 2011 20:40:36 +0000; 801ms ago Process: 5077 ExecStart=/usr/bin/mysqld_safe --nowatch --basedir=/usr (code=exited, status=0/SUCCESS) Process: 5060 ExecStartPre=/usr/libexec/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS) Main PID: 5213 (mysqld); Control: 5214 (mysqld-wait-rea) CGroup: name=systemd:/system/mysqld.service ├ 5213 /usr/libexec/mysqld --basedir=/usr --datadir=/var/... ├ 5214 /bin/sh /usr/libexec/mysqld-wait-ready 5213 └ 5243 sleep 1
with this in var/log/messages
Dec 11 20:47:17 PB3 mysqld_safe[2417]: 111211 20:47:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Dec 11 20:47:18 PB3 systemd[1]: mysqld.service: main process exited, code=exited, status=1 Dec 11 20:47:19 PB3 systemd[1]: mysqld.service: control process exited, code=exited status=1 Dec 11 20:47:19 PB3 systemd[1]: mysqld.service holdoff time over, scheduling restart. Dec 11 20:47:19 PB3 systemd[1]: Job pending for unit, delaying automatic restart. Dec 11 20:47:19 PB3 systemd[1]: Unit mysqld.service entered failed state. Dec 11 20:47:19 PB3 mysqld_safe[2657]: 111211 20:47:19 mysqld_safe Logging to '/var/log/mysqld.log'. Dec 11 20:47:19 PB3 mysqld_safe[2657]: 111211 20:47:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Dec 11 20:47:21 PB3 systemd[1]: mysqld.service: main process exited, code=exited, status=1 Dec 11 20:47:22 PB3 systemd[1]: mysqld.service: control process exited, code=exited status=1 Dec 11 20:47:22 PB3 systemd[1]: mysqld.service holdoff time over, scheduling restart. Dec 11 20:47:22 PB3 systemd[1]: Job pending for unit, delaying automatic restart. Dec 11 20:47:22 PB3 systemd[1]: Unit mysqld.service entered failed state. Dec 11 20:47:22 PB3 mysqld_safe[2872]: 111211 20:47:22 mysqld_safe Logging to '/var/log/mysqld.log'. Dec 11 20:47:22 PB3 mysqld_safe[2872]: 111211 20:47:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Dec 11 20:47:23 PB3 systemd[1]: mysqld.service: main process exited, code=exited, status=1 Dec 11 20:47:24 PB3 systemd[1]: mysqld.service: control process exited, code=exited status=1 Dec 11 20:47:25 PB3 systemd[1]: mysqld.service holdoff time over, scheduling restart. Dec 11 20:47:25 PB3 systemd[1]: Job pending for unit, delaying automatic restart. Dec 11 20:47:25 PB3 systemd[1]: Unit mysqld.service entered failed state. Dec 11 20:47:25 PB3 mysqld_safe[3079]: 111211 20:47:25 mysqld_safe Logging to '/var/log/mysqld.log'. Dec 11 20:47:25 PB3 mysqld_safe[3079]: 111211 20:47:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Dec 11 20:47:26 PB3 systemd[1]: mysqld.service: main process exited, code=exited, status=1 Dec 11 20:47:27 PB3 systemd[1]: mysqld.service: control process exited, code=exited status=1 Dec 11 20:47:27 PB3 systemd[1]: mysqld.service holdoff time over, scheduling restart. Dec 11 20:47:27 PB3 systemd[1]: Job pending for unit, delaying automatic restart. Dec 11 20:47:27 PB3 systemd[1]: Unit mysqld.service entered failed state. Dec 11 20:47:28 PB3 mysqld_safe[3287]: 111211 20:47:28 mysqld_safe Logging to '/var/log/mysqld.log'. Dec 11 20:47:28 PB3 mysqld_safe[3287]: 111211 20:47:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Dec 11 20:47:29 PB3 systemd[1]: mysqld.service: main process exited, code=exited, status=1 Dec 11 20:47:30 PB3 systemd[1]: mysqld.service: control process exited, code=exited status=1 Dec 11 20:47:30 PB3 systemd[1]: mysqld.service holdoff time over, scheduling restart. Dec 11 20:47:30 PB3 systemd[1]: Job pending for unit, delaying automatic restart. Dec 11 20:47:30 PB3 systemd[1]: Unit mysqld.service entered failed state. Dec 11 20:47:31 PB3 mysqld_safe[3498]: 111211 20:47:31 mysqld_safe Logging to '/var/log/mysqld.log'. Dec 11 20:47:31 PB3 mysqld_safe[3498]: 111211 20:47:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Dec 11 20:47:32 PB3 systemd[1]: mysqld.service: main process exited, code=exited, status=1
/var/log/mysqld.log shows this
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) 111211 20:48:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 111211 20:48:33 [Note] Plugin 'FEDERATED' is disabled. 111211 20:48:33 InnoDB: The InnoDB memory heap is disabled 111211 20:48:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins 111211 20:48:33 InnoDB: Compressed tables use zlib 1.2.5 111211 20:48:33 InnoDB: Using Linux native AIO 111211 20:48:33 InnoDB: Initializing buffer pool, size = 128.0M 111211 20:48:33 InnoDB: Completed initialization of buffer pool 111211 20:48:33 InnoDB: highest supported file format is Barracuda. 111211 20:48:33 InnoDB: Waiting for the background threads to start 111211 20:48:34 InnoDB: 1.1.8 started; log sequence number 1589339 111211 20:48:34 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/proxies_priv.frm' (errno: 13) 111211 20:48:34 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/proxies_priv.frm' (errno: 13) 111211 20:48:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Any ideas?
Paul
Did you initialize databases as suggested (mysql_install_db) ?
On Sun, 2011-12-11 at 20:50 +0000, Paul F. Johnson wrote:
Hi Tom,
Ummm ... do you have mysql-server RPM installed?
Yep.
But in any case, Fedora's mysql package was converted to systemd some time ago, so you might have better luck using the native systemd service management commands:
systemctl enable mysqld.service systemctl start mysqld.service systemctl status mysqld.service
If "start" fails, there might be relevant info in either or both of /var/log/messages and /var/log/mysqld.log.
start fails - it's telling me...
[root@PB3 paul]# systemctl status mysqld.service mysqld.service - MySQL database server Loaded: loaded (/lib/systemd/system/mysqld.service; enabled) Active: activating (start-post) since Sun, 11 Dec 2011 20:40:36 +0000; 801ms ago Process: 5077 ExecStart=/usr/bin/mysqld_safe --nowatch --basedir=/usr (code=exited, status=0/SUCCESS) Process: 5060 ExecStartPre=/usr/libexec/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS) Main PID: 5213 (mysqld); Control: 5214 (mysqld-wait-rea) CGroup: name=systemd:/system/mysqld.service ├ 5213 /usr/libexec/mysqld --basedir=/usr --datadir=/var/... ├ 5214 /bin/sh /usr/libexec/mysqld-wait-ready 5213 └ 5243 sleep 1
with this in var/log/messages
Dec 11 20:47:17 PB3 mysqld_safe[2417]: 111211 20:47:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Dec 11 20:47:18 PB3 systemd[1]: mysqld.service: main process exited, code=exited, status=1 Dec 11 20:47:19 PB3 systemd[1]: mysqld.service: control process exited, code=exited status=1 Dec 11 20:47:19 PB3 systemd[1]: mysqld.service holdoff time over, scheduling restart. Dec 11 20:47:19 PB3 systemd[1]: Job pending for unit, delaying automatic restart. Dec 11 20:47:19 PB3 systemd[1]: Unit mysqld.service entered failed state. Dec 11 20:47:19 PB3 mysqld_safe[2657]: 111211 20:47:19 mysqld_safe Logging to '/var/log/mysqld.log'. Dec 11 20:47:19 PB3 mysqld_safe[2657]: 111211 20:47:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Dec 11 20:47:21 PB3 systemd[1]: mysqld.service: main process exited, code=exited, status=1 Dec 11 20:47:22 PB3 systemd[1]: mysqld.service: control process exited, code=exited status=1 Dec 11 20:47:22 PB3 systemd[1]: mysqld.service holdoff time over, scheduling restart. Dec 11 20:47:22 PB3 systemd[1]: Job pending for unit, delaying automatic restart. Dec 11 20:47:22 PB3 systemd[1]: Unit mysqld.service entered failed state. Dec 11 20:47:22 PB3 mysqld_safe[2872]: 111211 20:47:22 mysqld_safe Logging to '/var/log/mysqld.log'. Dec 11 20:47:22 PB3 mysqld_safe[2872]: 111211 20:47:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Dec 11 20:47:23 PB3 systemd[1]: mysqld.service: main process exited, code=exited, status=1 Dec 11 20:47:24 PB3 systemd[1]: mysqld.service: control process exited, code=exited status=1 Dec 11 20:47:25 PB3 systemd[1]: mysqld.service holdoff time over, scheduling restart. Dec 11 20:47:25 PB3 systemd[1]: Job pending for unit, delaying automatic restart. Dec 11 20:47:25 PB3 systemd[1]: Unit mysqld.service entered failed state. Dec 11 20:47:25 PB3 mysqld_safe[3079]: 111211 20:47:25 mysqld_safe Logging to '/var/log/mysqld.log'. Dec 11 20:47:25 PB3 mysqld_safe[3079]: 111211 20:47:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Dec 11 20:47:26 PB3 systemd[1]: mysqld.service: main process exited, code=exited, status=1 Dec 11 20:47:27 PB3 systemd[1]: mysqld.service: control process exited, code=exited status=1 Dec 11 20:47:27 PB3 systemd[1]: mysqld.service holdoff time over, scheduling restart. Dec 11 20:47:27 PB3 systemd[1]: Job pending for unit, delaying automatic restart. Dec 11 20:47:27 PB3 systemd[1]: Unit mysqld.service entered failed state. Dec 11 20:47:28 PB3 mysqld_safe[3287]: 111211 20:47:28 mysqld_safe Logging to '/var/log/mysqld.log'. Dec 11 20:47:28 PB3 mysqld_safe[3287]: 111211 20:47:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Dec 11 20:47:29 PB3 systemd[1]: mysqld.service: main process exited, code=exited, status=1 Dec 11 20:47:30 PB3 systemd[1]: mysqld.service: control process exited, code=exited status=1 Dec 11 20:47:30 PB3 systemd[1]: mysqld.service holdoff time over, scheduling restart. Dec 11 20:47:30 PB3 systemd[1]: Job pending for unit, delaying automatic restart. Dec 11 20:47:30 PB3 systemd[1]: Unit mysqld.service entered failed state. Dec 11 20:47:31 PB3 mysqld_safe[3498]: 111211 20:47:31 mysqld_safe Logging to '/var/log/mysqld.log'. Dec 11 20:47:31 PB3 mysqld_safe[3498]: 111211 20:47:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Dec 11 20:47:32 PB3 systemd[1]: mysqld.service: main process exited, code=exited, status=1
/var/log/mysqld.log shows this
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) 111211 20:48:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 111211 20:48:33 [Note] Plugin 'FEDERATED' is disabled. 111211 20:48:33 InnoDB: The InnoDB memory heap is disabled 111211 20:48:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins 111211 20:48:33 InnoDB: Compressed tables use zlib 1.2.5 111211 20:48:33 InnoDB: Using Linux native AIO 111211 20:48:33 InnoDB: Initializing buffer pool, size = 128.0M 111211 20:48:33 InnoDB: Completed initialization of buffer pool 111211 20:48:33 InnoDB: highest supported file format is Barracuda. 111211 20:48:33 InnoDB: Waiting for the background threads to start 111211 20:48:34 InnoDB: 1.1.8 started; log sequence number 1589339 111211 20:48:34 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/proxies_priv.frm' (errno: 13) 111211 20:48:34 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/proxies_priv.frm' (errno: 13) 111211 20:48:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Any ideas?
Paul
Vertraue mir, ich weiss, was ich mache...
Hi,
Did you initialize databases as suggested (mysql_install_db) ?
Yep - gave me this
[root@PB3 paul]# mysql_install_db Installing MySQL system tables... 111211 21:00:37 [ERROR] Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64). ERROR: 1136 Column count doesn't match value count at row 1 111211 21:00:38 [ERROR] Aborting
111211 21:00:38 [Note] /usr/libexec/mysqld: Shutdown complete
Installation of system tables failed! Examine the logs in /var/lib/mysql for more information.
You can try to start the mysqld daemon with:
shell> /usr/libexec/mysqld --skip-grant &
and use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful.
Please consult the MySQL manual section 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source are the MySQL email archives available at http://lists.mysql.com/.
Please check all of the above before mailing us! And remember, if you do mail us, you MUST use the /usr/bin/mysqlbug script!
Any advice would be appreciated.
Paul
Am 11.12.2011 22:02, schrieb Paul F. Johnson:
Hi,
Did you initialize databases as suggested (mysql_install_db) ?
Yep - gave me this
[root@PB3 paul]# mysql_install_db Installing MySQL system tables... 111211 21:00:37 [ERROR] Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64). ERROR: 1136 Column count doesn't match value count at row 1 111211 21:00:38 [ERROR] Aborting
111211 21:00:38 [Note] /usr/libexec/mysqld: Shutdown complete
sounds like this is not a fresh install
people should be advised to call "mysql_upgrade -u root -p" after EACH minor update to avoid such issues over the long
use this to start mysqld without permissions-system but make sure it is not reachable for clients as long it is running without priv
http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_ski...
after mysqld si running use "mysql_upgrade -u" (you do not need a password at this point) and after that REMOVE skip-grant from your config and restart the service a last time to active privilege control
Uh, if you have existing mysqld root dir, try mysqld_upgrade. Otherwise, try cleaning your /var/lib/mysql (and backing up any interesting MyISAM or InnoDB index/data you want to keep) then initialize again.
On Sun, 2011-12-11 at 21:02 +0000, Paul F. Johnson wrote:
Hi,
Did you initialize databases as suggested (mysql_install_db) ?
Yep - gave me this
[root@PB3 paul]# mysql_install_db Installing MySQL system tables... 111211 21:00:37 [ERROR] Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64). ERROR: 1136 Column count doesn't match value count at row 1 111211 21:00:38 [ERROR] Aborting
111211 21:00:38 [Note] /usr/libexec/mysqld: Shutdown complete
Installation of system tables failed! Examine the logs in /var/lib/mysql for more information.
You can try to start the mysqld daemon with:
shell> /usr/libexec/mysqld --skip-grant &and use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql mysql> show tablesTry 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful.
Please consult the MySQL manual section 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source are the MySQL email archives available at http://lists.mysql.com/.
Please check all of the above before mailing us! And remember, if you do mail us, you MUST use the /usr/bin/mysqlbug script!
Any advice would be appreciated.
Paul
-- Vertraue mir, ich weiss, was ich mache...
"Paul F. Johnson" paul@all-the-johnsons.co.uk writes:
/var/log/mysqld.log shows this
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.
Alternatively, if you don't have any valuable data in your database (and I hope you aren't running anything *real* critical on rawhide ;-)) you could just rm -rf everything under /var/lib/mysql and let it initialize a brand new database.
regards, tom lane
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On 12/12/2011 01:15 AM, Tom Lane wrote:
"Paul F. Johnson" paul@all-the-johnsons.co.uk writes:
/var/log/mysqld.log shows this
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.
Alternatively, if you don't have any valuable data in your database (and I hope you aren't running anything *real* critical on rawhide ;-)) you could just rm -rf everything under /var/lib/mysql and let it initialize a brand new database.
regards, tom lane
SELinux error messages could also be in /var/log/audit/audit.log
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
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
-
Daniel J Walsh -
Dennis Jacobfeuerborn -
Paul F. Johnson -
Pierre Jaury -
Reindl Harald -
Tom Lane