mysql源碼包安裝(適用於多個mysql)

標籤：art   pad   option   使用者和組   etc   編譯   inno   dir   下載   

1.安裝編譯代碼需要的包:yum list|grep ncurses-develyum -y install make gcc-c++ cmake bison-devel ncurses-devel 2.下載MySQL 5.6.35wget https://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.35.tar.gztar zxvf mysql-5.6.35.tar.gzcd mysql-5.6.35 3.目錄建立(-p父目錄不存在則建立此目錄)mkdir -p /usr/local/mysql/data 4.編譯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=/usr/local/mysql/mysql.sock \-DMYSQL_TCP_PORT=3307 \-DENABLED_LOCAL_INFILE=1 \-DWITH_PARTITION_STORAGE_ENGINE=1 \-DEXTRA_CHARSETS=all \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci5.安裝make && make installmake clean 6.設定許可權查看是否有mysql使用者及使用者組cat /etc/passwdcat /etc/group如果沒有就添加mysql使用者和組groupadd mysqluseradd -g mysql mysql修改/usr/local/mysql許可權chown -R mysql:mysql /usr/local/mysql 7.初始化配置cd /usr/local/mysql執行初始化配置指令碼，建立系統內建的資料庫和表scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysqlcp /usr/local/mysql/support-files my.cnf 8.啟動資料庫啟動的時候需要指定my.cnf(系統預設會先尋找/etc/my.cnf)/usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/my.cnf --user=mysql & 9.修改資料庫密碼/usr/local/mysql3307/bin/mysql -urootSET PASSWORD = PASSWORD(‘bbgolden‘);GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘bbgolden‘ WITH GRANT OPTION;flush privileges;                

mysql源碼包安裝(適用於多個mysql)