I start setting up my new machine - Sony VAIO and this time it didn't go well the first time.
Keep reading...
I downloaded the latest php (PHP 5.2.9-1 (cli) (built: MarĀ 5 2009 20:02:28),
mysql (mysql-5.1.32-winx64.msi) and phpmyadmin (phpMyAdmin-3.1.3-english.tar.bz2).
Round #1
When I first logged in I saw a warning at the bottom of the first screen of phpmyadmin
Your PHP MySQL library version 5.0.50a differs from your MySQL server version 5.1.32.
This may cause unpredictable behavior.
Because I was already using the latest php I decided to downgrade MySQL to 5.0.51a
Round #2
http://downloads.mysql.com/archives.php?p=mysql-5.0&v=5.0.51a
Round #2.5
For some strange coinsidence (or maybe because it's Friday 13th :D) the configuration
wizard wouldn't start.
The error was caused by a bad configuration setting in MySQLInstanceConfig.exe.
By the way I have disabled UAC because of the constant prompting is quite
annoying but I still like Windows ;) (This was for my friends who like Mac).
MySQLInstanceConfig.exe Error in manifest or policy file on line 6.
The value "asAdministrator" of attribute "level" in requestedPrivileges" is invalid.
Here is how to fix it by editing the file resource using Resource Hacker program (free).
http://bugs.mysql.com/bug.php?id=34340
I am not done yet :D
Round #3
Now the latest phpMyAdmin produced an error:
SHOW PLUGINS
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PLUGINS' at line 1
Open new phpMyAdmin windowOpen new phpMyAdmin window
It seems this is a caching problem (see http://www.wampserver.com/phorum/read.php?2,46184,46227 )
Restart your browser and try again.
Happy Web Development ;)
Related:
- http://downloads.mysql.com/archives.php?p=mysql-5.0
- http://downloads.mysql.com/archives.php?p=mysql-5.0&v=5.0.51a
- http://friendsofed.infopop.net/4/OpenTopic?a=tpc&s=989094322&f=5283032876&m=9081093451http://noteslog.com/post/your-php-mysql-library-version/
- http://bugs.mysql.com/bug.php?id=34340
- http://www.angusj.com/resourcehacker/
- http://www.wampserver.com/phorum/read.php?2,46184,46227