MySQL won't start!

dezza · 12-30-2004, 03:58 PM

I can't get MySQL to work, i've installed the package trough swaret.

After i installed mysql i copied /etc/my-small.cnf to my.cnf, i made /var/lib/mysql and /var/run/mysql chown mysql.mysql ..

Quote:

041230 22:09:59 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
041230 22:10:00 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
041230 22:10:01 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
041230 22:10:01 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
041230 22:10:03 InnoDB: Started
041230 22:10:03 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
041230 22:10:03 Aborting

041230 22:10:03 InnoDB: Starting shutdown...
041230 22:10:05 InnoDB: Shutdown completed
041230 22:10:05 /usr/libexec/mysqld: Shutdown Complete

041230 22:10:05 mysqld ended

I have a mysql user that looks like this:

Quote:

mysql:x:1001:102:,,,:/dev/null:/bin/false

and he is a member of his own group
mysql

The startup script in Slackware (/etc/rc.d/rc.mysqld) is like:
http://www.pastebin.com/134961

Don't mind the <php? thing, it's automatic added from pastebin, ignore it!

Also tried:

Quote:

mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid --user=mysql

the same as if i ran mysqld_safe ..

Quote:

Starting mysqld daemon with databases from /var/lib/mysql
041230 22:57:41 mysqld ended

trickykid · 12-30-2004, 05:18 PM

Your log files might tell you more on what is occuring with better details. If your using Slackware though, a common problem is those who forget to install the initial databases and or a permission problem.

Have you run mysql_install_db and then make sure /var/lib/mysql is owned by the mysql user?

dezza · 12-30-2004, 05:48 PM

Quote:

Originally posted by trickykid
Your log files might tell you more on what is occuring with better details. If your using Slackware though, a common problem is those who forget to install the initial databases and or a permission problem.

Have you run mysql_install_db and then make sure /var/lib/mysql is owned by the mysql user?

Yes i've done both ..

Which logs?

alitrix · 12-31-2004, 02:54 AM

As I see in the logs, this is really issue of a not runned mysql_install_db

Cause he can't find any database

Can you run mysql_install_db again and show us the output?

dezza · 12-31-2004, 08:13 AM

I runned mysql_install_db --user=mysql as root ..

Quote:

Installing all prepared tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h nosferatu password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

Nothing special ..

alitrix · 01-01-2005, 07:21 AM

Another solution is, if you don't have any database or any information in the database then just remove /var/lib/mysql and do mysql_install_db again and show us the output again

(And `ls -al /var/lib/mysql)