linux下源码安装mysql-优快云博客

本文详细介绍了如何在本地系统上安装、配置并启动MySQL数据库，包括下载源码包、编译、初始化配置、启动MySQL服务、创建用户和数据库等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.安装依赖

 
   
        yum
        
        -
        y
        
        install  
        gcc 
        gcc
        -
        c
        ++
        
        gcc
        -
        g77 
        autoconf 
        automake 
        zlib
        *
        
        fiex
        *
        
        libxml
        *
        
        ncurses
        -
        devel 
        libmcrypt
        *
        
        libtool
        -
        ltdl
        -
        devel
        *
        
        make 
        cmake
       
 
 

2.下载mysql源码包
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.25.tar.gz

tar -zxvf mysql-5.6.25.tar.gz

3.添加用户组

groupadd mysql

useradd -r -g mysql mysql

4.编译

cd mysql-5.6.25

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_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

make&&make install

5.修改/usr/local/mysql权限

chown -R mysql:mysql /usr/local/mysql

6. 初始化配置

cd /usr/local/mysql

scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

7.启动MySQL

cp support-files/mysql.server /etc/init.d/mysql
chkconfig mysql on
service mysql start --启动MySQL
8.配置用户

PATH=/usr/local/mysql/bin:$PATH
export PATH
source /etc/profile
mysql -uroot
mysql> SET PASSWORD = PASSWORD('app01fx');
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'app01fx' WITH GRANT OPTION;

8.配置防火墙

vi /etc/sysconfig/iptables
在“-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 –j ACCEPT”，下添加：

-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT;

然后保存，并关闭该文件，在终端内运行下面的命令，刷新防火墙配置：

service iptables restart

mysql -uroot -papp01fx

9.创建数据库

create user 'transcloud'@'%' identified by 'ctfocloud';

CREATE DATABASE transcloud DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON transcloud.* TO 'transcloud'@'%' IDENTIFIED BY 'ctfocloud';
SET PASSWORD FOR 'transcloud'@'%' = OLD_PASSWORD('ctfocloud');