Mysql安装步骤(1)源码编译

青旅半醒 2022-06-07 00:10 294阅读 0赞

# #

## 一、准备文件 ##

mysql-5.6.31.tar.gz

[下载链接][Link 1]

## 二、编译 ##

**0、**依赖

yum install -y glibc.i686
    yum install -y gcc gcc-c++
    yum install -y cmake
    yum install -y ncurses-devel
    yum install -y bison
    yum install -y perl perl-devel
    yum install -y autoconf

**1、解压源码包mysql-5.6.31.tar.gz**

$ tar -zxvf mysql-5.6.31.tar.gz

**2、设置参数，这一步需要自定义mysql的安装路径**

$ mkdir /home/sun_zeming/mysql/mysql-3
    $ cd mysql-5.6.31/
    $ cmake -DCMAKE_INSTALL_PREFIX=/home/sun_zeming/mysql/mysql-3 -DMYSQL_DATADIR=/home/sun_zeming/mysql/mysql-3/data -DSYSCONFDIR=/home/sun_zeming/mysql/mysql-3/conf -DMYSQL_UNIX_ADDR=/home/sun_zeming/mysql/mysql-3/mysql.sock -DMYSQL_TCP_PORT=6660 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

**3、 编译**

$ make & make install

## 三、MySQL安装 ##

**1、进入mysql的安装路径**

$ cd /home/sun_zeming/mysql/mysql-3

**2、复制默认配置文件**

$ cp support-files/my-default.cnf ./my.cnf

**3、修改配置文件my.cnf**

basedir = /home/sun_zeming/mysql/mysql-3
    datadir = /home/sun_zeming/mysql/mysql-3/datadir
    port = 6660
    # server_id = .....
    socket = /home/sun_zeming/mysql/mysql-3/mysql.sock

**4、安装mysql**

$ ./scripts/mysql_install_db --user=root --defaults-file=/home/sun_zeming/mysql/mysql-3/my.cnf

## 四、启动MySQL ##

普通用户启动

$ ./bin/mysqld --defaults-file=/home/sun_zeming/mysql/mysql-3/my.cnf

root用户启动

$ ./bin/mysqld --defaults-file=/home/sun_zeming/mysql/mysql-3/my.cnf --user=root

## 五、MySQL授权 ##

**1、设置root用户密码**

$ ./bin/mysqladmin -u root password "123456"

**2、登录mysql**

$ ./bin/mysql -uroot -p123456 -P6660