Re: [parisc-linux] MySQL

[Andrew Shugg <andrew@neep.com.au>]

Quoth Tilo Jandt:
> 020218 11:57:49  mysqld started
> Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
> If you do not want to use transactional InnoDB tables, add a line
> skip-innodb
> to the [mysqld] section of init parameters in your my.cnf
> or my.ini. If you want to use InnoDB tables, add for example,
> innodb_data_file_path = ibdata1:30M
> But to get good performance you should adjust for your hardware
> the InnoDB startup options listed in section 2 at
> http://www.innodb.com/ibman.html
> 020218 11:57:51  /usr/sbin/mysqld: Can't find file: './mysql/host.frm' 
> (errno: 13)
> 020218 11:57:51  mysqld ended

The innodb warning you can easily fix by adding the 'skip-innodb' line
as the text there suggests.

> Preparing db table
> Preparing host table
> Preparing user table
> Preparing func table
> Preparing tables_priv table
> Preparing columns_priv table
> Installing all prepared tables
> 020218 11:57:41  /usr/sbin/mysqld: Shutdown Complete
> 
> 
> PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
> This is done with:
> /usr/bin/mysqladmin -u root -p password 'new-password'
> /usr/bin/mysqladmin -u root -h beta -p password 'new-password'
> See the manual for more instructions.
> 
> 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
> 
> ERROR: 1017  Can't find file: './mysql/user.frm' (errno: 13)
> 020218 11:57:42  /usr/sbin/mysqld: Shutdown Complete
> 
> ERROR: 1017  Can't find file: './mysql/db.frm' (errno: 13)
> ERROR: 1017  Can't find file: './mysql/db.frm' (errno: 13)
> 020218 11:57:44  /usr/sbin/mysqld: Shutdown Complete
> 
> But these files (db.frm and user.frm) exists in /var/lib/mysql.
> 
> Does anyone have an idea how to get mysql work?

This probably isn't a linux-hppa problem.  Check:

  - does /etc/mysql/my.cnf have the line "datadir = /var/lib/mysql"?
  - are /var/lib/mysql and /var/lib/mysql/mysql owned by "mysql.mysql"?
  - are the files in /var/lib/mysql/mysql mode 0660?  (-rw-rw----)

If your mysqld is telling us the truth, then it's just having trouble
getting to the files, either because it doesn't know where they are, it
doesn't have permission to read them, or because on of the directories
higher up the tree (eg /var/lib or /var/lib/mysql) is not accessable
for the mysql user (+x).

Try this if you have sudo installed:

beta# sudo -u mysql ls -laR /var/lib/mysql

If the output all looks kosher then it's not an access and permissions
problem, and you'll have to think of something else ...

Andrew.

-- 
Andrew Shugg <andrew@neep.com.au>                   http://www.neep.com.au/

"Just remember, Mr Fawlty, there's always someone worse off than yourself."
"Is there?  Well I'd like to meet him.  I could do with a good laugh."