How do I downgrade MySQL to 4.1 from 5?

[markoff]

I have a new server running Plesk 8.3. Its default database is MySQL 5. After migrating several sites, my database scripts no longer work because they were MySQL 4.1 based. I understand that Plesk uses MySQL 5 as its internal database. Is there a way to downgrade MySQL to version 4.1 without adversely affecting Plesk? Is it possible to install both? Any help you can provide will be greatly appreciated. Thanks.

 

[markoff]

I get the feeling that my question may have an obvious answer and I don't know it. I will assume that 8.3 doesn't support MySQL 4.1

 

[shall]

I think the problem is rather that what you're asking isn't a simple thing to accomplish.

One of our clients needed to have MySQL 4 for an older PHP app that doesn't support MySQL 5. After I spent about 8 hours digging through alternative options (like downgrading MySQL, replacing her application and rewriting all the SQL calls within the application), it became obvious to me that those options were not really feasible.

Instead of downgrading (and making all the rest of my users upset), we just installed a second instance of MySQL just for her. After the installation, within the "MySQL Instance Config" tool, we named the new instance "MySQL4" and set the port to something other than the default (which was obviously already taken by MySQL5).

Within her application we had to change the mysql connect line from simply "localhost" to "localhostortno". This went absolutely flawlessly.

If this is the situation you're in, and I suspect it is, then I'd recommend you just install MySQL4 as well.

 

[markoff]

Thanks for the information. In my case, none of my clients use MySQL 5, so I won't have to support two versions. I am guessing all I have to do is remove it and install MySQL 4.1.

I can't find MySQL 5 in my add/remove programs. How do I uninstall MySQL 5?

 

[markoff]

I followed the directions in (http://kb.swsoft.com/en/1077). Instead of upgrading to version 5, I downgraded version 4.1. I then created an admin account with full administrator privileges and gave it the same password as my plesk admin account. I am able to log on to MySQL as admin with no problems, but plesk doesn't recognize the admin account. It claims it can't login into the server by displaying a red icon next to the server. When I try to use MyPHPAdmin, I get the following error message:

#1045 - Access denied for user 'admin'@'localhost' (using password: YES)

Why isn't Plesk recognizing the admin account that I created, is it using a password that I don't know about> FYI, there's still the root account without a password. Could this affect it?

Everything works fine if I start up Mysql with --skip-grant-tables, but this isn't recommended.

Any help will be greatly appreciated. Thanks.

 

[menorcaadmin]

I have the same situation. A php script that MUST use mysql4.1 and my VPS has 8.3 with Mysql 5.0.x installed. Did u get it to work? Its crazy that this is such a "walk in the dark" for PLESK users

 

[shall]

I have the same situation. A php script that MUST use mysql4.1 and my VPS has 8.3 with Mysql 5.0.x installed. Did u get it to work?

It only took me about half an hour to install and fully test MySQL 4.1 side-by-side MySQL 5.0. I wouldn't recommend uninstalling and trying to downgrade, because some of hte table structures are incompatible, and while it *might* work, you could end up with a bunch of very frustrated clients if you accidentally toast their data just to get one other clients site to work.