Hi PJ,
To be quite honest you may have better luck downloading and installing
MySQL yourself. It's very rare I install anything from the ports on
FreeBSD or apt repositories on Debian, simply because you have little
(if any) control over what goes on. At least if you do it yourself you
know how you're setting the system up. That's just from personal
experience.
Download the FreeBSD binary from
http://dev.mysql.com/downloads/mysql/5.1.html, and extract it somewhere
on your system (e.g. /tmp.)
Follow the instructions in
http://dev.mysql.com/doc/refman/5.1/en/installing-binary.html which
explains in full detail what to do and why you're doing what you're doing.
Just in case you're wondering, your problems with 5.1.30 appear to be
that the data directory it's trying to use (/var/db/mysql) is from a
pre-5.1 server (and you need to run mysql_upgrade to correct it, but
this requires an up-and-running system in the first place.)
Your second issue is that InnoDB does not have permissions to create
files in this directory. Check the owner/group MySQL is trying to run
as has access to /var/db/mysql.
Regards,
Andy
PJ wrote:
Or should I say 4-day-mare...
I have been trying to set up mysql for the last 4 days with weird
success.
I first installed mysql 6.0.8alpha not knowing I needed 5.0
compatibility for my ISP Website host.
I go everything working pretty well... mysql6, php5, phpMyAdmin, all
on FreeBSD 7.0 with apache2.2.9_5; all but the setup of the
pba_history table for phpmyadmin - just no way.
Anyway, I unistalled mysql6 and am now trying to install mySQL 5.1.30
from the FreeBSD ports collection.
I have tried about everything I can think of besides the arcane
documentation that is not at all accurate - for instance, there is no
mysq-test.pl or something like that that is referenced in the
database, but there is mysqltest in the .../bin directory. However,
running that results in errors.
When I do manage to set the root user password, it is not accepted...
I just cannot understand what kind of a mess this is.
The only thing I can provide is the error file: (biggie - is the name
of the server)
081218 17:40:17 mysqld_safe Starting mysqld daemon with databases from
/var/db/mysql
/usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm'
(errno: 13)
081218 17:40:17 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
081218 17:40:18 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
081218 17:40:18 mysqld_safe mysqld from pid file
/var/db/mysql/biggie.pid ended
081218 17:46:04 mysqld_safe Starting mysqld daemon with databases from
/var/db/mysql
/usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm'
(errno: 13)
081218 17:46:04 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
081218 17:46:04 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
081218 17:46:04 mysqld_safe mysqld from pid file
/var/db/mysql/biggie.pid ended
081218 17:54:09 mysqld_safe Starting mysqld daemon with databases from
/var/db/mysql
/usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm'
(errno: 13)
081218 17:54:09 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
081218 17:54:09 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
081218 17:54:09 mysqld_safe mysqld from pid file
/var/db/mysql/biggie.pid ended
Either I am totally incompetent and cannot decipher the instructions
or there is some kind of beatie running here...
Hope somebody can help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
