starting MYSQL %MYSQL_HOME%\bin>mysqld --log-output=FILE --log-error=MySQL.log --result-file=results.log
--perform some minor operation mysql -u username -p root DBNAME mysql>show databases; mysql>use database; mysql>show tables; please display the results of these operations of %MYSQL_HOME%\data\MySQL.log Martin ______________________________________________ Note de déni et de confidentialité Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: compu...@videotron.ca > To: mysql@lists.mysql.com > Subject: Re: Still going in cicrles > Date: Sun, 10 May 2009 08:13:48 -0400 > > 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=mgai...@hotmail.com > _________________________________________________________________ Hotmail® has a new way to see what's up with your friends. http://windowslive.com/Tutorial/Hotmail/WhatsNew?ocid=TXT_TAGLM_WL_HM_Tutorial_WhatsNew1_052009
