LinuxQuestions.org - Slack 10: 2 questions.

- Slackware (https://www.linuxquestions.org/questions/slackware-14/)

- - Slack 10: 2 questions. (https://www.linuxquestions.org/questions/slackware-14/slack-10-2-questions-198850/)

Slack 10: 2 questions.

I have two fresh Slack 10 CDs. (Burnt), installed it... All went well, except some non-important packages in the GNOME directory. But I don't care about that, since I use KDE. Anyway, exactly how to you upgrade to the 2.6.7 kernel? And MySQL doesn't work. And just so you know, it all booted fine.

To upgrade to kernel 2.6.7 there are some threads round here (take a look at stickys too). MySQL needs to be configured before you can use it, take a look at the files my-huge.cnf, my-small.cnf,etc on your /etc directory.
Hope that helps.

Yes, yes it did! Thank you! :)

I have 256MB RAM so I have to edit my-medium.cnf right? What exactly should I edit?

And the error is:

root@kyl3whatoneone:/etc/rc.d# Starting mysqld daemon with databases from /var/lib/mysql
040629 09:24:26 mysqld ended

Try this (as root)

Code:

mysql_install_db

chown -R mysql:mysql /var/lib/mysql

chmod +x /etc/rc.d/rc.mysqld

I don't actually use MySQL for anything yet, but it starts up for me without any errors.

I don't have to. I ran that command before. And that directory is owned by the mysql user, AND it starts up fine at boot, but it ends when it asks for a login... I just gotta find out what error 040629 is.

Couple things to check. Make sure that the files in /var/lib/mysql are readable by the user mysql. I think you already did that, but I just wanted to make sure because you said that the files are owned by the mysql user but didn't mention if they were also owned by the mysql group.

The next thing is that you may be able to see what is going on by checking out the .err files in the /var/lib/mysql directory. Maybe something in there will give you a hint as to what is going on.

Yes, group and owner are mysql... What will the .err files tell me?

Edit: OMG! Look at the err files:

040629 09:13:21 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040629 9:13:22 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040629 9:13:22 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...
040629 9:13:22 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
040629 9:13:23 InnoDB: Started
040629 9:13:24 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
040629 9:13:24 Aborting

040629 9:13:24 InnoDB: Starting shutdown...
040629 9:13:26 InnoDB: Shutdown completed
040629 9:13:26 /usr/libexec/mysqld: Shutdown Complete

040629 09:13:26 mysqld ended

040629 09:24:23 mysqld started
040629 9:24:23 InnoDB: Started
040629 9:24:23 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
040629 9:24:23 Aborting

040629 9:24:23 InnoDB: Starting shutdown...
040629 9:24:26 InnoDB: Shutdown completed
040629 9:24:26 /usr/libexec/mysqld: Shutdown Complete

040629 09:24:26 mysqld ended

040629 09:32:10 mysqld started
040629 9:32:10 InnoDB: Started
040629 9:32:10 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
040629 9:32:10 Aborting

040629 9:32:10 InnoDB: Starting shutdown...
040629 9:32:13 InnoDB: Shutdown completed
040629 9:32:13 /usr/libexec/mysqld: Shutdown Complete

040629 09:32:13 mysqld ended

040629 09:45:29 mysqld started
040629 9:45:29 InnoDB: Started
040629 9:45:29 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040629 9:45:29 Aborting

040629 9:45:29 InnoDB: Starting shutdown...
040629 9:45:31 InnoDB: Shutdown completed
040629 9:45:31 /usr/libexec/mysqld: Shutdown Complete

040629 09:45:31 mysqld ended

040629 13:24:36 mysqld started
040629 13:24:37 InnoDB: Started
040629 13:24:37 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040629 13:24:37 Aborting

040629 13:24:38 InnoDB: Starting shutdown...
040629 13:24:40 InnoDB: Shutdown completed
040629 13:24:40 /usr/libexec/mysqld: Shutdown Complete

040629 13:24:40 mysqld ended

Are you sure you did mysql_install_db ? If in doubt, redo it.

Positive. Apache and PHP work fine tho.

the .err files are your error logs from mysql. They may give you a better idea about what is going on.

As a side note, 040629 is not an error number; it's the date. 06/29/2004.

Apache and PHP don't need MySQL to work. I'm thinking that keefaz is right. As root, run the commands I gave earlier again. Then restart mysql and see what the new messages are in the .err file.

Can you put the output of ls /var/lib/mysql ? There should be a mysql subdirectory showing that mysql_install_db was executed fine.

root@kyl3whatoneone:~# cd /var/lib/mysql;ls
ib_arch_log_0000000000 ib_logfile0 ib_logfile1 ibdata1 kyl3whatoneone.err mysql/ test/
root@kyl3whatoneone:/var/lib/mysql#

OMG! IT WORKS NOW!! *High fives Shilo and keefaz*

One more question: Anyone know any links on how to set up phpMyAdmin on your OWN server?