RedHat4 上安装MySql5

nosilence

　　1， 从http://www.mysql.com/downloads/ 上下载以下两个安装包：
MySQL-server-5.5.8-1.linux2.6.x86_64.rpm
MySQL-client-5.5.8-1.linux2.6.x86_64.rpm
2， 安装server包：
# rpm -ivh MySQL-server-5.5.8-1.linux2.6.x86_64.rpm
warning: MySQL-server-5.5.8-1.linux2.6.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        MySQL conflicts with mysql-4.1.20-1.RHEL4.1.i386
        MySQL conflicts with mysql-4.1.20-2.RHEL4.1.0.1.x86_64

碰到这个错误，需要先把原来的mysql4安装包卸载掉：
# rpm -e mysql-4.1.20-1.RHEL4.1 –nodeps
# rpm -e mysql-4.1.20-2.RHEL4.1.0.1.x86_64 –nodeps

重新进行安装：
# rpm -ivh MySQL-server-5.5.8-1.linux2.6.x86_64.rpm
warning: MySQL-server-5.5.8-1.linux2.6.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
   1:MySQL-server           ########################################### [100%]

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 browsing04.china.nsn-net.net password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
Please report any problems with 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

3， 安装Client 包：
# rpm -ivh MySQL-client-5.5.8-1.linux2.6.x86_64.rpm
warning: MySQL-client-5.5.8-1.linux2.6.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
   1:MySQL-client           ########################################### [100%]

4， 启动MySql：
# service mysql start
Starting MySQL.........                                    [ OK ]

5，修改Root密码：
# mysqladmin -u root password 'password'

6，修改Root配置，使Root可以远程登录进行管理：
# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 27
Server version: 5.5.8 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "password" WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

7，将MySql加入自启动：
# /sbin/chkconfig --list mysql
mysql           0:off   1:off   2:on    3:on    4:on    5:on    6:off
# /sbin/chkconfig --del mysql
# /sbin/chkconfig --list mysql
service mysql supports chkconfig, but is not referenced in any runlevel (run 'chkconfig --add mysql')
# /sbin/chkconfig --add mysql
# /sbin/chkconfig --list mysql
mysql           0:off   1:off   2:on    3:on    4:on    5:on    6:off