centos下安装mysql

1.查找以前是否装有MySQL

命令：rpm -qa|grep -i mysql
---------------------------------------------------------
[test@localhost ~]$ rpm -qa|grep -i mysql
mod_auth_mysql-3.0.0-11.el6_0.1.x86_64
mysql-5.1.73-3.el6_5.x86_64
mysql-libs-5.1.73-3.el6_5.x86_64
mysql-server-5.1.73-3.el6_5.x86_64
mysql-devel-5.1.73-3.el6_5.x86_64
perl-DBD-MySQL-4.013-3.el6.x86_64
php-mysql-5.3.3-27.el6_5.x86_64
[test@localhost ~]$ 
-----------------------------------------------------------
说明已经安装
mysql-server
mysql_devel

2.停止MySQL服务
mysql服务命令有二种：一种是mysql，第二种是mysqld
方法一:service mysql stop
方法二:/etc/init.d/mysql shutdown
方法三:service mysqld stop
方法四:/etc/init.d/mysqld shutdown
------------------------------------------------------------
[test@localhost ~]$ service mysql stop
mysql: unrecognized service
[test@localhost ~]$ service mysqld stop
Stopping mysqld:                                           [FAILED]
[test@localhost ~]$ su
Password: 
[root@localhost test]# service mysql stop
mysql: unrecognized service
[root@localhost test]# service mysqld stop
Stopping mysqld:                                           [  OK  ]
[root@localhost test]# 
------------------------------------------------------------

3.卸载mysql
卸载命令:rpm -e
强制卸载命令: rpm -e --nodeps
例如:
rpm -ev mysql-server-5.1.73-3.el6_5.x86_64
rpm -e --nodeps mysql-server-5.1.73-3.el6_5.x86_64

4.查询旧版本mysql的目录，病删除旧版本mysql的文件和库
查找命令：find / -name mysql
-------------------------------------------------------------
[root@localhost test]# find / -name mysql
/usr/include/mysqlclient/mysql
/usr/lib64/mysql
/usr/share/mysql
/var/lib/mysql
/var/lib/mysql/mysql
/home/test/Downloads/mysqlclient/include/mysql
-------------------------------------------------------------
删除旧版本mysql的文件和库
rm -rf /usr/lib64/mysql
rm -rf /usr/share/mysql
rm -rf /var/lib/mysql
注意：卸载后/etc/my.cnf不会删除，需要进行手工删除
 rm -rf /etc/my.cnf

5.再次检查机器是否安装mysql
输入命令：rpm -qa|grep -i mysql
无结果则表示彻底卸载

6.yum命令在线安装mysql

6.1查看yum上可下载的mysql版本

输入命令:yum list | grep mysql

6.2使用yum安装mysql

输入命令：yum install -y mysql-server mysql mysql-devel

6.3查看mysql的版本

输入命令：rpm -qi mysql-server

6.4第一次运行mysql

输入命令: service mysqld start

注意：如果我们是第一次启动mysql服务，mysql服务器首先会进行初始化的配置

6.5设置mysql为开机自动启动

首先查看mysql是否是开机自动启动

-------------------------------------------------------

[root@localhost test]# chkconfig --list | grep mysql
mysqld          0:off 1:off 2:off 3:off 4:off 5:off 6:off

---------------------------------------------------------
我们发现mysqld服务并没有开机自动启动，我们当然可以通过 chkconfig mysqld on 命令来将其设置成开机启动，这样就不用每次都去手动启动了

6.6修改mysql的登陆密码

-----------------------------------------

[root@localhost test]# mysqladmin -u root password '123456'

-----------------------------------------

CentOS 6.4下通过yum安装的MySQL是5.1版的，可以通过源代码安装高版本的5.6.14。

7.离线安装mysql

从http://dev.mysql.com/downloads/mysql/下载mysql源代码mysql-5.6.20.tar.gz

[root@cddserver2 ~]# yum -y install gcc-*
Loaded plugins: fastestmirror, presto
Could not retrieve mirrorlist http://mirrorlist.centos.org/?release=6&arch=x86_64&repo=os error was
14: PYCURL ERROR 6 - "Couldn't resolve host 'mirrorlist.centos.org'"
Error: Cannot retrieve repository metadata (repomd.xml) for repository: base. Please verify its path and try again

原因：
 dns服务器没有配置正确

解决办法：
1、打开文件/etc/resolv.conf在其中添加：
 nameserver 8.8.8.8
 nameserver 8.8.4.4
 search localdomain

2、然后重启网卡：使用命令: service network restart

1)uname -a 
2)cat /proc/version 
3)cat /etc/issue

[root@c /]# mysql -u root -p

 grant all privileges on *.* to root@'%' identified by '123456'

FLUSH PRIVILEGES;

service iptables status

http://blog.youkuaiyun.com/fyq891014/article/details/17360245

http://www.mamicode.com/info-detail-503994.html