MYSQL学习篇之002-LINUX环境MYSQL源代码安装第二个MYSQL总结

来源：互联网发布：ubuntu安装百度输入法编辑：程序博客网时间：2024/05/16 03:40

在同一台电脑上安装第二个MYSQL，与第一个有一些不同，需要做以下工作
1 创建第三个MYSQL的安装路径 /usr/local/mysql2
2 预编译
3 编译
4 配置
5 起动
6 登录

1 创建安装目录

   # mkdir -p /usr/local/mysql2
   # mkdir -p /usr/local/mysql2/data
   # chown mysql:mysql -R /usr/local/mysql2

2 预编译
2.1 删除掉原来编译用的源代码，重新解压源代码
2.2 预编译
       cmake ../mysql-server/ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql2 -DMYSQL_DATADIR=/usr/local/mysql2/data -DMYSQL_TCP_PORT=3307 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock2
3 编译
   make
   make install

4 配置
4.1 初始化数据库
       scripts/mysql_install_db --basedir=/usr/local/mysql2 --datadir=/usr/local/mysql2/data --user=mysql
4.2 编辑配置文件 /usr/local/mysql2/my.cnf ,增加以下内容：
           basedir = /usr/local/mysql2
           datadir = /usr/local/mysql2/data
           port = 3307
           server_id = 11
           socket = /tmp/mysql2.sock

           [mysqld_safe]
           pid-file=/usr/local/mysql2/data/mysqld2.pid
4.3 创建链接文件
   # ln /usr/local/mysql2/my.cnf /etc/my2.cnf

5 起动
   # mysqld_safe --defaults-file=/etc/my2.cnf
       170410 17:54:10 mysqld_safe Logging to '/usr/local/mysql2/data/FZ-Centos-23.err'.
       170410 17:54:10 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql2/data

6 登录
   连接第二个MYSQL,缺省使用 /tmp/mysql.sock ,所以连接第二个MYSQL需要指定 socket ,port
    # mysql -uroot -p --socket=/tmp/mysql2.sock --port=3307
       Enter password:
       Welcome to the MySQL monitor. Commands end with ; or \g.
       Your MySQL connection id is 2
       Server version: 5.6.35 Source distribution

       Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

       Oracle is a registered trademark of Oracle Corporation and/or its
       affiliates. Other names may be trademarks of their respective
       owners.

       Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

       mysql> show databases;
       +--------------------+
       | Database           |
       +--------------------+
       | information_schema |
       | mysql              |
       | performance_schema |
       | test               |
       +--------------------+
       4 rows in set (0.00 sec)

0 0