mysql源碼包安裝的方法：首先上傳或下載源碼包，并安裝依賴；然后解壓安裝包，并生成；接著編譯和安裝、做軟連接、創(chuàng)建用戶、拷貝配置文件和啟動腳本、初始化數(shù)據(jù)庫等等；最后啟動數(shù)據(jù)庫和配置環(huán)境變量，并確認啟動即可。
更多相關(guān)免費學習推薦：mysql教程(視頻)
mysql源碼包安裝的方法：
源碼包安裝
1）上傳或下載源碼包
[root@db02?~]#?rz?mysql-5.6.46.tar.gz
2）安裝依賴
由于安裝環(huán)境的不同，在生成的過程中可能也會報其它的錯誤，按照錯誤的提示安裝相應的依耐包即可。
[root@db02?~]#?yum?install?-y?ncurses-devel?libaio-devel?gcc?gcc-c++?glibc?cmake?autoconf?openssl?openssl-devel
3）解壓安裝包
[root@db02?~]#?tar?xf?mysql-5.6.46.tar.gz
4）生成
[root@db02?~]#?cd?mysql-5.6.46/ [root@db02?mysql-5.6.46]#?cmake?.?-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.6.46? -DMYSQL_DATADIR=/usr/local/mysql-5.6.46/data? -DMYSQL_UNIX_ADDR=/usr/local/mysql-5.6.46/tmp/mysql.sock? -DDEFAULT_CHARSET=utf8? -DDEFAULT_COLLATION=utf8_general_ci? -DWITH_EXTRA_CHARSETS=all? -DWITH_INNOBASE_STORAGE_ENGINE=1? -DWITH_FEDERATED_STORAGE_ENGINE=1? -DWITH_BLACKHOLE_STORAGE_ENGINE=1? -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1? -DWITH_ZLIB=bundled? -DWITH_SSL=system? -DENABLED_LOCAL_INFILE=1? -DWITH_EMBEDDED_SERVER=1? -DENABLE_DOWNLOADS=1? -DWITH_DEBUG=0
5）編譯和安裝
[root@db02?mysql-5.6.46]#?make?&&?make?install
6）做軟連接
[root@db02?~]#?ln?-s?/usr/local/mysql-5.6.46?/usr/local/mysql
7）創(chuàng)建用戶
[root@db02?~]#?useradd?mysql?-s?/sbin/nologin?-M
8）拷貝配置文件和啟動腳本
[root@db02?~]#?cd?/usr/local/mysql/support-files/ [root@db02?support-files]#?cp?my-default.cnf?/etc/my.cnf cp:?overwrite?'/etc/my.cnf'??y [root@db02?support-files]#?cp?mysql.server?/etc/init.d/mysqld
9）初始化數(shù)據(jù)庫
[root@db02?support-files]#?cd?/usr/local/mysql/scripts/ [root@db02?scripts]#?./mysql_install_db?--user=mysql?--basedir=/usr/local/mysql?--datadir=/usr/local/mysql/data
8）配置system管理mysql
[root@db02?scripts]#?vim?/usr/lib/systemd/system/mysqld.service [Unit] Description=MySQL?Server Documentation=man:mysqld(8) Documentation=https://dev.mysql.com/doc/refman/en/using-systemd.html After=network.target After=syslog.target [Install] WantedBy=multi-user.target [Service] User=mysql Group=mysql ExecStart=/usr/local/bin/mysqld?--defaults-file=/etc/my.cnf LimitNOFILE?=?5000 [root@db02?scripts]#?systemctl?daemon-reload [root@db02?scripts]#?systemctl?start?mysqld
9）啟動失敗報錯
[root@db02?scripts]#?/etc/init.d/mysqld?start Starting?MySQL.Logging?to?'/usr/local/mysql-5.6.46/data/db02.err'. 200709?15:42:14?mysqld_safe?Directory?'/usr/local/mysql-5.6.46/tmp'?for?UNIX?socket?file?don't?exists. ?ERROR!?The?server?quit?without?updating?PID?file?(/usr/local/mysql-5.6.46/data/db02.pid). ? #原因： 1.cmake過程指定了socket文件位置，實際位置不存在 2.目錄權(quán)限不足 ? #解決： [root@db02?scripts]#?mkdir?/usr/local/mysql-5.6.46/tmp/ [root@db02?scripts]#?chown?-R?mysql.mysql?/usr/local/mysql [root@db02?scripts]#?chown?-R?mysql.mysql?/usr/local/mysql-5.6.46/
10）啟動數(shù)據(jù)庫
[root@db02?scripts]#?systemctl?start?mysqld
11）配置環(huán)境變量
[root@db03?scripts]#?vim?/etc/profile.d/mysql.sh export?PATH=/usr/local/mysql/bin:$PATH [root@db03?mysql]#?source?/etc/profile
12）確認啟動
[root@m01?scripts]#?ps?-ef?|?grep?mysql mysql?????12886??????1??2?03:10??????????00:00:00?/usr/local/mysql/bin/mysqld?--defaults-file=/etc/my.cnf root??????12921??10636??0?03:11?pts/1????00:00:00?grep?--color=auto?mysql [root@m01?scripts]#?netstat?-lntp??? tcp6???????0??????0?:::3306?????????????????:::*????????????????????LISTEN??????12886/mysqld
? 版權(quán)聲明
文章版權(quán)歸作者所有，未經(jīng)允許請勿轉(zhuǎn)載。
THE END
喜歡就支持一下吧
相關(guān)推薦
