logo-dw

Go Back   Dreamweaver Club Forums > Hand Coders Forum > General
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 03-10-2008, 08:22 AM   #1
student101
 
Join Date: Dec 2007
Posts: 379
Question Upgrading Wamp MySQL version?

I have tried almost all the steps that I could find to upgrade this wamp MySQL system,
Nothing works!

I have searched for 6 days, and they all say the same thing(s).
Everytime I add a different version, even these so called add-ons...
I still get the same error message:
Quote:
#2003 - Can't connect to MySQL server on 'localhost' (10061)
Tried all the firewall stuff, disabled NOD32 rebooted and still no luck!
Quote:
(even though I never had to touch NOD32 with the original install)
Is there a secret to this setup?
It makes no sense that MySQL and phpMyadmin can't work together after the upgrade of "mysql-noinstall-5.1.23-rc-win32"

The problem is that after copying the new MySQL I need to setup the MySQL password? or what?
So I open the config.inc file and remove the password currently set.
I also followed these steps: http://guides.jlbn.net/setpw/setpw1.html (too many times)

F1 how to properly upgrade the MySQL version?

Cheers
student101 is offline   Reply With Quote
Old 03-11-2008, 06:35 PM   #2
student101
 
Join Date: Dec 2007
Posts: 379
Default

Fixed



.
student101 is offline   Reply With Quote
Old 03-11-2008, 07:50 PM   #3
davidj
davidj's Avatar
 
Join Date: Sep 2005
Location: The Toon (newcastle upon Tyne)
Posts: 8,256
Default

how did you fix it
__________________
Would you like to learn PHP from me? Check out -> www.codezenith.co.uk
davidj is offline   Reply With Quote
Old 03-11-2008, 08:53 PM   #4
student101
 
Join Date: Dec 2007
Posts: 379
Thumbs up

You can follow my steps to install the latest version of mysql on Wamp2

STEP1: (x represents a number)
Quote:
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


STEP2
:
Quote:
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.


STEP3
:
Quote:
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.
Enjoy.
Cheers

Last edited by student101; 03-11-2008 at 09:14 PM..
student101 is offline   Reply With Quote
Old 03-12-2008, 06:35 AM   #5
davidj
davidj's Avatar
 
Join Date: Sep 2005
Location: The Toon (newcastle upon Tyne)
Posts: 8,256
Default

nice one

cheers mate
__________________
Would you like to learn PHP from me? Check out -> www.codezenith.co.uk
davidj is offline   Reply With Quote
Old 03-12-2008, 06:38 AM   #6
student101
 
Join Date: Dec 2007
Posts: 379
Default

Thanks.

Hope it works out for everyone.
Cheers
student101 is offline   Reply With Quote
Old 07-29-2010, 05:06 AM   #7
sandip.waghole
 
Join Date: Jul 2010
Posts: 1
Default Not Working

Yes that version option is available but it is not working...

Is there any other things that can be done
sandip.waghole is offline   Reply With Quote
Old 07-29-2010, 06:03 AM   #8
edbr
edbr's Avatar
 
Join Date: Aug 2005
Location: Bali
Posts: 11,164
Default

real question or are you a robot ?
__________________
If you're happy and you know it shake your meds!
different style links examples

Flight / Hotel search
Free script download
Bali Villas
edbr is online now   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:07 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com