LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Mysql ended (https://www.linuxquestions.org/questions/linux-software-2/mysql-ended-108313/)

BlackRabbit 10-25-2003 08:05 AM

Mysql ended
 
Just did a fresh install of SlackWare 9.1.
After install, I did this:

mysql_install_db
mysqld_safe

=>

Quote:

Starting mysqld daemon with databases from /var/lib/mysql
031024 11:33:40 mysqld ended
Jupiter.err:
Quote:

031024 11:23:35 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
031024 11:23:35 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
031024 11:23:36 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...
031024 11:23:36 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
031024 11:23:38 InnoDB: Started
031024 11:23:38 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
031024 11:23:38 Aborting

031024 11:23:38 InnoDB: Starting shutdown...
031024 11:23:40 InnoDB: Shutdown completed
031024 11:23:40 /usr/libexec/mysqld: Shutdown Complete
So mysqld can't open host.frm.. How come?
Just for testing I chmodded those files in /var/lib/mysql/mysql to 777, but I still get the same error..

What's wrong?

trickykid 10-25-2003 09:02 AM

Before doing a mysqld_safe do this:

chown -R mysql.mysql /var/lib/mysql

BlackRabbit 10-25-2003 09:35 AM

Quote:

Originally posted by trickykid
Before doing a mysqld_safe do this:

chown -R mysql.mysql /var/lib/mysql

Thanks, it did the trick!


All times are GMT -5. The time now is 10:21 AM.