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...
--
Pierre Jaury <pierre(a)jaury.eu> +33(0)1.83.64.80.90
Réalisateur, hébergeur et infogéreur indépendant
Internet hosting, outsourcing and development as a freelancer