centos7 二进制安装包安装 mysql5.6

古城微笑少年丶 2022-05-22 00:15 246阅读 0赞

##     ##

centos7 二进制安装包安装 mysql5.6  
  
一、下载mysql5.6二进制安装包

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>http:</code> 
      <code>//mirrors.sohu.com/mysql/MySQL-5.6/</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

如:mysql-5.6.34-linux-glibc2.5-x86\_64.tar.gz  
  
二、安装mysql5.6(安装在/data/mysql56)  
  
(1)、创建mysql用户账号

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; useradd -s /sbin/nologin -M mysql</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

(2)、解压压缩包

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; tar xf mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

(3)、重命名

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; mv mysql-5.6.34-linux-glibc2.5-x86_64 mysql56</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

(4)、复制配置文件

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; cp /data/mysql56/support-files/my-</code> 
      <code>default</code> 
      <code>.cnf /etc/my.cnf</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

修改配置文件

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> 
    <div>
      3 
    </div> 
    <div>
      4 
    </div> 
    <div>
      5 
    </div> 
    <div>
      6 
    </div> 
    <div>
      7 
    </div> 
    <div>
      8 
    </div> 
    <div>
      9 
    </div> 
    <div>
      10 
    </div> 
    <div>
      11 
    </div> 
    <div>
      12 
    </div> 
    <div>
      13 
    </div> 
    <div>
      14 
    </div> 
    <div>
      15 
    </div> 
    <div>
      16 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>[client]</code> 
     </div> 
     <div> 
      <code>port = 3306</code> 
     </div> 
     <div> 
      <code>socket = /data/mysql56/mysql.sock</code> 
     </div> 
     <div> 
      <code>default</code> 
      <code>-character-set = utf8</code> 
     </div> 
     <div> 
      <code>[mysqld]</code> 
     </div> 
     <div> 
      <code>skip-name-resolve</code> 
     </div> 
     <div> 
      <code>user = mysql</code> 
     </div> 
     <div> 
      <code>basedir = /data/mysql56</code> 
     </div> 
     <div> 
      <code>datadir = /data/mysql56/data</code> 
     </div> 
     <div> 
      <code>port = 3306</code> 
     </div> 
     <div> 
      <code>server_id = 10</code> 
     </div> 
     <div> 
      <code>socket = /data/mysql56/mysql.sock</code> 
     </div> 
     <div> 
      <code>pid-file = /data/mysql56/mysql.pid</code> 
     </div> 
     <div> 
      <code>log-error = /data/mysql56/data/mysql.err</code> 
     </div> 
     <div> 
      <code>log-bin = /data/mysql56/data/mysql-bin</code> 
     </div> 
     <div> 
      <code>character-set-server = utf8</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

(\*二进制安装，默认配置文件在/etc/my.cnf)  
  
(5)、初始化数据库

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> 
    <div>
      3 
    </div> 
    <div>
      4 
    </div> 
    <div>
      5 
    </div> 
    <div>
      6 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; </code> 
      <code>chown</code> 
      <code>-R mysql.mysql /data/mysq56</code> 
     </div> 
     <div> 
      <code>&gt; /data/mysql56/scripts/mysql_install_db \</code> 
     </div> 
     <div> 
      <code>--defaults-file=/etc/my.cnf \</code> 
     </div> 
     <div> 
      <code>--user=mysql \</code> 
     </div> 
     <div> 
      <code>--basedir=/data/mysql56 \</code> 
     </div> 
     <div> 
      <code>--datadir=/data/mysql56/data</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

如果出现如下信息

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>FATAL ERROR: please install the following Perl modules before executing</code> 
     </div> 
     <div> 
      <code>Data::Dumper</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; yum -y install autoconf</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

此包安装时会安装Data:Dumper模块  
  
三、配置并启动mysql

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; cp /data/mysql56/support-files/mysql.server /etc/init.d/mysqld</code> 
     </div> 
     <div> 
      <code>&gt; </code> 
      <code>chmod</code> 
      <code>755 /etc/init.d/mysqld</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

(\*注意,mysql二进制安装默认的路径为/usr/local/mysql,启动脚本里/usr/local/mysql需要替换)

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; sed -i </code> 
      <code>'s#/usr/local/mysql#/data/mysql56#g'</code> 
      <code>/data/mysql56/bin/mysqld_safe /etc/init.d/mysqld</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

启动mysql

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; service mysqld start</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

四、添加自启动

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> 
    <div>
      3 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; chkconfig --add mysqld</code> 
     </div> 
     <div> 
      <code>&gt; chkconfig mysqld on</code> 
     </div> 
     <div> 
      <code>&gt; chkconfig --list mysqld</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

五、配置环境变量

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; </code> 
      <code>echo</code> 
      <code>'export PATH=/data/mysql56/bin:$PATH'</code> 
      <code>&gt;&gt; /etc/profile</code> 
     </div> 
     <div> 
      <code>&gt; source /etc/profile</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

六、修改mysql密码(mysql5.6安装默认root密码为空)

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; mysqladmin -u root password </code> 
      <code>'123456'</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

七、清理无用的mysql用户及库  
登陆mysql

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; mysql -uroot -p</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

查询用户

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; select user,host from mysql.user;</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

如下所示

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> 
    <div>
      3 
    </div> 
    <div>
      4 
    </div> 
    <div>
      5 
    </div> 
    <div>
      6 
    </div> 
    <div>
      7 
    </div> 
    <div>
      8 
    </div> 
    <div>
      9 
    </div> 
    <div>
      10 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>+------+-----------------------+</code> 
     </div> 
     <div> 
      <code>| user | host&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>+------+-----------------------+</code> 
     </div> 
     <div> 
      <code>| root | 127.0.0.1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| root | ::1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | localhost&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| root | localhost&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | localhost.localdomain |</code> 
     </div> 
     <div> 
      <code>| root | localhost.localdomain |</code> 
     </div> 
     <div> 
      <code>+------+-----------------------+</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> 
    <div>
      3 
    </div> 
    <div>
      4 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; drop user </code> 
      <code>"root"</code> 
      <code>@</code> 
      <code>"::1"</code> 
      <code>;</code> 
     </div> 
     <div> 
      <code>&gt; drop user </code> 
      <code>""</code> 
      <code>@</code> 
      <code>"localhost"</code> 
      <code>;</code> 
     </div> 
     <div> 
      <code>&gt; drop user </code> 
      <code>""</code> 
      <code>@</code> 
      <code>"localhost.localdomain"</code> 
      <code>;</code> 
     </div> 
     <div> 
      <code>&gt; drop user </code> 
      <code>"root"</code> 
      <code>@</code> 
      <code>"localhost.localdomain"</code> 
      <code>;</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

删除无用库

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>&gt; drop database test;</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>