Code: Select all
[root@server cron.daily]# mysql -V
mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
[root@server cron.daily]# yum upgrade mysql
Gathering header information file(s) from server(s)
Server: Atomic Rocket Turtle - 9 - Atomic PSA-Compatible RPMS
Server: Red Hat Linux 9 base
Server: Fedora Legacy utilities for Red Hat Linux 9
Server: Red Hat Linux 9 updates
Finding updated packages
Downloading needed headers
cups-libs-1-1.1.17-13.3.0 100% |=========================| 5.4 kB 00:00
cups-devel-1-1.1.17-13.3. 100% |=========================| 5.6 kB 00:00
cups-1-1.1.17-13.3.0.13.l 100% |=========================| 19 kB 00:00
Finding obsoleted packages
Resolving dependencies
.Dependencies resolved
I will do the following:
[update: mysql 4.0.23a-1.rh90.art.i386]
I will install/upgrade these to satisfy the dependencies:
[deps: mysql-server 4.0.23a-1.rh90.art.i386]
[deps: mysql-compat 4.0.23a-1.rh90.art.i386]
Is this ok [y/N]: y
Downloading Packages
Getting mysql-server-4.0.23a-1.rh90.art.i386.rpm
mysql-server-4.0.23a-1.rh 100% |=========================| 1.4 MB 00:16
Getting mysql-4.0.23a-1.rh90.art.i386.rpm
mysql-4.0.23a-1.rh90.art. 100% |=========================| 7.4 MB 01:09
Getting mysql-compat-4.0.23a-1.rh90.art.i386.rpm
mysql-compat-4.0.23a-1.rh 100% |=========================| 243 kB 00:01
Running test transaction:
Test transaction complete, Success!
mysql 100 % done 1/5
mysql-compat 100 % done 2/5
mysql-server 100 % done 3/5
Completing update for mysql-server - 4/5
packagemng: db_connect: failed to connect to database: Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
packagemng: db_connect: failed to connect to database: Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
packagemng: Unable to connect to the mysql database
System error 2: No such file or directory
packagemng: Unable to connect to the mysql database
System error 2: No such file or directory
error: %trigger(psa-7.5.2-rh9.build75050128.10) scriptlet failed, exit status 1
Updated: mysql 4.0.23a-1.rh90.art.i386
Dep Installed: mysql-server 4.0.23a-1.rh90.art.i386 mysql-compat 4.0.23a-1.rh90.art.i386
Transaction(s) Complete
[root@server cron.daily]# service mysqld restart
Stopping MySQL: [FAILED]
Starting MySQL: [ OK ]
[root@server cron.daily]# mysql_fix_privilege_tables --user=admin --password=`cat /etc/psa/.psa.shadow`
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
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 1060 at line 2: Duplicate column name 'File_priv'
Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 1060 at line 1: Duplicate column name 'Grant_priv'
ERROR 1060 at line 2: Duplicate column name 'Grant_priv'
ERROR 1060 at line 3: Duplicate column name 'Grant_priv'
Setting default privileges for the new grant, index and alter privileges
Adding columns needed by GRANT .. REQUIRE (openssl)
You can ignore any Duplicate column errors
Creating the new table and column privilege tables
Changing name of columns_priv.Type -> columns_priv.Column_priv
You can ignore any Unknown column errors from this
ERROR 1054 at line 1: Unknown column 'Type' in 'columns_priv'
Fixing the func table
You can ignore any Duplicate column errors
ERROR 1060 at line 1: Duplicate column name 'type'
Adding new fields used by MySQL 4.0.2 to the privilege tables
You can ignore any Duplicate column errors
Updating new privileges in MySQL 4.0.2 from old ones
ERROR 1061 at line 5: Duplicate key name 'Grantor'
[root@server cron.daily]# service mysqld restart
Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]
