MySql installation for linux

rich_m · Post by **rich_m** » Fri Mar 28, 2008 6:22 am

AlexExtreme wrote:If possible you should update to RHEL5. It's far better, has a newer MySQL and a decent package manager.

If you can't, get the RPMs for MySQL 5.0 here

You want to get the RHEL4 x86 Server, Client, Shared libraries, Shared compatibility libraries and Headers and libraries packages. Download them all to your server and install each of them in turn with
Code: Select all
rpm -Uvh /path/to/file.rpm

I guess i have to first uninstall the older version of MySql,

This is what i dug from google

rpm -qa | grep mysql
And then remoove the package that come out of the
query above.
rpm -e <packagename>
And then install the package again with
rpm -ivh <packagename>

This is what happened when i tried to get Mysql5 installed.

Code: Select all

[root@trisvr3 Downloads]# rpm -i MySQL-server-community-5.0.51a-0.rhel4.i386.rpm
warning: MySQL-server-community-5.0.51a-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        MySQL conflicts with mysql-4.1.7-4.RHEL4.1.i386
        MySQL-server conflicts with mysql-server-4.1.7-4.RHEL4.1.i386
[root@trisvr3 Downloads]#

Code: Select all

lukem95 · Post by **lukem95** » Fri Mar 28, 2008 6:34 am

you didnt remove the old MySQL installation.

Do you have physical access to the box? it may be easier. Or easier still, install a more recent distro with a LAMP config.

xyzzy · Post by **xyzzy** » Fri Mar 28, 2008 6:39 am

So you say that you found on Google that you need to uninstall the old installation (which you do.) yet you didn't actually do it?

lukem95 wrote:Do you have physical access to the box? it may be easier. Or easier still, install a more recent distro with a LAMP config.

Why would physical access be easier?

lukem95 · Post by **lukem95** » Fri Mar 28, 2008 7:12 am

because someone used to windows would find downloading and installing something using the GUI for a package manager much easier than a command line via SSH (well... i know i used to anyway)

xyzzy · Post by **xyzzy** » Fri Mar 28, 2008 7:23 am

What if a GUI isn't installed on the box? Most Linux servers (mine included) don't have a GUI, just a command line. It's deemed to be a security hole because having more software on increases the chance of an exploit/security flaw existing.

rich_m · Post by **rich_m** » Fri Mar 28, 2008 7:25 am

AlexExtreme wrote:So you say that you found on Google that you need to uninstall the old installation (which you do.) yet you didn't actually do it?

lukem95 wrote:Do you have physical access to the box? it may be easier. Or easier still, install a more recent distro with a LAMP config.
Why would physical access be easier?

I cant uninstall it the way mentioned, as i dont have the mysql rpm of the older version, plus i cant change the distro as all i have is a remote access to a server with root..........

I have to live with this Linux installation and only a comman line interface, and get the LAMP running.....So hopeing to get M of LAMP done first!!!!!!!!

How would I uninstall the older version????????

xyzzy · Post by **xyzzy** » Fri Mar 28, 2008 7:35 am

You don't need the original RPM to uninstall.

Code: Select all

rpm -e mysql
rpm -e mysql-server

rich_m · Post by **rich_m** » Fri Mar 28, 2008 9:40 am

Wow.........am really happy seems to be getting somewhere.

This worked fine.

Code: Select all

[root@trisvr3 Downloads]# rpm -e mysql-server
[root@trisvr3 Downloads]#

Hope that means it has uninstalled the mysql-server. No message came with an announcement of the same.

Code: Select all

[root@trisvr3 Downloads]#rpm -e mysql

This did not work though it gave me a list of dependencies, such as php etc....Should I force the uninstallation in some way......Hoping that the dependencies will work fine after I install the latest version????

JamesM · Post by **JamesM** » Fri Mar 28, 2008 9:41 am

No, the second one is merely the mysql client. Ignore the errors and carry on...

rich_m · Post by **rich_m** » Fri Mar 28, 2008 9:43 am

lukem95 wrote:because someone used to windows would find downloading and installing something using the GUI for a package manager much easier than a command line via SSH (well... i know i used to anyway)

I seriously wish I had a GUI.......This is eating a lot of time.....Anyways, it always good to learn something new.

rich_m · Post by **rich_m** » Fri Mar 28, 2008 11:36 pm

Code: Select all

[root@trisvr3 ignite]# rpm -e mysql
error: Failed dependencies:
        libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.                                                                              i386
        libmysqlclient.so.14 is needed by (installed) mod_auth_mysql-2.6.1-2.1.i                                                                              386
        libmysqlclient.so.14 is needed by (installed) php-mysql-4.3.9-3.1.i386
        libmysqlclient.so.14 is needed by (installed) cyrus-sasl-sql-2.1.19-5.EL                                                                              4.i386
        libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-2.EL4.1.i3                                                                              86
        libmysqlclient.so.14 is needed by (installed) freeradius-mysql-1.0.1-2.R                                                                              HEL4.i386
        mysql = 4.1.7 is needed by (installed) mysql-bench-4.1.7-4.RHEL4.1.i386
        mysql = 4.1.7 is needed by (installed) mysql-devel-4.1.7-4.RHEL4.1.i386
        mysql is needed by (installed) freeradius-mysql-1.0.1-2.RHEL4.i386
[root@trisvr3 ignite]#

rich_m · Post by **rich_m** » Fri Mar 28, 2008 11:39 pm

JamesM wrote:No, the second one is merely the mysql client. Ignore the errors and carry on...

By carry on, i think you meant carry on with installing MySql 5

I tried it again, I guess i should find a way to force the uninstalling of the client as well of the older version????

Code: Select all

[root@trisvr3 Downloads]# rpm -i MySQL-server-community-5.0.51a-0.rhel4.i386.rpm
warning: MySQL-server-community-5.0.51a-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        MySQL conflicts with mysql-4.1.7-4.RHEL4.1.i386
[root@trisvr3 Downloads]#

rich_m · Post by **rich_m** » Mon Mar 31, 2008 11:02 pm

Done It

[root@trisvr3 /]# rpm -e --nodeps mysql
[root@trisvr3 /]#

xyzzy · Post by **xyzzy** » Tue Apr 01, 2008 12:25 am

Now install the new RPMs with rpm -ivh <file>

rich_m · Post by **rich_m** » Tue Apr 01, 2008 2:32 am

This is torture, seems i can't install the latest MySql "remotely", will a mySql dump work just as fine???

[root@trisvr3 Downloads]# rpm - i --relocate /usr/local/MySQl/ MySQL-server-community-5.0.51a-0.rhel4.i386.rpm
rpm: relocations must contain a =
[root@ignitetrisvr3 Downloads]# rpm -i MySQL-server-community-5.0.51a-0.rhel4.i386.rpm
warning: MySQL-server-community-5.0.51a-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Installation of system tables failed!

Examine the logs in /var/lib/mysql for more information.
You can try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
and 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!

Notes regarding SELinux on this platform:
=========================================

The default policy might cause server startup to fail because it is
not allowed to access critical files. In this case, please update
your installation.

The default policy might also cause inavailability of SSL related
features because the server is not allowed to access /dev/random
and /dev/urandom. If this is a problem, please do the following:

1) install selinux-policy-targeted-sources from your OS vendor
2) add the following two lines to /etc/selinux/targeted/src/policy/domains/program/mysqld.te:
allow mysqld_t random_device_t:chr_file read;
allow mysqld_t urandom_device_t:chr_file read;
3) cd to /etc/selinux/targeted/src/policy and issue the following command:
make load

Starting MySQL/etc/init.d/mysql: line 159: kill: (5289) - No such process
[FAILED]
Giving mysqld 2 seconds to start
[root@ignitetrisvr3 Downloads]# mysql
bash: mysql: command not found
[root@ignitetrisvr3 Downloads]# cd ..
[root@ignitetrisvr3 ignite]# cd ..
[root@ignitetrisvr3 home]# cd ..
[root@ignitetrisvr3 /]# find / -name"mysql"
find: invalid predicate `-namemysql'
[root@ignitetrisvr3 /]# find / -name "mysql"
/etc/logrotate.d/mysql
/etc/rc.d/init.d/mysql
/var/lock/subsys/mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/share/doc/openldap-servers-sql-2.2.13/rdbms_depend/mysql
/usr/share/mysql
/usr/include/mysql3/mysql
/usr/include/mysql
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBD/mysql
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/DBD/mysql
/usr/lib/mysql3/mysql
/usr/lib/mysql
[root@trisvr3 /]# rpm -e --nodeps mysql
error: package mysql is not installed

OSDev.org

MySql installation for linux

Re:

Re:

Re:

Re:

Screen Shot

:-(