123
-=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- (c) WidthPadding Industries 1987 0|122|0 -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=-
Socoder -> Web Development -> Installing MySQL

Sun, 01 Apr 2007, 01:35
shroom_monk
Well, I'm trying to get local webhosting to work on my computer, so I can practice PHP and MySQL at home. I've got Apache 1.3.37 working with PHP 5 as a local host. Great! But when I come to install MySQL... tis not working!

I'm trying to install MySQL Essentials 5.0.37 for Win32 (MSI). I have a book (PHP and MySQL Visual QuickPro Guide by Larry Ullman) which explains all this at the back. I have followed the books instructions, which are the same as instructions I have found on the internet. From the error message I have been getting, and from what the book says, I think I know what the problem is: the MySQL server isn't starting. The reason (I think): the 'start MySQL as a Windows service' button is disabled, so I can't use it. I've tried and tried and tried, but nothing is worked. Does anyone here have experience with this (Jay/flying_cucco?) who could help? Thanks.

-=-=-
A mushroom a day keeps the doctor away...

Keep It Simple, Shroom!
Sun, 01 Apr 2007, 02:48
Phoenix
I have PHP/MySQL installed locallly on my computer. However, I just installed Developer Side.NET, and it did the work for me.
Sun, 01 Apr 2007, 02:59
shroom_monk
Thanks for that, Phoenix. If all else fails, I might use that. Does anyone else have any suggestions as to how to get the MySQL to work?

-=-=-
A mushroom a day keeps the doctor away...

Keep It Simple, Shroom!
Sun, 01 Apr 2007, 10:03
ingenium1
I installed MySQL... One year ago... But I didn't get any problem... I am sorry I can't help you.

EDIT: I think this post is quite unuseful... I am sorry Jay

-=-=-
Roger Federer is go(o)d.
But he is not alone.

Just relax... sometimes there's no need to argue.
Sun, 01 Apr 2007, 10:30
shroom_monk
Ingenium: Did you go through a stage in the installation/configuration process where you had the option of registering an account on the MySQL website, and/or a stage where you could set the root user password? Those are stages I should go through, but for some reason I don't. Thanks.

-=-=-
A mushroom a day keeps the doctor away...

Keep It Simple, Shroom!
Sun, 01 Apr 2007, 12:29
ingenium1
Mumble...
Me thinks I didn't set a password...
And about the registration... I don't remember I registered it... but probably I did it... Mmmm...

-=-=-
Roger Federer is go(o)d.
But he is not alone.

Just relax... sometimes there's no need to argue.
Sun, 01 Apr 2007, 12:51
shroom_monk
OK, well, thanks anyway ingenium.

@flying_cucco/Jayenkai: Don't you both have your own servers at home? Do you have anything to add? Thanks.

-=-=-
A mushroom a day keeps the doctor away...

Keep It Simple, Shroom!
Sun, 01 Apr 2007, 14:31
Evil Roy Ferguso
I think that XAMPP is probably the easiest way of setting up Apache+MySQL+PHP and its friends locally without any hassle - the simplest version just unzips. It's very useful as a development environment.
Sun, 01 Apr 2007, 14:44
ingenium1
Ah yeah! Now I remeber! I used Xampp!!!
www.apachefriends.org/en/xampp.html



-=-=-
Roger Federer is go(o)d.
But he is not alone.

Just relax... sometimes there's no need to argue.
Mon, 02 Apr 2007, 00:31
shroom_monk
Cool. Thanks for that!
Mon, 02 Apr 2007, 04:01
Yayyak
I got MySQL set up okay, I used the windows installer. It was PHPmyadmin that I had trouble with, I couldn't figure out the options for that.
Mon, 02 Apr 2007, 04:14
shroom_monk
@Yayyak: Which version of MySQL did you install, and did you get the option to set as a Windows service, and to set a root user password?

-=-=-
A mushroom a day keeps the doctor away...

Keep It Simple, Shroom!
Mon, 02 Apr 2007, 04:32
Yayyak
I got both those options, I set a root password, and I can't remember about the windows service. I've since moved my web testing to a UNIX box.
Mon, 02 Apr 2007, 04:35
shroom_monk
And which version was it? Oh, and what OS are you using? I just want to know so I can figure out if it's just the computer I'm using, or the version of MySQL I'm using. Thanks.

-=-=-
A mushroom a day keeps the doctor away...

Keep It Simple, Shroom!
Mon, 02 Apr 2007, 04:38
Yayyak
XP Home, MySQL 5.?.1.
I think. Hope it helps.
Mon, 02 Apr 2007, 04:38
Phoenix
Why not just use a LAMP instead of going through all the hassle of setting it up yourself?
Mon, 02 Apr 2007, 04:40
shroom_monk
@Yayyak: Thanks.
@Phoenix: At the moment, I'm considering my options. As I've already installed and got working PHP 5 and Apache 1.3.37, I want to see if I can get MySQL working. If all else fails, I'll uninstall everything and download one of the many software bundles that people have recommended.

-=-=-
A mushroom a day keeps the doctor away...

Keep It Simple, Shroom!
Mon, 02 Apr 2007, 04:41
Yayyak
5.0.24a-win32. There we go.

LAMP is just a description of a setup. It doesn't describe how it's installed. Package installers are what you're after.

Ironically, there USED to be a really good topic about this back on the old Devcrunch forums. Lol.
Mon, 02 Apr 2007, 04:43
shroom_monk
I'm using 5.0.37. I'll give 5.0.24 a go later. Thanks.

|edit| Hmm... version 5.0.24 of MySQL seems to be no longer available... Well, looks like it'll be XAMPP for me! |edit|

-=-=-
A mushroom a day keeps the doctor away...

Keep It Simple, Shroom!