On Sunday 04 April 2004 18:29, Anders Johansson wrote:
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"
I uninstaled MySQL using YasT, deleted the /var/lib/mysql directory and then re-installed using YasT. I then ran /etc/init.d/mysql start from a console under my account but this does not seem to work either ... frederic@SusiX:~> /etc/init.d/mysql start Creating MySQL privilege database and starting MySQL... mkdir: cannot create directory `/var/lib/mysql/mysql': Permission denied chmod: failed to get attributes of `/var/lib/mysql/mysql': No such file or directory mkdir: cannot create directory `/var/lib/mysql/test': Permission denied chmod: failed to get attributes of `/var/lib/mysql/test': No such file or directory Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1049 Unknown database 'mysql' 040404 20:38:34 Aborting 040404 20:38:34 /usr/sbin/mysqld: Shutdown Complete Installation of grant tables failed! Examine the logs in /var/lib/mysql for more information. You can also try to start the mysqld daemon with: /usr/sbin/mysqld --skip-grant & You can use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/bin/mysqlbug script! chmod: changing permissions of `/var/lib/mysql': Operation not permitted failed
Otherwise, do "chown -R mysql.daemon /var/lib/mysql" and "mysql_install_db --user=mysql"
tried that as well ... SusiX:/var/lib # ls -l total 7 ... drwxr-xr-x 2 mysql daemon 48 2003-10-02 22:20 mysql ... frederic@SusiX:~> mysql_install_db --user=mysql mkdir: cannot create directory `/var/lib/mysql/mysql': Permission denied chmod: failed to get attributes of `/var/lib/mysql/mysql': No such file or directory mkdir: cannot create directory `/var/lib/mysql/test': Permission denied chmod: failed to get attributes of `/var/lib/mysql/test': No such file o r directory Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1049 Unknown database 'mysql' 040404 21:04:05 Aborting 040404 21:04:05 /usr/sbin/mysqld: Shutdown Complete Installation of grant tables failed! Examine the logs in /var/lib/mysql for more information. You can also try to start the mysqld daemon with: /usr/sbin/mysqld --skip-grant & You can use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install _db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/bin/mysqlbug script! I further tried as suggested by the last output : frederic@SusiX:~> /usr/sbin/mysqld --skip-grant & [1] 4754 frederic@SusiX:~> 040404 21:10:30 Can't start server : Bind on unix socket: Permission denied 040404 21:10:30 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 040404 21:10:30 Aborting 040404 21:10:30 /usr/sbin/mysqld: Shutdown Complete [1]+ Exit 1 /usr/sbin/mysqld --skip-grant However : frederic@SusiX:~> ps -A | grep mysql frederic@SusiX:~> something else maybe ? Kind regards, Frederic