Confused with mySQL

leetcrew · 03-11-2004, 08:31 PM

i am confused with mSQL.

I want to download mySQL from http://www.mysql.com/downloads/mysql-4.0.html but i dont know what file will fit on my OS (Redhat Linux 9)

I want RPM. I attempted to download Linux x86 RPM downloads (Server) but when i open that file, it says reading package header and after that, nothing happened.

pls help. thanks

bigearsbilly · 03-12-2004, 03:46 AM

corrupt rpm?
download again.

samsbox · 03-12-2004, 04:21 AM

Maybe you are installing it with the GUI (e.g. just clicking on it), and I have found that I get the same problem as you with most of the RPM's I download, so I much prefer to use the CLI...

Instead try this:

> Download the RPM

> Go to the Command Line (Terminal)

> Type "su root" and then enter your root password when prompted

> then type "rpm -ivh [the name of the package you downloaded]"

> Hit enter, and watch it do its thing

(It will alert you of any errors here much better as well)

leetcrew · 03-12-2004, 07:59 AM

Code:

[root@server1 mysql]# rpm -ivh MySQL-server-4.0.18-0.i386.rpm
warning: MySQL-server-4.0.18-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
        file /etc/my.cnf from install of MySQL-server-4.0.18-0 conflicts with file from package mysql-3.23.54a-11
        file /usr/bin/isamchk from install of MySQL-server-4.0.18-0 conflicts with file from package mysql-3.23.54a-11
... ...

        file /usr/share/mysql/ukrainian/errmsg.txt from install of MySQL-server-4.0.18-0 conflicts with file from package mysql-3.23.54a-11
[root@server1 mysql]#

thanks for replies i already attempted uninstalling mySQL 3.x from add/remove programs but still it didn't work fine.

bigearsbilly · 03-12-2004, 08:02 AM

try:

Code:

rpm -e --force MySQL-server-4.0.18-0

just a guess!

billy

mossy · 03-12-2004, 09:55 AM

also this should take care of the whole problem -
just upgrade the MySQL:

rpm -Uvh the.package.rpm

leetcrew · 03-12-2004, 10:09 AM

Quote:

Originally posted by bigearsbilly
try:

Code:

rpm -e --force MySQL-server-4.0.18-0

just a guess!

billy

Quote:

[root@server1 /]# cd ~root/mysql
[root@server1 mysql]# rpm -e --force MySQL-server-4.0.18-0.i386.rpm
rpm: only installation, upgrading, rmsource and rmspec may be forced
[root@server1 mysql]#

didn't work

leetcrew · 03-12-2004, 10:30 AM

Quote:

[root@server1 mysql]# rpm -Uvh MySQL-server-4.0.18-0.i386.rpm
warning: MySQL-server-4.0.18-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3
libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-1.11-12
libmysqlclient.so.10 is needed by (installed) php-mysql-4.2.2-17
[root@server1 mysql]#

bigearsbilly · 03-12-2004, 10:35 AM

how about --force --upgrade or whatever?

rpm --rebuild-database ??

perhaps the rpm database is corrupted?

billy

markus1982 · 03-12-2004, 11:24 AM

You can always install the binary version (.tar.gz). Please consult http://www.linux-corner.net/linux/services/mysql.html for more information!

leetcrew · 03-12-2004, 09:55 PM

i'll try

leetcrew · 03-12-2004, 11:06 PM

Quote:

Originally posted by markus1982
You can always install the binary version (.tar.gz). Please consult http://www.linux-corner.net/linux/services/mysql.html for more information!

After restart:

Quote:

[root@server1 bin]# ./mysqld
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
040313 12:41:21 Aborting

040313 12:41:21 ./mysqld: Shutdown Complete

[root@server1 bin]#

It works but after i restart my computer, i can't start mySQL. How to start mySQL on boot time?