MySQL on Windows: Configuration & Install

re: MySQL on Windows: Configuration & Install

James — Mon, 06 Oct 2008 12:49:47 GMT

I followed the recommendations of disabling UAC in Windows Vista. MySQL service would still not start up after this. Did I miss something?

re: MySQL on Windows: Configuration & Install

Wayne — Sun, 05 Oct 2008 20:39:33 GMT

Thanks for those links!

Why are some people complaining about people wanting to set up a WAMP server on their home computer? For 90% of people wanting articles like this, it's for development / testing purposes. So please, stop with the Elitism because everybody already knows about how insecure Windows is.

Wayne

re: MySQL on Windows: Configuration & Install

Anupam — Wed, 18 Jun 2008 08:28:22 GMT

i could not find appropriate answer

that

how i configure ARCHIVAL in mysql......

how to sell a home fast

how to sell a home fast — Thu, 15 May 2008 23:27:42 GMT

in terms of making money ... it\'s down to one thing ... CONTENT but more importantly readable

re: MySQL on Windows: Configuration & Install

Brian — Fri, 04 Apr 2008 21:58:27 GMT

I don't like the solution this article proposes, because the first step is to disable UAC.

While hunting for a better solution, I found this excellent post at the MySQL forums:

forums.mysql.com/read.php

It requires modifying (*cough* hacking) the configurator exe, once installed, but MySQL community edition is open-source, anyway, right? IMHO, that's a much better solution than disabling UAC on a development machine that likely contains sensitive information to production machines, somewhere.

Personally, I'm tired of seeing "Step #1 Disable UAC" in guides. Disabling UAC is like handing out root for FTP access on *nix, and no one would imagine to do that.

UAC isn't evil. It's just different. If more developers would learn to work with it, maybe Win could finally shed it's "insecure" label.

re: MySQL on Windows: Configuration & Install

bob — Mon, 25 Feb 2008 15:30:58 GMT

Please can you help me? After installing Mysql, i try to open MySql server instance config wizard and i get this error after installing MySql on Vista. " This file does not have a program associated with it for perfoming this action. Create an association in the Set Association control panel"

OurSQL Episode 11: Catching Up

Technocation, Inc. — Wed, 12 Sep 2007 03:43:50 GMT

Configurazione e installazione di MySQL su Windows

Blog Team TechNet Italia — Tue, 24 Apr 2007 08:18:16 GMT

Voglio segnalarvi un interessante articolo su Port25 dedicato all'installazione e configurazione di MySQL

re: MySQL on Windows: Configuration & Install

einhverfr — Thu, 22 Mar 2007 00:44:20 GMT

Seattlegraucho:

The GPL and BSD have different business traps and issues. I personally release *most* of my code under the GPL simply because I don't want to subsidize the competition. This being said, I am *not* happy about certain developments in GPL v.3....

My issue with MySQL is specifically about the client libraries. In my view, client libraries should be licensed under LGPL (most cases) or BSD license (i.e. for reference implementations of a protocol). The specific intent is to ask people to purchase licenses if they want to build software on MySQL under commercial licenses. This to me would be no different if Microsoft wanted to charge you extra to build VB apps if you wanted to release them under the GPL.

However, this is also becoming a serious liability to MySQL. Oracle now owns both of the back-end storage engines (BDB and InnoDB) whch are transaction-capable. This does not affect GPL-users, but it does affect those who may want to purchase non-GPL licenses because these can only be issued in agreement now with Oracle. And there is a lot of fear that Oracle may not play nice... But if you don't need transactions, I suppose that is a non-issue.

In related news, I am glad to see the announcement about parts of FoxPro being slated for release on Codeplex. I think this represents a strong step forward for Microsoft and I am quite happy to see it happen. I, for one, hope that there is enough interest that the product will eventually go far. THere are a lot of older legacy apps that could use this sort of support.

Thank you, Microsoft :-)

Instalando MySQL no Windows

Good News and No News: Cezar Guimarães — Wed, 21 Mar 2007 18:35:20 GMT

Provavelmente você utiliza nas suas aplicações SQL Server ou a sua versão Express, muito boa por sinal.

@seattlegaucho

MichaelF — Tue, 20 Mar 2007 18:33:01 GMT

Good thought on the license compatibility discussion. I'll see if we can address this issue in a future Port 25 post.

re: MySQL on Windows: Configuration & Install

seattlegaucho — Tue, 20 Mar 2007 17:37:36 GMT

"Importance is in the eye of the beholder" kind of ...

In my experience when dealing with large corporations with knowleadgeable lawyers, they'd rather go with GPL than BSD. For details on both the FSF web site is a great source of information. These lawyers also like the fact that MySQL, by controling 100% of the code, can also provide commercial licenses to those customers that require them, mostly OEM. So "it's a feature" :)

Maybe in a future article your lab (I'm assuming you work at the OSS lab @ MSFT) can comment about the licensing compatibility issues. Besides DBs, I've noticed that the media players included in the last SuSE distributions include a Patents/Copyright/Int Prop warning. I guess as more interoperability and partnerships between different companies and projects take place, the more important this issue will become.

re: Seattlegraucho

einhverfr — Mon, 19 Mar 2007 23:04:00 GMT

You are, of course, right about the license being GPL. You will notice that nobody has questioned whether MySQL is "Open Source" but rather whether it is developed by an "open community." This may not be an important issue though.

My comments (and even Norbertos) had to do with the fact that MySQL is a single-vendor solution which uses client-library licensing to sell software licenses to non-GPL-compliant developers (I believe they now offer additional permissions to the developers of apps using other OSI-approvied licenses) while PostgreSQL is multi-vendor, and the client libraries are BSD-licensed. It is the question of single-party control over what you can do with the software more than about licenses. However, if you only use the GPL, it doesn't affect you :-)

Also, it is true that many applications simply need a light-weight data storage engine that can do agregates reasonably. MySQL fits that need quite well (and it is also a good database for light-weight content management). Applications which do need strong data integrity controls, etc. can use something like Firebird or PostgreSQL (both are well-supported on Windows now, btw). In short, MySQL is great for Joomla! but I would think twice before running a financial package on it.

re: MySQL on Windows: Configuration & Install

seattlegaucho — Mon, 19 Mar 2007 17:29:33 GMT

I have a few comments on the comments (sorry for the redundancy) to clarify without trying to start a flame war:

- MySQL is Open Source released under the GPL license, there is nothing closed about it. Now there is even a new program to allow for more contributions from the community: http://forge.mysql.com/contribute/

- Most downloads happen for the Windows platforms, although it looks like most implementations are done in *nix. This goes hand in hand w/ einhverfrf comments:

[quote]

It allows developers to install a database management solution on their desktops without having to dual boot.

It allows developers like me to test software more effectively to help programs reach larger audiences (which include Windows users).

It may introduce Windows users to the idea of running open source software on their platforms.

[/quote]

- I agree also with the 'lying' nature of generic benchmarks.

- Last but not least, 8 of the top 10 web sites measured in traffic use MySQL in one way or another to generate revenue. msn.com is not one of them ;)

- Most of the applications running on MySQL, don't need the additional features offered by other DBs, Open Source or not.

My $.02 to keep it fair and balanced,

One more use of this documnetation

einhverfr — Sun, 18 Mar 2007 04:37:36 GMT

Although Windows has a reputation of being insecure, the limiting aspect of most computer security is the admin. If someone is more familiar with Windows security than Linux security, they are better running a program like MySQL or PostgreSQL on Windows if security is that great a concern. And while I think that *nix has a better security/usability balance than Windows, an admin is usually the weak link.