when installing slackware 10.1 i installed mysql off the cd. however now i can not find a large number of the mysql files (safe_mysqld or mysqld_safe). I have a mysql group and user but no mysql files. I then attempted to follow the mysql instructions from this thread

http://www.linuxquestions.org/questi...icle&artid=456

it works correctly until i attempt the command

/etc/rc.d/rc.mysqld start

when i run that command from the mysql user i get the following

#Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysql/mysql.pid
050430 02:47:36 mysqld ended

the following files are in /var/lib/mysql

ib_logfile0 ibdata1 mail-bin.000002 mail.err
ib_logfile1 mail-bin.000001 mail-bin.index

any suggestions on how to get mysql running? Any log files that my help find the solution? I checked /var/log/messages and syslog but no entries.

Who owns that directory and files? It must by mysql..
Do a and to find out this..
If root owns them instead of mysql user use this command:

This link will also help you

http://www.unixfool.com/mysql-slack.shtml

This too, a good tutorial on how to get all of AMP working

http://www.linuxquestions.org/questi...ighlight=mysql

Permissions look okay /var/lib

/var/lib# ls -l
total 32
drwxr-xr-x 2 root root 4096 2004-09-18 21:54 arpd/
drwxr-xr-x 2 root root 4096 2005-04-26 04:40 logrotate/
drwxr-x--- 2 mysql mysql 4096 2005-04-30 02:50 mysql/
drwxr-xr-x 2 root root 4096 2004-10-28 01:30 pcmcia/
drwxr-xr-x 2 root root 4096 2005-04-26 00:06 rpm/
drwxr-x--- 2 root slocate 4096 2005-04-30 04:41 slocate/
drwxr-xr-x 2 root root 4096 2005-01-23 23:45 xdm/
drwxr-xr-x 2 root root 4096 2005-01-23 23:45 xkb/


/var/lib/mysql# ls -l
total 20540
-rw-rw---- 1 mysql mysql 5242880 2005-04-30 02:50 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 2005-04-30 02:37 ib_logfile1
-rw-rw---- 1 mysql mysql 10485760 2005-04-30 02:50 ibdata1
-rw-rw---- 1 mysql mysql 79 2005-04-30 02:37 mail-bin.000001
-rw-rw---- 1 mysql mysql 79 2005-04-30 02:47 mail-bin.000002
-rw-rw---- 1 mysql mysql 79 2005-04-30 02:50 mail-bin.000003
-rw-rw---- 1 mysql mysql 54 2005-04-30 02:50 mail-bin.index
-rw-rw---- 1 mysql mysql 3018 2005-04-30 02:50 mail.err


this is the tutorial i followed origninally.

I had mysql install from the installation cd and never could get it start, so i followed the above tutorial and still not works.

Thanks for the replies, any other suggestions?

Did you check the mysql log for error?

Its located in /var/lib/mysql/
something.err

i have a file called mail.err that contains the following

050430 02:50:05 mysqld started
050430 2:50:05 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050430 2:50:05 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43676.
InnoDB: Doing recovery: scanned up to log sequence number 0 43708
InnoDB: Last MySQL binlog file position 0 79, file name ./mail-bin.000002
050430 2:50:05 InnoDB: Flushing modified pages from the buffer pool...
050430 2:50:05 InnoDB: Started; log sequence number 0 43708
050430 2:50:06 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
050430 02:50:06 mysqld ended


this looks to be the problem

050430 2:50:06 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

suggestions on how to create that table? Thanks again.

This problem is usually solved when you reinstall the database. delete your old one by deleteing the 'mysql' folder in /var/lib/mysql/
then recreate it
And make sure the user mysql owns everything

Thanks, that seemed to resolve the issue. I know see mysql processes running and was able to set a password. I will now continue forward and hopefully all will go well. Thanks again for the help.

This can i also be done like this:
Under root:

su mysql
mysql_install_db

Both will do the same trick