环境:
vmware workstation 10.0.1 build-1379776
OS: ubuntu desktop 18.04
mysql: 5.7.22
# 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
# 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
选择如下:
Select Version: 5.7.22
Select Operating System: Source Code
Select OS Version: Generic Linux (Architecture Indepedent)
最后下载的文件名为 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
# /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 root@localhost: o5:Alc3UliKF
使用上面找到的临时密码连接进MySQL,并修改密码:
# /mysql/bin/mysql -u root -p
mysql> alter user 'root'@'localhost' identified by 'mypasswd';
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
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
# apt-get update
# apt-get install -y build-essential
===========
参考资料:
https://blog.csdn.net/liantian_wu/article/details/79427522
《MySQL运维内参》
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=mysql7. 启动数据库
和初始化数据库的差别在于少了一个 --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 root@localhost: 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
# stopmysqlShutting 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运维内参》