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@xxxxxxxx> +33(0)1.83.64.80.90 Réalisateur, hébergeur et infogéreur indépendant Internet hosting, outsourcing and development as a freelancer
Attachment:
signature.asc
Description: This is a digitally signed message part
-- devel mailing list devel@xxxxxxxxxxxxxxxxxxxxxxx https://admin.fedoraproject.org/mailman/listinfo/devel
