centos6.5 mysql 安装

1.检测系统是否自带安装mysql

<code> yum list installed | grep mysql</code>

2.删除系统自带的mysql及其依赖

<code>yum -y remove mysql-libs.x86_64</code>

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

<code>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</code>

4.安装mysql 服务器

<code>yum install mysql-community-server</code>

5.启动mysql

<code>service mysqld start</code>

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

<code>chkconfig --list | grep mysqld
chkconfig mysqld on</code>

7.mysql安全设置

<code>mysql_secure_installation</code>

8.临时密码

<code>5.7.10现在已经不用mysql_secure_installation命令初始化密码了，
又保存在临时文件里：/var/log/mysqld.log，
可以用grep ‘temporary password‘ /var/log/mysqld.log查找 </code>

9.设置外网可访问

<code>GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY ‘1234567‘ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY ‘1234567‘ WITH GRANT OPTION;
flush privileges;</code>

centos6.5 mysql 安装

标签：密码   查找   centos   root   检测   unit   post   code   x86