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