Linux el6安装MySQL-5.6

绝地灬酷狼 2022-09-17 14:23 132阅读 0赞

MySQL-5.6下载地址：http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-5.6.14-1.el6.x86\_64.rpm-bundle.tar

For Centos 6, RPM may complain that you may have mysql-libs that is of version 5.1 due to crontabs. You can do the following to solve this issue:

rpm -i MySQL-shared-compat-\*  
yum remove mysql-libs  
rpm -i MySQL-server-\*

rpm -i MySQL-client-\*

=========

Table . MySQL Installation Layout for Linux RPM Packages

<table style="margin:0px 0px 10px; padding:0px; border:none; outline:0px; font-size:14px; vertical-align:baseline; background-color:transparent; border-spacing:0px; border-collapse:collapse; max-width:660px">     
 <thead style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:baseline; background-color:transparent"> 
  <tr style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:top; background-color:transparent"> 
   <th style="margin:0px; padding:3px; border:0.1em solid grey; outline:0px; font-size:14px; vertical-align:baseline; font-family:Helvetica,Arial,sans-serif"> Directory</th> 
   <th style="margin:0px; padding:3px; border:0.1em solid grey; outline:0px; font-size:14px; vertical-align:baseline; font-family:Helvetica,Arial,sans-serif"> Contents of Directory</th> 
  </tr> 
 </thead> 
 <tbody style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:baseline; background-color:transparent"> 
  <tr style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:top; background-color:transparent"> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> <code style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:baseline; color:rgb(14,64,117); font-family:'Courier New',Courier,fixed,monospace">/usr/bin</code></td> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> Client programs and scripts</td> 
  </tr> 
  <tr style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:top; background-color:transparent"> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> <code style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:baseline; color:rgb(14,64,117); font-family:'Courier New',Courier,fixed,monospace">/usr/sbin</code></td> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> The&nbsp;<a href="http://dev.mysql.com/doc/refman/5.5/en/mysqld.html" title="4.3.1.&nbsp;mysqld — The MySQL Server" style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:baseline; background-color:transparent; color:rgb(1,90,132)" rel="nofollow"><span style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:baseline; background-color:transparent"><span style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:baseline; background-color:transparent">mysqld</span></span></a>&nbsp;server</td> 
  </tr> 
  <tr style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:top; background-color:transparent"> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> <code style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:baseline; color:rgb(14,64,117); font-family:'Courier New',Courier,fixed,monospace">/var/lib/mysql</code></td> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> Log files, databases</td> 
  </tr> 
  <tr style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:top; background-color:transparent"> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> <code style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:baseline; color:rgb(14,64,117); font-family:'Courier New',Courier,fixed,monospace">/usr/share/info</code></td> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> Manual in Info format</td> 
  </tr> 
  <tr style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:top; background-color:transparent"> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> <code style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:baseline; color:rgb(14,64,117); font-family:'Courier New',Courier,fixed,monospace">/usr/share/man</code></td> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> Unix manual pages</td> 
  </tr> 
  <tr style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:top; background-color:transparent"> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> <code style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:baseline; color:rgb(14,64,117); font-family:'Courier New',Courier,fixed,monospace">/usr/include/mysql</code></td> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> Include (header) files</td> 
  </tr> 
  <tr style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:top; background-color:transparent"> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> <code style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:baseline; color:rgb(14,64,117); font-family:'Courier New',Courier,fixed,monospace">/usr/lib/mysql</code></td> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> Libraries</td> 
  </tr> 
  <tr style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:top; background-color:transparent"> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> <code style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:baseline; color:rgb(14,64,117); font-family:'Courier New',Courier,fixed,monospace">/usr/share/mysql</code></td> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation</td> 
  </tr> 
  <tr style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:top; background-color:transparent"> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> <code style="margin:0px; padding:0px; border:0px; outline:0px; vertical-align:baseline; color:rgb(14,64,117); font-family:'Courier New',Courier,fixed,monospace">/usr/share/sql-bench</code></td> 
   <td style="margin:0px; padding:0px 5px; border:0.1em outset gray; outline:0px; font-size:13px; vertical-align:baseline; background-color:transparent; font-family:Helvetica,Arial,sans-serif"> Benchmarks</td> 
  </tr> 
 </tbody> 
</table>

==========

第一次登录的密码在/root/.mysql\_secret中

cat .mysql\_secret

为root用户设置新密码

set password for‘root’@’localhost’=password(‘root’)

Create the Oozie database and Oozie MySQL user.

$ mysql -u root -p
    Enter password: ******
    
    mysql> create database oozie;
    Query OK, 1 row affected (0.03 sec)
    
    mysql>  grant all privileges on oozie.* to 'oozie'@'localhost' identified by 'oozie';
    Query OK, 0 rows affected (0.03 sec)
    
    mysql>  grant all privileges on oozie.* to 'oozie'@'%' identified by 'oozie';
    Query OK, 0 rows affected (0.03 sec)
    
    mysql> exit
    Bye