環境:
vmware workstation 10.0.1 build-1379776
OS: ubuntu desktop 18.04
mysql: 5.7.22
1. 下載下傳并安裝linux
選擇的是ubuntu桌面版,下載下傳位址自行百度,下載下傳檔案名為 ubuntu-18.04-desktop-amd64.iso,之後在vmware裡安裝
2. 安裝必要的軟體和包
//vm-tools的目的是使ubuntu可以在vmware下全屏:
# apt-get update
# apt-get install open-vm-tools
# apt-get install open-vm*
# apt-get install openssh-server
# apt-get install net-tools
# apt-get install cmake
# apt-get install libncurses5-dev
# apt-get install bison
# apt-get install libaio-dev
# apt-get install -y build-essential
3. 新增使用者及所需目錄、檔案
# groupadd -g 651 mysqlg
# useradd -b /home/ -g mysqlg -m -u 651 mysql
# mkdir -p /mysql
# mkdir -p /mysql/mysqldata
# vi /mysql/my.cnf
[mysqld]
port=3306
datadir=/mysql/mysqldata
log_error=/mysql/mysqldata/error.log
basedir=/mysql
# chown -R mysql:mysqlg /mysql
4. 下載下傳MySQL linux版的源碼
下載下傳位址為 https://dev.mysql.com/downloads/mysql/5.7.html#downloads
選擇如下:
Select Version: 5.7.22
Select Operating System: Source Code
Select OS Version: Generic Linux (Architecture Indepedent)
最後下載下傳的檔案名為 mysql-boost-5.7.22.tar.gzip
5. 解壓并安裝MySQL
# tar -zxvf mysql-boost-5.7.22.tar.gzip
# cd mysql-5.7.22/
# cmake . -DCMAKE_INSTALL_PREFIX=/mysql \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_BOOST=./boost \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_DEBUG=1
# make -j 4
# make install
6. 初始化資料庫
# /mysql/bin/mysqld --defaults-file=/mysql/my.cnf --initialize --user=mysql
7. 啟動資料庫
和初始化資料庫的差别在于少了一個 --initialize 選項
# /mysql/bin/mysqld --defaults-file=/mysql/my.cnf --user=mysql &
# cat /mysql/mysqldata/error.log | grep -i password
2018-06-20T02:23:29.345054Z 1 [Note] A temporary password is generated for [email protected]: o5:Alc3UliKF
使用上面找到的臨時密碼連接配接進MySQL,并修改密碼:
# /mysql/bin/mysql -u root -p
mysql> alter user 'root'@'localhost' identified by 'mypasswd';
8. 設定環境變量(非必需)
在HOME目錄中的.profile檔案中添加以下内容:
alias startmysql="/mysql/bin/mysqld --defaults-file=/mysql/my.cnf --user=mysql &"
alias stopmysql="/mysql/support-files/mysql.server stop"
export PATH=$PATH:/mysql/bin
9. 使用别名啟停MySQL
# stopmysql
Shutting down MySQL
.. *
[1]+ Done /mysql/bin/mysqld --defaults-file=/mysql/my.cnf --user=mysql
# startmysql
[1] 21181
# stopmysql
Shutting down MySQL
.. *
[1]+ Done /mysql/bin/mysqld --defaults-file=/mysql/my.cnf --user=mysql
出現的問題及解決:
===========
CMake曾遇到以下錯誤:
CMake Error at CMakeLists.txt:126 (PROJECT):
No CMAKE_CXX_COMPILER could be found.
Tell CMake where to find the compiler by setting either the environment
variable "CXX" or the CMake cache entry CMAKE_CXX_COMPILER to the full path
to the compiler, or to the compiler name if it is in the PATH.
使用的下面的指令解決的
# apt-get update
# apt-get install -y build-essential
===========
參考資料:
https://blog.csdn.net/liantian_wu/article/details/79427522
《MySQL運維内參》