From: Martin Gainty
Date: May 10 2009 12:58pm
Subject: RE: Still going in cicrles
List-Archive: http://lists.mysql.com/mysql/217479
Message-Id: <BLU142-W35212D82B6CA276D76877BAE620@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_a2076ef7-37af-452b-853d-2156bcce3868_"

--_a2076ef7-37af-452b-853d-2156bcce3868_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


starting MYSQL
%MYSQL_HOME%\bin>mysqld --log-output=3DFILE --log-error=3DMySQL.log=20
--result-file=3Dresults.log

--perform some minor operation
mysql -u username -p root DBNAME
mysql>show databases=3B
mysql>use database=3B
mysql>show tables=3B

please display the results of these operations of %MYSQL_HOME%\data\MySQL.l=
og=20

Martin=20
______________________________________________=20
Note de d=E9ni et de confidentialit=E9

Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes=
 pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat=
isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e=
 ou la copie de ceci est interdite. Ce message sert =E0 l'information seule=
ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d=
onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation=
=2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni=
.




> From: compukat@stripped
> To: mysql@stripped
> Subject: Re: Still going in cicrles
> Date: Sun=2C 10 May 2009 08:13:48 -0400
>=20
> Simon=2C I am totally new to MySQL and followed some instructions from th=
e=20
> internet. Here is the install script I put together that seems to work.
>=20
>=20
> cd /home/qsys
> gzip -cd /home/qsys/mysql-5.1.32.tar.gz | tar xf -
>=20
> mv /home/qsys/mysql-5.1.32 /home/qsys/mysql-5.1.32.source
>=20
> cd /home/qsys/mysql-5.1.32.source
>=20
> ./configure --help --verbose
>=20
> ./configure --prefix=3D/home/qsys/mysql-5.1.32 --with-unix-socket-path=3D=
/home/qsys/mysql-5.1.32/mysql.sock=20
>  --with-tcp-port=3D3305
>=20
> make
>=20
> make install
>=20
> cd /home/qsys/mysql-5.1.32
>=20
> mkdir /home/qsys/mysql-5.1.32/var         # create the directory to gener=
ate=20
> test file alpha.lower.test
>=20
> /home/qsys/mysql-5.1.32/bin/mysql_install_db
>=20
> /home/qsys/mysql-5.1.32/libexec/mysqld --general-log=3DEnable \
>=20
>       --log-output=3DFILE \
>=20
>       --general_log=3D/home/qsys/MySQL.log \
>=20
>       --log-error=3D/home/qsys/MySQL.log \
>=20
>       --bind-address=3D91.203.57.197
>=20
>=20
>=20
>=20
>=20
>=20
> ----- Original Message -----=20
> From: "Simon J Mudd" <sjmudd@stripped>
> To: <mysql@stripped>
> Sent: Sunday=2C May 10=2C 2009 8:03 AM
> Subject: Re: Still going in cicrles
>=20
>=20
> > 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=20
> >> 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 messag=
es.
> >
> > Indeed=2C I'll create a bug report for this.
> >
> > http://bugs.mysql.com/44765
> >
> > Simon
> >
> >
> > --=20
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:=20
> > http://lists.mysql.com/mysql?unsub=3Dcompukat@stripped
> >=20
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped=
om
>=20

_________________________________________________________________
Hotmail=AE has a new way to see what's up with your friends.
http://windowslive.com/Tutorial/Hotmail/WhatsNew?ocid=3DTXT_TAGLM_WL_HM_Tut=
orial_WhatsNew1_052009=

--_a2076ef7-37af-452b-853d-2156bcce3868_--