LinuxQuestions.org - Upgrading MySQL version 3 to 4 RedHat / Fedora

- Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)

- - Upgrading MySQL version 3 to 4 RedHat / Fedora (https://www.linuxquestions.org/questions/linux-newbie-8/upgrading-mysql-version-3-to-4-redhat-fedora-226906/)

Upgrading MySQL version 3 to 4 RedHat / Fedora

Hi all

Any one had problems upgrading MySQL from 3 to 4 :confused:

I came across this page

http://fedoranews.org/contributors/tony_smith/mysql/

Is the old version of MySQL have to be removed before installing newer version :confused:

TT

No, you can upgrade from 3.x to 4.x without having to remove the 3.x rpms but I suggest you back up your databases (if you have any) before doing the actual upgrade.

Håkan

Thank you

So its the rpm i need and not the source one
as in MySQL-4.0.20-0.src

I'm on a roll today, linux seems to be playing nice :p

TT

Can any one tell me what package to get please as in MySQL from 3 to 4

Their are so many to chose from

TT

Hi all

MySQL seem to install ok

but i have a question

what is the GRANT command i have been looking every where and i cant seem to find it

Code:

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run

the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be

able to use the new GRANT command!

The GRANT command is used in MySQL to set users' privileges. Just make sure you run that mysql_fix_privilege_tables script and you should be OK.

Håkan

I did run what i think i had to run and got an error

Code:

[root@rockinghamgateway downloads]# /usr/bin/mysql_fix_privilege_tables

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

/usr/bin/mysql_fix_privilege_tables: line 100: /usr/bin/mysql: No such file or d

irectory



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!

/usr/bin/mysql_fix_privilege_tables: line 115: /usr/bin/mysql: No such file or d

irectory



Creating Grant Alter and Index privileges if they don't exists

You can ignore any Duplicate column errors

/usr/bin/mysql_fix_privilege_tables: line 132: /usr/bin/mysql: No such file or d

irectory



Adding columns needed by GRANT .. REQUIRE (openssl)

You can ignore any Duplicate column errors

/usr/bin/mysql_fix_privilege_tables: line 159: /usr/bin/mysql: No such file or d

irectory



Creating the new table and column privilege tables

/usr/bin/mysql_fix_privilege_tables: line 175: /usr/bin/mysql: No such file or d

irectory

Changing name of columns_priv.Type -> columns_priv.Column_priv

You can ignore any Unknown column errors from this

/usr/bin/mysql_fix_privilege_tables: line 206: /usr/bin/mysql: No such file or d

irectory



Fixing the func table

You can ignore any Duplicate column errors

/usr/bin/mysql_fix_privilege_tables: line 218: /usr/bin/mysql: No such file or d

irectory



Adding new fields used by MySQL 4.0.2 to the privilege tables

You can ignore any Duplicate column errors

/usr/bin/mysql_fix_privilege_tables: line 230: /usr/bin/mysql: No such file or d

irectory

/usr/bin/mysql_fix_privilege_tables: line 255: /usr/bin/mysql: No such file or d

irectory

/usr/bin/mysql_fix_privilege_tables: line 266: /usr/bin/mysql: No such file or d

irectory

/usr/bin/mysql_fix_privilege_tables: line 278: /usr/bin/mysql: No such file or d

irectory

[root@rockinghamgateway downloads]#

does that look right i dont mine learning how to do it.

do i need to run database install command then add in root user pass etc

I hope you get my dift, i keep my own little forum full of notes but its down right now due to me upgrading from 3 to 4, so i cant remember the command off the top of my head.

TT

This is what i meant i findly remember it

/usr/bin/mysql_install_db

but this gave me an error and its asking me to copy files to another dir

Code:

Installing all prepared tables

040906 19:31:26  Warning: Asked for 196608 thread stack, but got 126976

040906 19:31:26  /usr/sbin/mysqld: Shutdown Complete





To start mysqld at boot time you have to copy support-files/mysql.server

to the right place for your system



PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'

/usr/bin/mysqladmin -u root -h rockinghamgateway.com password 'new-password'

See the manual for more instructions.

and so on

I found where the files may be

[root@localhost bin]# whereis support-files/mysql.server
mysql: /usr/lib/mysql /usr/share/mysql

where do i copy them too ? :confused:

TT