基础环境搭建-mysql数据库源码搭建

1. 下载源码包：https://dev.mysql.com/downloads/mysql/

2. 官网安装教程：官网链接

   1. groupadd mysql 创建用户组

   2. useradd -r -g mysql -s /bin/false mysql 创建Mysql用户组下的mysql系统账号, 主要是为了系统安全

   3. tar -xzvf mysql-VERSION.tar.gz

   4. cd mysql-VERSION

   5. mkdir bld

   6. cd bld

   7. cmake .. (-DDOWNLOAD_BOOST=1 -DWITH_BOOST=./)
      这里可能 会报错，需要cmake3，可以在https://cmake.org/files/v3.10/ 进行下载相应安装包

      1. export CMAKE_HOME=/opt/cmake-3.10.2-Linux-x86_64
      2. export PATH=$PATH:$CMAKE_HOME/bin
         cmake可能需要安装依赖：

      lib64mpfr1-2.4.2-2mdv2010.1.x86_64.rpm
      gmp-devel-4.1.4-12.3_2.el5.x86_64.rpm
      compat-libgmp-4.3.1-1.sl7.x86_64.rpm

      1. 报错：GCC 5.3 or newer is required (-dumpversion says 4.8.5)
         解决：
         1. 添加scl源：yum install centos-release-scl scl-utils-build
         2, 安装gcc：yum install devtoolset-4-gcc.x86_64 devtoolset-4-gcc-c++.x86_64 devtoolset-4-gcc-gdb-plugin.x86_64
         3. export CC=/opt/rh/devtoolset-4/root/usr/bin/gcc export
         4. CPP=/opt/rh/devtoolset-4/root/usr/bin/cpp export
         5. CXX=/opt/rh/devtoolset-4/root/usr/bin/c++
         6. ln -s /opt/rh/devtoolset-4/root/usr/bin/* /usr/local/bin/
         7. hash -r
      2. 报错: Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH)
         1. yum install ncurses-devel

   8. make
      1.报错：g++: internal compiler error: Killed (program cc1plus)
      Please submit a full bug report
      解决: 主要原因大体上是因为内存不足
      创建交换分区 并 开启
      dd if=/dev/zero of=/swapfile bs=64M count=16
      mkswap /swapfile
      swapon /swapfile
      关闭交换分区
      swapoff /swapfile
      rm /swapfile

   9. make install

   ========== 源码编译安装完成 下面进行数据库配置 ==========
   10. cd /usr/local/mysql
   11. mkdir mysql-files
   12. chown mysql:mysql mysql-files
   13. chmod 750 mysql-files
   14. bin/mysqld --initialize --user=mysql # 这里会显示初始化得root密码,要记住哦
   15. bin/mysql_ssl_rsa_setup
   16. bin/mysqld_safe --user=mysql
   17. cp support-files/mysql.server /etc/init.d/mysql.server
   18. 登录mysql 初始化密码

     1. sudo service mysql.service start 
        # 如果启动失败, 请查看以下路径得所有人是否是mysql:mysql
        1) /var/lib/mysql/
        2) /var/log/mariadb
        3) /var/log/mariadb/mariadb.log
     2. mysql -uroot -p******** -h127.0.0.1
     3. alter user 'root'@'localhost' identified by '111111';