I'm running a cpanel install with mysql 4.0.20, I click update server software, and it says mysql is up to date. Alas, I need 4.1 for subqueries. Any help here?
I'm running a cpanel install with mysql 4.0.20, I click update server software, and it says mysql is up to date. Alas, I need 4.1 for subqueries. Any help here?
check with C-panel itself if they have started to suppport mysql 4.1.
cPanel Certified Specialist
http://www.admin-ahead.com
https://ticketforge.com
AIM: tux image Skype: admin-ahead
MySQL 4.1 is not yet Stable. It will not be released to the cPanel community until it is
Mysql 4.1 is now GAMMA. Any idea when it'll go stable?
We have a server running it with no problems at all.
Rack911.com - Competent Server Administration
Server Security - Administration - Managed Servers - Optimization - High Traffic Clusters
you got a howto for a cpanel friendly way to upgrade it?
Have you tried installing the RPM?
search is your friend!
cPanel Specialist Certification::Technical
We have one server running 4.1 we installed from the RPM. We did notice that there were some problems with the CPanel version of phpMyAdmin with 4.1. Upgrading phpMyAdmin seems to fix it though.
From MySQL's download page, it appears that the 4.1 branch is now listed as an official release.
to follow up, here's the announcement:
http://lists.mysql.com/announce/226
"This is the first 4.1 production release."
But...it is first release and frankly, it is not to be used for production servers unless you willing to take the heat from users on some problems that will eventually crop up that is not noticable at first but will be.
I usually upgrade when it is officially one to 3 releases later after initial release like I am doing with PHP5, which I haven't upgraded yet due to some instability and incompabilities issues that is raised for this.
I agree that with many products, and especially PHP, you should wait till a few releases have come out.
With MySQL, on the other hand, I feel like they purposefully kept 4.1 in beta/gamma stage for such a long period of time to avoid such issues. I've read many reports of 4.1 being successfully utilized in production environments long before this official release.
So, while I'm not saying that everyone should upgrade today, I think the waiting period could be shorter with MySQL than with other technologies.
MySQL Database Server
Generally Available (GA) 4.1.7
Generally Available (GA) 4.0.21 / Alpha 5.0.0 / Snapshot 5.0.1-alpha
Documentation
it's in GA mode now![]()
I am running mysql 4.1.7 having a few problems. PhpMyAdmin was the 1st but used --old-password option for mysql and this resolved that. I am able to create databases and usersfrom cpanel but users are not showing up in the drop down menus. Cpanel is adding the users correctly. I can login with mysql -u user -p. I am guessing this is either a permissions problem or mysql 4.1 writes users to the user table different then =<4.0.
Any help would be much appreciated.
Josh