Mysql4.1.7 INstallation

Hello all,

Is there a full proof installation for dummies that is truly simple enough
for anyone to use? I am confused as to whether I need to create my.cnf file
or whether the installer program created it. for me.

Could someone direct me to the easiest way to install Mysql ver 4.1.7?

Thanks

____________________________________________________________ _____
FREE pop-up blocking with the new MSN Toolbar – get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01 /


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Mysql4.1.7 INstallation

Ola One wrote:

> Could someone direct me to the easiest way to install Mysql
> ver 4.1.7?

I'm assuming a Windows installation is what you're after...?

The 4.1.7 Essentials distribution was pretty simple to install.
It's one of the download options listed at mysql.com.
It has a wizard-type procedure that you step through and make
decisions - MySQL will make the appropriate my.cnf file.

The only catch I encountered (and this is a problem with any
4.1.* distribution) is that you need to be aware of the new
password length (assuming you're upgrading from 4.0.*).
I initially had problems getting phpMyAdmin to work - finally
fixed it by specifying a MySQL user with the OLD_PASSWORD
option.

Another way to fix would be to start the MySQL service with the
--old-password directive; then the whole system reverts to
using the old password format.

Peter.

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Mysql4.1.7 INstallation

Ola One wrote:

> Thanks, but what is the new password lenght?

Ola,

It's not a field length as such, it's just a change in the way that
MySQL calculates passwords. I think the real problem is actually
that the standard PHP distributions don't support the new method.

ie, I load phpMyAdmin, try to log in with my password, but when PHP
sends the encrypted password to the MySQL server, the server hashes
it differently, so the password I enter, even though it's correct,
doesn't match with the one in the database.

I understand all the standard PHP distributions have old versions of
the MySQL interface DLL - the only way to fix (without reverting
to the old password format) is to recompile PHP yourself with the
new SQL DLLs.

This change will have no effect on how long your password can be,
or anything like that.

Peter.

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org