LinuxQuestions.org - MySQL 4.1 install

- Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)

- - MySQL 4.1 install (https://www.linuxquestions.org/questions/linux-software-2/mysql-4-1-install-349395/)

MySQL 4.1 install

Hey everyone, let me give you an overview of what I've been doing to bring you up to speed.
I tried to upgrade MySQL 3.23 to 4.1 and as everyone knows you get dependency problems. So I thought why not just get rid of 3.23 all together and try to install 4.1 fresh. Well this is what I get when i attempt to do as i just explained.....

Code:

rpm -i MySQL-server-4.1.13-0.i386.rpm

warning: MySQL-server-4.1.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5

        package MySQL-server-4.1.13-0 is already installed

[root@localhost mark]# rpm -q MySQL

package MySQL is not installed

Maybe someone can point me in the propper direction...
Becareful i'm somewhat of a newb here, so don't work me over with lingo....Thanks

Try,

Code:

$rpm -qa | grep - mysql

The following is what ended up with that command....

Code:

 rpm -qa | grep mysql

libdbi-dbd-mysql-0.6.5-9

mysqlclient10-3.23.58-6

Uninstall those packages, then do

Code:

#rpm --rebuilddb

Once thats done, install your mysql packages. You may also think of upgrading to FC4 if its an option for you because it has newer packages which are still being updated.

Ok I've been round and round the mulberry bush with this thing and I keep ending up at the same berry. Can someone please point me in the proper direction....
Thanks

Code:

[root@localhost ~]# cd /home/mark/

[root@localhost mark]# rpm -i MySQL-server-4.1.13-0.i386.rpm

warning: MySQL-server-4.1.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5

        package MySQL-server-4.1.13-0 is already installed

[root@localhost mark]# rpm -e MySQL-server-4.1.13-0

[root@localhost mark]# rpm -i MySQL-server-4.1.13-0.i386.rpm

warning: MySQL-server-4.1.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5

chown: `mysql:mysql': invalid user

chown: `mysql': invalid user

050805 14:41:33 [Warning] Asked for 196608 thread stack, but got 126976

050805 14:41:33 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!



050805 14:41:33 [ERROR] Aborting



050805 14:41:33 [Note] /usr/sbin/mysqld: Shutdown complete



Installation of system tables failed!



Examine the logs in /var/lib/mysql for more information.

You can also try to start the mysqld daemon with:

/usr/sbin/mysqld --skip-grant &

You can use the command line tool

/usr/bin/mysql to connect to the mysql

database and look at the grant tables:



shell> /usr/bin/mysql -u root mysql

mysql> show tables



Try 'mysqld --help' if you have problems with paths. Using --log

gives you a log in /var/lib/mysql that may be helpful.



The latest information about MySQL is available on the web at

http://www.mysql.com

Please consult the MySQL manual section: 'Problems running mysql_install_db',

and the manual section that describes problems on your OS.

Another information source is the MySQL email archive.

Please check all of the above before mailing us!

And if you do mail us, you MUST use the /usr/bin/mysqlbug script!

chown: `mysql:mysql': invalid user

Starting MySQL...................................[FAILED]

Quote:

Originally posted by Raggit

Code:

chown: `mysql:mysql': invalid user chown: `mysql': invalid user 050805 14:41:33 [Warning] Asked for 196608 thread stack, but got 126976 050805 14:41:33 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!

Does the user mysql exist?? If not create

Code:

useradd -d /dev/null -s /bin/false mysql

Also there are binary distros available from www.mysql.com that work without rpm.

Quote:

Originally posted by Raggit
The following is what ended up with that command....

Code:

rpm -qa | grep mysql libdbi-dbd-mysql-0.6.5-9 mysqlclient10-3.23.58-6

FYI
That is because you searched for mysql and NOT MySQL.

rpm -qa | egrep "sql|SQL"

will give you a different result including your installed MySQL server

/Fredrik