Starting mysql

Sun Dec 11 20:50:11 UTC 2011

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 at 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...