Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL on windows XP

Status
Not open for further replies.

audiopro

Programmer
Apr 1, 2004
3,165
GB
I am trying to find a version of MySQL which works on Windows XP.
I set the same system up on another computer over 5 years ago and it took 5 minutes.
I have been looking at a Windows installer but it involves downloading a file of over 200meg - what on earth is it downloading.
I do not want it to run under .NET!

Where do I download MySQL without bells, whistles flutes and garbage?

It is to work with an Apache server running Active Perl.

Keith
 
The real question is where are you downloading it from, all the msi downloaders on MYSQL.com's website are around the 30mb mark.

Unless you have a 64bit computer I'd say you want to get the second.

Alternatively download a WAMP package instead it includes a bare bones MYSQL DB within as well as PHP and Apache.

----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech
 
Thanks Phil
I have downloaded one of the wamp files from and wrestled with their tray icon menus.
I think I have downloaded some support files as well but as is the norm in the modern world, why give concise information when you can have some pretty graphics to hide useful stuff behind.

Have I missed the set up instructions?

Keith
 
There's not much to setting it up, Simply runt he Wamp setup file and it will take care of everything.

Once everything is installed you can start to use the database.

There is no cutesy graphic interface for you to use so you can either use the regular command line (DOS prompt) console or try to get a GUI for mysql as there are many around.

But the DB should be up and running once WAMP is installed.

Not sure what else you need.




----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech
 
I need to run Perl too and it appears that it is not supported on this wamp program.

Setting up Aache, Perl and MySQL - I managed to get Apache and Perl to run but the MySQL just wouldnt connect from within Perl, even though I could run PHPMyAdmin via the password.

Keith
 
After reading up on it I have downloaded Active Perl and edited the .conf file to reflect the location of the cgi-bin.
The only thing working is the server loads the index page in localhost.


Keith
 
What errors did you get if any?
Is that Perl is not connecting to the DB?
I'm ot all that versed in Perl, but I'm sure it has some error handling functions that can tell you what's wrong with the connection.

Perhaps asking in forum219 may offer more options.



----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech
 
Thanks for your guidance on this one.
I had the same issue when I was trying to set up all the files individually too. I have made simple test files for both Perl and PHP and neither is connecting.

I am sure it is something dumb that I am doing.
I can find reference to the database password in the .ini file but I am guessing at the hostname being 'localhost' and the username being 'root'.

I have all this set up on another computer in the office, is it possible to copy the setup from one computer to another or am I looking back to the days of DOS with Affection?

Keith
 
The users and passwords are defined in the actual connection call. for php:

$conn=mysql_connect('server', 'user','password');

As I said error checking should be used if only to know what is going wrong.
For PHP:
Code:
$conn=mysql_connect('server', 'user','password') or die(mysql_error());

See if that produces anything useful.







----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech
 
Once you installed MySQL on Windows, do not forget to set:
Code:
lower_case_table_names=2
In my.ini. This way, MySQL does not cripple the table names to lower case, but acts in a case-insensitive manner.


+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top