 | | | Install problems with MySQL version 5.0.4 | Install problems with MySQL version 5.0.4 2005-05-12 - By Ken Resander
Back
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?
Earn $52 per hosting referral at Lunarpages.
|
|
|