is mysqlsb compatible with MySQL 5.0?

[John Salerno]

My web server told me it isn't, which is why they are sticking with
MySQL 4.0 for now, but I'm obsessed with using the latest versions, so I
just want to be sure. According to the mysqldb download page at
sourceforge, it is compatible with 5.0

Thanks.

 

[Ravi Teja]

Yes! It does.

Assuming that you are not terribly bandwidth constrained, isn't it
easier for you to try it
yourself on your own machine than wait for other people to assure you,
given that both are free and pretty much run on any platform?

 

[John Salerno]

Yes! It does.

Assuming that you are not terribly bandwidth constrained, isn't it
easier for you to try it
yourself on your own machine than wait for other people to assure you,
given that both are free and pretty much run on any platform?

Yeah, actually I went ahead and installed them both to try it out, but
Norton Internet Security is causing huge problems with the MySQL setup.
Even when I disable it, it won't let me get past the configuration steps.

 

[Ravi Teja]

Ah! An overzealous firewall! My sympathies . I am using the free
Kerio personal firewall on Windows.

 

[Dennis Lee Bieber]

My web server told me it isn't, which is why they are sticking with
MySQL 4.0 for now, but I'm obsessed with using the latest versions, so I
just want to be sure. According to the mysqldb download page at
sourceforge, it is compatible with 5.0

One question may be: which version of Python are they running; which
version of MySQLdb; etc.

Between 4.0 and 4.1, MySQL changed the internal password algorithm;
not all clients are compatible with the new password algorithm, and
setting up the user table with old-style passwords for some users may be
more than they wish to be involved with.

I'm still running a Python 2.3 mainly because I have it installed
under a Plone instance (I should check the Plone site for updates that
have been tested under 2.4 -- though it is worse than that; I installed
an ActiveState 2.3 over the Plone 2.3 <G>). The MySQLdb for Python 2.3
uses, as I recall, the MySQL 4.0 password scheme. The 2.4 version is 4.1
password.

{Oh, great... I've just managed to lock myself out of my installation --
even the "root" password is blocked; time to see if I can pull up a
backup of the mysql data}
--

 

[John Salerno]

Ah! An overzealous firewall! My sympathies . I am using the free
Kerio personal firewall on Windows.

Actually, I'm a little confused now. I turned off Norton completely (as
far as I can tell), restarted, and the configuration wizard of MySQL
still fails at the "Start service" step. I just don't get it.

As a result, I am currently in the market for a different (and free)
firewall program, so I will check out that one you mentioned.

 

[John Salerno]

One question may be: which version of Python are they running; which
version of MySQLdb; etc.

They just upgraded everything to the latest version (Python, mysqldb,
mod_python), but they said they are waiting to upgrade MySQL because of
the incompatibility.

 

[Dennis Lee Bieber]

Actually, I'm a little confused now. I turned off Norton completely (as
far as I can tell), restarted, and the configuration wizard of MySQL
still fails at the "Start service" step. I just don't get it.

WinXP? What error do you get from the wizard? (You are running in an
Admin privilege I presume). {I just had to recover mine the hard-way --
uninstall MySQL 4.1.15 or whatever, REMOVE the remnant mysql database
(but not my application databases), install 4.1.18 or
whatever-is-current, letting it recreate the mysql data with just
"root"... shutdown the service -- using the WinXP service manager; copy
the mysql database to my preferred data directory (and edit the my.ini
file to point to that data directory)... restart the service, and then
recreate the two other user accounts...}

As a result, I am currently in the market for a different (and free)
firewall program, so I will check out that one you mentioned.

I went for years with the free version of ZoneAlarm, though for my
current machine I did upgrade to a paid version...
--

 

[Dennis Lee Bieber]

They just upgraded everything to the latest version (Python, mysqldb,
mod_python), but they said they are waiting to upgrade MySQL because of
the incompatibility.

If they upgraded MySQLdb, but are still running 4.0 -- they may have
just created an incompatibility (or you are the only one using such, so
don't matter -- and they don't want to cause problems for other users
who have 4.0 level client libraries).

Given what I just went through, I should probably have jumped to
MySQL 5.0 -- I did download it.
--

 

[John Salerno]

WinXP? What error do you get from the wizard? (You are running in an
Admin privilege I presume).

Yes, WinXP and admin.

At first, when Norton was running, I got a 1045 error message saying to
allow TCP port 3306. I tried creating a rule to do this, but it didn't
seem to work.

Then I turned off Norton completely and it still stopped at the same
step, but this time said: "The service could not be stopped. Error: 0"

All I want to do is use MySQL so I can follow along with Baseball Hacks.

 

[Dennis Lee Bieber]

At first, when Norton was running, I got a 1045 error message saying to
allow TCP port 3306. I tried creating a rule to do this, but it didn't
seem to work.

I don't run Norton, so can't help with setting up rules...

Then I turned off Norton completely and it still stopped at the same
step, but this time said: "The service could not be stopped. Error: 0"

Check the Windows services control for MySQL and try from it...

You might (since it sounds like this is a first attempt) need to
uninstall everything -- and make sure you delete the mysql database (in
case you have a garbaged root login)
--

 

[John Salerno]

Check the Windows services control for MySQL and try from it...

How do I do that?

You might (since it sounds like this is a first attempt) need to
uninstall everything -- and make sure you delete the mysql database (in
case you have a garbaged root login)

Ugh, if this is the case, is there more to uninstall than just using the
Add/Remove programs? Where do I delete the database?

 

[Dennis Lee Bieber]

How do I do that?

Aye-yi-yi...

ControlPanel
Administrative Tools
Services

Scroll down and look for MySQL (or MySQL 4.1, or whatever it chose
to name the service -- I think the installer can handle multiple
instances in parallel, though I only run one)

Select it. You should have options to either "start" (if stopped) or
"stop", "pause", "restart" (if running).

Ugh, if this is the case, is there more to uninstall than just using the
Add/Remove programs? Where do I delete the database?

Add/Remove usually leaves the contents of databases behind. If you
haven't moved anything, they would be under <install-path>/data

You'd find a mysql directory, a test directory, and a set of InnoDB
files. The mysql directory contains the files that control user access
at various levels... Also ensure that the my.ini file (found in the
install path) is gone.

If you haven't yet, I'd recommend finding a good MySQL reference...
The older Black/Brown O'Reilly/MySQL AB book is good for most stuff up
to the 4.0 level (doesn't have the 5.0 features, and is missing just a
few 4.1 advanced features or the password algorithm change)
http://www.amazon.com/gp/product/05...ef=sr_1_44/002-3455136-4040849?_encoding=UTF8

It was replaced by the Blue/White MySQL AB books (plural -- they split
administration into a separate book from usage; you'd want both) --
include some discussion of 5.0 (along with a small chapter about MaxDB,
which is really the former enterprise-level SAP-DB)
http://www.amazon.com/gp/product/06...f=pd_bbs_9/002-3455136-4040849?_encoding=UTF8
http://www.amazon.com/gp/product/06...ef=sr_1_23/002-3455136-4040849?_encoding=UTF8
http://www.amazon.com/gp/product/06...f=pd_bbs_3/002-3455136-4040849?_encoding=UTF8

The SAMS (Developer's Library) Purple/White MySQL book (Red/White was
prior New Riders edition)
http://www.amazon.com/gp/product/06...f=pd_bbs_1/002-3455136-4040849?_encoding=UTF8

Or the Black Apress MySQL 5 Definitive Guide
http://www.amazon.com/gp/product/15...f=pd_bbs_2/002-3455136-4040849?_encoding=UTF8

The Apress is the newest book of the bunch (caution, the second
edition did not cover 5.0, 3rd edition has the 5 in the title)... came
out last fall. SAMS was last summer. The MySQL AB books are a year older
than that. I wouldn't buy the O'Reilly new -- but if it can be found in
good used condition it may be worth the price (IE, around $10-20);
though Amazon has the most recent books for just over $31...
--

 

[Dennis Lee Bieber]

If you haven't yet, I'd recommend finding a good MySQL reference...
The older Black/Brown O'Reilly/MySQL AB book is good for most stuff up
to the 4.0 level (doesn't have the 5.0 features, and is missing just a
few 4.1 advanced features or the password algorithm change)
http://www.amazon.com/gp/product/05...ef=sr_1_44/002-3455136-4040849?_encoding=UTF8

I just noticed that the Windows installer I used includes
essentially that text, updated to include (on my install) 4.1.17 (the
5.0 installer may also have a version, but I'm not going to run the
installer to find out), in CHM format.

Assuming the installer managed to put everything on disk, check for

start/programs/mysql/mysql server <version>/mysql manual

Chapter 2.3 may be of interest...
--