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