• 0

WAMP Localhost Server - MYSQL Upgrade Help


Question

Hi I have been using WAMP for quite a long time now and have not had issues. I know there is the saying don't fix something if it is not broken, but I wanna upgrade my MYSQL version and I am having trouble!

I have followed the instructions from numerous websites (which ended up being the same instructions) and I have no luck. Either my program hangs or I can not connect to the MYSQL (such as: #2003 - Can't connect to MySQL server on 'localhost' (10061)).

Instructions that I found:

Step One:

Download the latest version of MySQL first...

Copy the new folder of mysqlx.x to wamp\bin\mysql\

Check if the folder of mysql and all database files exist in mysqlx.x\data folder.

If the mysql folder doesn't exist, copy it from a working previous version of mysql.

Check if mysqlx.x\bin folder and all executable files in it exist.

Check if the folder mysqlx.x\share exist.

If they don't exist, then the extraction of the latest version of mysql isn't done properly.

Check if mysqlx.x\my.ini file exist.

If it doesn't exist, copy the file from the previous wokring version of wamp mysql in wamp\bin\mysql\mysqlx.x

Open the file from the latest mysql version, edit all occurrences of "mysqlx.x" in that file to the "mysqlx.x" as the latest version number.

For example, if you see the line "basedir=c:/wamp/bin/mysql/mysql4.1" in my.ini file, then edit it to "basedir=c:/wamp/bin/mysql/mysqlx.x" as mysqlx.x is the lastest version you've just downloaded.

Normally there are only two occurrences you need to edit:

basedir=c:/wamp/bin/mysql/mysqlx.x and datadir=c:'wamp/bin/mysql/mysqlx.x/data

Step Two:

Copy the wampserver.conf file in the previous version of wamp mysqlx.x folder to wamp\bin\mysql\mysqlx.x.

You would need to open it with notepad and edit the line: $mysqlConf['mysqlExeFile'] = 'mysqld-nt.exe';

to $mysqlConf['mysqlExeFile'] = 'mysqld.exe';

Look at the mysqlx.x\bin directory and find out if there is a mysqld.exe or mysql-nt.exe file.

If there is no mysql-nt.exe file, then change that line as mentioned.

Step Three:

Shutdown the wamp2 server (by right click on wamp tray icon and click exit). Then restart the wamp server. Restart all services.

You should see the mysql newest version displayed in wamp mysql menu. Just click on the latest version to enable it, then you have the newest mysql version running with wamp server.

Followed all those with no issue and when I select the new MYSQL version, it just hangs or says cant connect when I go to phpmyadmin or anything located in my www folder if it uses MYSQL..

5.1.32 is my current version which works and I am trying to get 5.5.13 to work..

Any assistance would be grateful!

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.