On Sunday 04 April 2004 18.10, Frederic Durodie wrote:
On Sunday 04 April 2004 17:52, Anders Johansson wrote:
Use /etc/init.d/mysql start (or rcmysql start - same thing, fewer characters to type) to start it instead. It uses mysql_safe. If you look at how that calls mysql_safe you might see what you did wrong
I tried this but unfortunately to no avail ...
SusiX:/var/lib/mysql # /etc/init.d/mysql start Starting service MySQL failed
040404 17:54:55 mysqld started 040404 17:54:57 InnoDB: Started 040404 17:54:57 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 040404 17:54:57 Aborting 040404 17:54:57 InnoDB: Starting shutdown... 040404 17:54:59 InnoDB: Shutdown completed 040404 17:54:59 /usr/sbin/mysqld-max: Shutdown Complete 040404 17:54:59 mysqld ended
This is because you ran the mysql script manually as root first. This screws up ownership and permissions. If you don't have any data there, the simplest is to start over completely with "rm -rf /var/lib/mysql/mysql" and let it get regenerated with "rcmysql start" Otherwise, do "chown -R mysql.daemon /var/lib/mysql" and "mysql_install_db --user=mysql"