RHEL5.6环境下yum安装MySQL记录，2017年2月20日
1、卸载原有的MySQL
rpm -qa命令查询是否安装了MySQL
[root@localhost mysql]# rpm -qa|grep mysql mysql-server-5.0.77-4.el5_5.4 mysql-5.0.77-4.el5_5.4
使用rpm -e命令卸载安装包，如果卸载时提示依赖可以增加“--nodeps”参数；
如果想删除依赖项则直接卸载依赖项后再删除相应的包。
[root@localhost mysql]# rpm -e mysql-server-5.0.77-4.el5_5.4 [root@localhost mysql]# rpm -e mysql-5.0.77-4.el5_5.4 error: Failed dependencies: libmysqlclient.so.15()(64bit) is needed by (installed) perl-DBD-MySQL-3.0007-2.el5.x86_64 libmysqlclient.so.15(libmysqlclient_15)(64bit) is needed by (installed) perl-DBD-MySQL-3.0007-2.el5.x86_64 [root@localhost mysql]# rpm -qa|grep MySQL perl-DBD-MySQL-3.0007-2.el5 [root@localhost mysql]# rpm -e perl-DBD-MySQL-3.0007-2.el5 [root@localhost mysql]# rpm -e mysql-5.0.77-4.el5_5.4
2、yum安装MySQL
查询yum源中是否具有MySQL服务。
[root@localhost yum.repos.d]# yum list | grep mysql This system is not registered with RHN. RHN support will be disabled. apr-util-mysql.x86_64 1.2.7-11.el5_5.2 base bytefx-data-mysql.x86_64 1.2.4-2.el5.centos extras freeradius-mysql.x86_64 1.1.3-1.6.el5 base freeradius2-mysql.x86_64 2.1.12-5.el5 base libdbi-dbd-mysql.x86_64 0.8.1a-1.2.2 base mod_auth_mysql.x86_64 1:3.0.0-3.2.el5_3 base mysql.i386 5.0.95-5.el5_9 base mysql.x86_64 5.0.95-5.el5_9 base mysql-bench.x86_64 5.0.95-5.el5_9 base mysql-connector-odbc.x86_64 3.51.26r1127-2.el5 base mysql-connector-odbc64.x86_64 5.1.8-1.el5 base mysql-devel.i386 5.0.95-5.el5_9 base mysql-devel.x86_64 5.0.95-5.el5_9 base mysql-server.x86_64 5.0.95-5.el5_9 base mysql-test.x86_64 5.0.95-5.el5_9 base mysql51.x86_64 1-9.el5 base mysql51-build.x86_64 1-9.el5 base mysql51-mysql.x86_64 5.1.70-1.el5 base mysql51-mysql-bench.x86_64 5.1.70-1.el5 base mysql51-mysql-libs.x86_64 5.1.70-1.el5 base mysql51-mysql-server.x86_64 5.1.70-1.el5 base mysql51-mysql-test.x86_64 5.1.70-1.el5 base mysql51-runtime.x86_64 1-9.el5 base mysql55.x86_64 1-12.el5 base mysql55-build.x86_64 1-12.el5 base mysql55-mysql.x86_64 5.5.45-1.el5 update mysql55-mysql-bench.x86_64 5.5.45-1.el5 update mysql55-mysql-devel.i386 5.5.45-1.el5 update mysql55-mysql-devel.x86_64 5.5.45-1.el5 update mysql55-mysql-libs.x86_64 5.5.45-1.el5 update mysql55-mysql-server.x86_64 5.5.45-1.el5 update mysql55-mysql-test.x86_64 5.5.45-1.el5 update mysql55-runtime.x86_64 1-12.el5 base pdns-backend-mysql.x86_64 2.9.21-4.el5.centos extras php-mysql.x86_64 5.1.6-45.el5_11 update php-pear-MDB2-Driver-mysql.noarch 1.4.1-3.el5.centos extras php53-mysql.x86_64 5.3.3-26.el5_11 update qt4-mysql.x86_64 4.2.1-1.el5_7.1 base rsyslog-mysql.x86_64 3.22.1-7.el5 base rsyslog5-mysql.x86_64 5.8.12-7.el5_11 update [root@localhost yum.repos.d]#
安装MySQL及其相关服务
yum install -y mysql-server mysql mysql-devel
[root@localhost yum.repos.d]# rpm -qa|grep mysql mysql-5.0.95-5.el5_9 mysql-devel-5.0.95-5.el5_9 mysql-devel-5.0.95-5.el5_9 mysql-5.0.95-5.el5_9 mysql-server-5.0.95-5.el5_9
可以看到mysql安装的包。
3、配置MySQL
3.1、查看MySQL服务状态
[root@localhost yum.repos.d]# service mysqld status mysqld is stopped
3.2、启动MySQL服务
[root@localhost yum.repos.d]# service mysqld start Initializing MySQL database: Installing MySQL system tables... OK Filling help tables... OK 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 localhost.localdomain 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. You can start the MySQL daemon with: cd /usr ; /usr/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd mysql-test ; perl mysql-test-run.pl Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com [ OK ] Starting mysqld: [ OK ] [root@localhost yum.repos.d]#
查看MySQL服务状态：
[root@localhost yum.repos.d]# service mysqld status mysqld (pid 5806) is running...
在终端中敲入mysql命令可以直接进入mysql命令行，此时MySQL没有设置登录密码。
[root@localhost yum.repos.d]# mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 Server version: 5.0.95 Source distribution Copyright (c) 2000, 2011, 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>
3.3、启用MySQL登录密码：
[root@localhost yum.repos.d]# mysqladmin -u root password "passw0rd"
再次敲入mysql提示登录信息：
[root@localhost yum.repos.d]# mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
使用密码登录MySQL：
[root@localhost yum.repos.d]# mysql mysql -u root -p Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 5 Server version: 5.0.95 Source distribution Copyright (c) 2000, 2011, 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>
3.4、允许root账号远程登录：
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'passw0rd' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec)