If i trying to update the sql server downgrades..

[torpis]

To 4.0... i had updated to version 5.0, then i dosent start again, it generates a lot of errors instead.
How di i solve this, whay does it happen?

Mvh Patrik

[chirpy]

cPanel doesn't currently support MySQL 5. If you want to go back down to v4, then remove the v5 rpms (if that's what you used to installed it) and run:

/scripts/mysqlup --force

Unless you're saying that you don't want cPanel to mess around with the version of MySQL you install. In that case, look at the top of the script above and it indicates a file that you can create to prevent it from doing so.

[torpis]

cPanel doesn't currently support MySQL 5. If you want to go back down to v4, then remove the v5 rpms (if that's what you used to installed it) and run:

/scripts/mysqlup --force

Unless you're saying that you don't want cPanel to mess around with the version of MySQL you install. In that case, look at the top of the script above and it indicates a file that you can create to prevent it from doing so.

Here is the messages under the installation:


MySQL-shared-4.0.25-0
Preparing... ########################################### [100%]
1:MySQL-shared ########################################### [100%]

Waiting for MySQL to restart ...
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func tables to MySQL 3.22.14 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23

If you get 'Access denied' errors, you should run this script again
and give the MySQL root user password as an argument!
Converting all privilege tables to MyISAM format
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name'. You can safely ignore these!
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Adding columns needed by GRANT .. REQUIRE (openssl)
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Creating the new table and column privilege tables
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Changing name of columns_priv.Type -> columns_priv.Column_priv
You can ignore any Unknown column errors from this
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Fixing the func table
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Adding new fields used by MySQL 4.0.2 to the privilege tables
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Waiting for mysql to restart..............finished.


/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
/usr/sbin/setfiles: labeling files under /
matchpathcon_filespec_eval: hash table stats: 1 elements, 1/65536 buckets used, longest chain length 1
/usr/sbin/setfiles: Done.
Install Complete

[Shinichi Kato]

Same problem.

> http://forums.cpanel.net/showthread....1+mysql+failed
> Izzee
> If it won't start check your /tmp directory has permissions of 1777
> chmod /tmp 1777

But, not success....

[Sinewy]

MySQL 5.0 will work with cPanel though it's unsupported.

To disable mysqlup,

touch /etc/mysqlupdisable

[Shinichi Kato]

cd /var/lib/mysql

ls
test mysql tmp

rm -r test
rm -r tmp
cp -r mysql 'your backup dir'
rm -r mysql

/scripts/mysqlup --force


ps aux | grep mysql
Can you find mysql processes?
OK.Congratulations!

And, You should change MySQL root password.
in WHM >> SQL Services >> MySQL Root Passwd

Warning!! That is all self responsibilities.

[NetCafe]

I encountered the same problem and tried your method.

I got the following errors:

MySQL Setup Script Version 6.1
Fetching version information from http://updates.cpanel.net/mysqlinstall/version (RELEASE)....Done
This is the MySQL 4.1.13 installer release number 0.glibc23 for platform
db4-devel is installed and is the latest version.
pam-devel is installed and is the latest version.
openssl096b is installed and is the latest version.
openssl is installed and is the latest version.
openssl-devel is installed and is the latest version.
gcc is installed and is the latest version.
glibc-devel is installed and is the latest version.
compat-db is installed and is the latest version.
zlib-devel is installed and is the latest version.
rpm-build is installed and is the latest version.
Gathering header information file(s) from server(s)
Server: Centos-3 - x86_64/x86_64 - Addons
Server: Centos-3 - x86_64/x86_64 - Base
Server: Centos-3 - x86_64/x86_64 - Extras
Server: Centos-3 - x86_64/x86_64 - Updates
Finding updated packages
Downloading needed headers
No actions to take
Resetting MySQL to cPanel Defaults and Installing the Latest Version
I ran out of mirrors for MySQL. at /scripts/mysqlup line 227.