Cmake MySQL5.6 编译安装

╰半橙微兮° 2022-08-19 01:43 179阅读 0赞

进入MySQL5.5以后，MySQL的安装都变成了用Cmake来安装了。

一：准备工作

cd /usr/local/src/

在当前目录下准备好安装包，

cmake-3.0.2.tar.gz  [ 下载][Link 1]

mysql-5.6.20.tar.gz  [ 下载][Link 2]

二：安装

\#cmake  
    tar -zxvf cmake-3.0.2.tar.gz  
    cd cmake-3.0.2  
    ./bootstrap  
    gmake  
    gmake install

\#mysql  
    tar zxvf mysql-5.6.20.tar.gz    
    cd mysql-5.6.20   
    cmake \\    
    -DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql \\    
    -DMYSQL\_DATADIR=/usr/local/mysql/data \\    
    -DSYSCONFDIR=/etc \\    
    -DWITH\_MYISAM\_STORAGE\_ENGINE=1 \\    
    -DWITH\_INNOBASE\_STORAGE\_ENGINE=1 \\   
    -DWITH\_PARTITION\_STORAGE\_ENGINE=1 \\  
    -DMYSQL\_UNIX\_ADDR=/var/lib/mysql/mysql.sock \\    
    -DMYSQL\_TCP\_PORT=3306 \\    
    -DENABLED\_LOCAL\_INFILE=1 \\    
    -DEXTRA\_CHARSETS=all \\    
    -DDEFAULT\_CHARSET=utf8 \\    
    -DDEFAULT\_COLLATION=utf8\_general\_ci

详细参数请查看官网说明，[地址][Link 3]

make && make install  
    \#生成配置文件  
    cd support-files  
    cp my-default.cnf /etc/my.cnf

groupadd mysql    
    useradd -M -s /sbin/nologin -g mysql mysql    
    chown -R mysql:mysql /usr/local/mysql    
    cd /usr/local/mysql  
    \#初始化数据库  
    scripts/mysql\_install\_db --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

\#添加服务，拷贝服务脚本到init.d目录，并设置开机启动    
    cp support-files/mysql.server /etc/init.d/mysqld    
    chkconfig mysqld on    
    \#启动MySQL    
    service mysqld start

\#更改密码  
    /usr/local/mysql/bin/mysqladmin -u root password 123456  
    \#测试连接mysql  
    /usr/local/mysql/bin/mysql -u root -p

修改/etc/profile文件，在文件末尾添加    
    vi /etc/profile    
    PATH=/usr/local/mysql/bin:$PATH    
    export PATH    
  
    source /etc/profile

\#修改密码    
    mysql -uroot    
    mysql> SET PASSWORD = PASSWORD('123456');    
    mysql> GRANT ALL PRIVILEGES ON \*.\* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

<table> 
 <tbody> 
  <tr> 
   <td>Directory</td> 
   <td>Contents of Directory</td> 
  </tr> 
  <tr> 
   <td><code>bin</code>, <code>scripts</code></td> 
   <td>mysqld server, client and utility programs</td> 
  </tr> 
  <tr> 
   <td><code>data</code></td> 
   <td>Log files, databases</td> 
  </tr> 
  <tr> 
   <td><code>docs</code></td> 
   <td>MySQL manual in Info format</td> 
  </tr> 
  <tr> 
   <td><code>man</code></td> 
   <td>Unix manual pages</td> 
  </tr> 
  <tr> 
   <td><code>include</code></td> 
   <td>Include (header) files</td> 
  </tr> 
  <tr> 
   <td><code>lib</code></td> 
   <td>Libraries</td> 
  </tr> 
  <tr> 
   <td><code>share</code></td> 
   <td>Miscellaneous support files, including error messages, sample configuration files, SQL for database installation</td> 
  </tr> 
  <tr> 
   <td><code>sql-bench</code></td> 
   <td>Benchmarks</td> 
  </tr> 
 </tbody> 
</table>

[Link 1]: http://download.csdn.net/detail/uvyoaa/9383718
[Link 2]: http://download.csdn.net/detail/uvyoaa/8045853
[Link 3]: http://dev.mysql.com/doc/refman/5.6/en/source-configuration-options.html