Re: Starting mysql

2011-12-13 Thread Dennis Jacobfeuerborn
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 th

Re: Starting mysql

2011-12-12 Thread Denis Arnaud
Date: Mon, 12 Dec 2011 17:15:25 + > From: "Paul F. Johnson" > > 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

Re: Starting mysql

2011-12-12 Thread Paul F. Johnson
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 mys

Re: Starting mysql

2011-12-12 Thread Daniel J Walsh
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/12/2011 01:15 AM, Tom Lane wrote: > "Paul F. Johnson" 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

Re: Starting mysql

2011-12-11 Thread Tom Lane
"Paul F. Johnson" 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

Re: Starting mysql

2011-12-11 Thread Reindl Harald
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: > expecte

Re: Starting mysql

2011-12-11 Thread Pierre Jaury
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 +, Paul F. Johnson wrote: > Hi, > > > Did you initialize

Re: Starting mysql

2011-12-11 Thread 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 cha

Re: Starting mysql

2011-12-11 Thread Pierre Jaury
Did you initialize databases as suggested (mysql_install_db) ? On Sun, 2011-12-11 at 20:50 +, 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

Re: Starting mysql

2011-12-11 Thread Paul F. Johnson
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 > systemc

Re: Starting mysql

2011-12-11 Thread Tom Lane
"Paul F. Johnson" 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

Re: Starting mysql

2011-12-11 Thread Pierre Jaury
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.* a

Starting mysql

2011-12-11 Thread Paul F. Johnson
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