Install problems with MySQL version 5.0.4

------=_NextPart_000_000E_01C556F6.1E477430
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Downloaded version 5.0.4. Zipped size was approx 39MB.
OS; Windows XP

1. Install problem:

The MySQL Server Instance Configuration Wizard 1.0.4 did not complete =
when launched by the installer. (It also does not complete when run via =
the icon in the 5.0.4 installation directory)

Used default settings and eventually arrived at prompt
'Please press [Execute] to start the configuration'

On selecting Execute
=20
Prepare configuration was OK

Write configuration file was OK

Start Service NOT OK=20
(before this I had stopped the existing server=20
running MySQL 5.0.0 via Services in Control Panel)

2. the version shown by the Command Line Client is
5.0.0-alpha-max debug
Executing select version() also gives same result.


3. When I tried accessing Information_schema tables, the=20
system reported that none of these tables exist.
(Information Schemas were introduced in 5.0.2)

4. when I tried CREATE TRIGGER mytrig AFTER INSERT BEGIN END;
the system reported that there is a syntax error near=20
'trigger' (triggers are introduced in 5.0.4)
when I tried CREATE PROCEDURE myproc() BEGIN END;
the system responds 'Query OK'
=20
5. the downloaded manual contains material about information
schemas and triggers and makes references to version 5.0.4=20
in several places.

It looks a bit like my old version 5.0.0 is still active.

What may be the cause?

------=_NextPart_000_000E_01C556F6.1E477430--

Re: Install problems with MySQL version 5.0.4

Hello Ken,
I had this problem too.
Wat I did:
1.stop the server by
mysqladmin -u root -p shutdown
OR
NET STOP MYSQL
(replace MYSQL with the exact servicename )
OR ctrl-alt-del --> task management-->search for service -->stop
2.remove the service by
mysqld.exe --remove MYSQL
(replace MYSQL with the exact servicename )
3.start your new mysqlserver with:
mysqld.exe --console
4.use Mysql Administrator to contact this running server
adapt de config-file setting (in my case this default setting was wrong) to
point to the right my.ini

5.stop the server with:
ctrl-alt-del --> task management-->search for service -->stop

6.relaunche the server now with
NET START MYSQL504
(replace MYSQL504 with your exact servicename)


At 07:25 12/05/2005, Ken Resander wrote:
>Downloaded version 5.0.4. Zipped size was approx 39MB.
>OS; Windows XP
>
>1. Install problem:
>
>The MySQL Server Instance Configuration Wizard 1.0.4 did not complete
>when launched by the installer. (It also does not complete when run via
>the icon in the 5.0.4 installation directory)
>
> Used default settings and eventually arrived at prompt
> 'Please press [Execute] to start the configuration'
>
> On selecting Execute
>
> Prepare configuration was OK
>
> Write configuration file was OK
>
> Start Service NOT OK
> (before this I had stopped the existing server
> running MySQL 5.0.0 via Services in Control Panel)
>
>2. the version shown by the Command Line Client is
> 5.0.0-alpha-max debug
> Executing select version() also gives same result.
>
>
>3. When I tried accessing Information_schema tables, the
> system reported that none of these tables exist.
> (Information Schemas were introduced in 5.0.2)
>
>4. when I tried CREATE TRIGGER mytrig AFTER INSERT BEGIN END;
> the system reported that there is a syntax error near
> 'trigger' (triggers are introduced in 5.0.4)
> when I tried CREATE PROCEDURE myproc() BEGIN END;
> the system responds 'Query OK'
>
>5. the downloaded manual contains material about information
> schemas and triggers and makes references to version 5.0.4
> in several places.
>
>It looks a bit like my old version 5.0.0 is still active.
>
>What may be the cause?

Bruno Vansimpsen
Stwg Op Papenbroek 33
3290 Diest
GSM 0498 415204
http://my.webhop.info
email: Mr. Bruno Vansimpsen


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org