List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:May 10 2009 12:58pm
Subject:RE: Still going in cicrles
View as plain text  
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: compukat@stripped
> To: mysql@stripped
> 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" <sjmudd@stripped>
> To: <mysql@stripped>
> Sent: Sunday, May 10, 2009 8:03 AM
> Subject: Re: Still going in cicrles
> 
> 
> > compukat@stripped (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=1
> > 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 

_________________________________________________________________
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
Thread
Still going in cicrlesmichel9 May
  • Re: Still going in cicrlesSimon J Mudd10 May
  • Re: Still going in cicrlesmichel10 May
    • Re: Still going in cicrlesSimon J Mudd10 May
      • RE: Still going in cicrlesMartin Gainty10 May
  • Re: Still going in cicrlesmichel10 May
    • RE: Still going in cicrlesMartin Gainty10 May