Upgrade problem

Hi folks,

I recently upgraded my db from version 3.23.49 (I think) to 4.0.23. I had
previously done this on two other machines with no problems but on this
server some (not all) of my MySQL user accounts have stopped working. For
example one I had to fix today in order to get it working I had to change
the sql user details from an account that I had created to the root account
(terribly unsafe) but nothing else works. Other tables work fine some I had
to reset the password and others I didn't even have to do that. Before the
upgrade everything worked perfectly and uf I don't have the original source
files to revert the db. The only other option is to do a restore from a few
weeks ago (not an idea I relish!)

I'm really confused as to what is going on so can anyone help at all ?

For info the machine is a Win2K server SP4 running IIS5 and PHP 4.3.3

Thanks for any help


--
Regards

Neil

Registered Linux User 324599
Windows: No remote holes in almost 3 hours

HawkEye wrote:
 > Hi folks,
 >
 > I recently upgraded my db from version 3.23.49 (I think) to 4.0.23. I
 > had previously done this on two other machines with no problems but on
 > this server some (not all) of my MySQL user accounts have stopped
 > working. For example one I had to fix today in order to get it working I
 > had to change the sql user details from an account that I had created to
 > the root account (terribly unsafe) but nothing else works. Other tables
 > work fine some I had to reset the password and others I didn't even have
 > to do that. Before the upgrade everything worked perfectly and uf I
 > don't have the original source files to revert the db. The only other
 > option is to do a restore from a few weeks ago (not an idea I relish!)
 >
 > I'm really confused as to what is going on so can anyone help at all ?
 >
 > For info the machine is a Win2K server SP4 running IIS5 and PHP 4.3.3

I would guess that the mysql database may have been damaged (could be a bad
harddrive or just bad luck due a bad filesystem like vfat or ntfs).

You could try to start with backup the current mysql database and then replace
it with the one week old mysql database, this should restor all users and
their passowrds.


//Aho<!-- ~MESSAGE_AFTER~ -->