Linux安装mysql

配置阿里的yum

首先备份原来的cent os官方yum源

cp /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.bak

获取阿里的yum源覆盖本地官方yum源

wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo

清理yum缓存，并生成新的缓存

yum clean all yum makecache

安装MySQL

1. 检测系统是否安装过mysql

# yum list installed | grep mysql

2. 删除系统自带的MySQL

# yum -y remove (填写自己的MySQL)

3. 给CentOS添加rpm源，并且选择较新的源

命令： #wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm #yum localinstall mysql-community-release-el6-5.noarch.rpm #yum repolist all | grep mysql #yum-config-manager --disable mysql55-community #yum-config-manager --disable mysql56-community #yum-config-manager --enable mysql57-community-dmr #yum repolist enabled | grep mysql

如果第一条语句出现需要认证的问题，将上面的wget改为：

wget --no-check-certificate dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm

4. 安装MySQL服务器

# yum install mysql-community-server

5. 启动MySQL

# service mysqld start

6. 查看MYSQL是否自启动,并且设置开启自启动

# chkconfig --list | grep mysqld # chkconfig mysqld on

7. 重置MySQL密码

修改MySQL登录设置，进入到 vim /etc/my.cnf 在[mysqld]的段中加上一句：skip-grant-tables

重启MySQL service mysqld resart

然后直接登录MySQL，修改密码

mysql> use mysql; Database changed mysql> update user set password = password ('换成你自己的密码') where user = 'root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 5 Changed: 0 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql> \q

密码修改之后，将MySQL的登录设置修改回来 vim /etc/my.cnf 将刚才在[mysqld]的段中加上的skip-grant-tables注释 或着删除 保存并且退出vim

重启MySQL service mysqld resart