Simon, I am totally new to MySQL and followed some instructions from the
internet. Here is the install script I put together that seems to work.
cd /home/qsys
gzip -cd /home/qsys/mysql-5.1.32.tar.gz | tar xf -
mv /home/qsys/mysql-5.1.32 /home/qsys/mysql-5.1.32.source
cd /home/qsys/mysql-5.1.32.source
./configure --help --verbose
./configure --prefix=/home/qsys/mysql-5.1.32 --with-unix-socket-path=/home/qsys/mysql-5.1.32/mysql.sock
--with-tcp-port=3305
make
make install
cd /home/qsys/mysql-5.1.32
mkdir /home/qsys/mysql-5.1.32/var # create the directory to generate
test file alpha.lower.test
/home/qsys/mysql-5.1.32/bin/mysql_install_db
/home/qsys/mysql-5.1.32/libexec/mysqld --general-log=Enable \
--log-output=FILE \
--general_log=/home/qsys/MySQL.log \
--log-error=/home/qsys/MySQL.log \
--bind-address=91.203.57.197
----- Original Message -----
From: "Simon J Mudd" <sjm...@pobox.com>
To: <mysql@lists.mysql.com>
Sent: Sunday, May 10, 2009 8:03 AM
Subject: Re: Still going in cicrles
compu...@videotron.ca (michel) writes:
I might have it fixed! I tried /home/qsys/mysql-5.1.32/libexec/mysqld
and I would get
/home/qsys/mysql-5.1.32/libexec/mysqld: Table 'mysql.plugin' doesn't
exist
090510 0:19:54 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
090510 0:19:54 [ERROR] Fatal error: Can't open and lock privilege
tables: Table 'mysql.host' doesn't exist
So you had built the binaries by didn't have an initial mysql database
created?
From reading around I tried running
/home/qsys/mysql-5.1.32/bin/mysql_install_db
/home/qsys/mysql-5.1.32/libexec/mysqld
and now I get
090510 0:32:38 [Note] Event Scheduler: Loaded 0 events
090510 0:32:38 [Note] /home/qsys/mysql-5.1.32/libexec/mysqld: ready
for connections.
Version: '5.1.32' socket: '/home/qsys/mysql-5.1.32/mysql.sock' port:
3305 Source distribution
This looks correct.
I would suggest that the developers team might change the error messages.
Indeed, I'll create a bug report for this.
http://bugs.mysql.com/44765
Simon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=compu...@videotron.ca
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org