linux搭建mysql-5.6.31详细步骤

43 阅读1分钟

一、先装cmake

tar zxvf cmake-2.8.10.2.tar.gz 

cd cmake-2.8.10.2

./bootstrap 

make && make install

groupadd mysql

useradd -r -g mysql mysql

mkdir -p /usr/local/webserver/mysql/data   ####创建存放mysql数据的目录

注意:cmake需要系统先安装gcc和gcc-c++

yum -y install gcc

yum -y install gcc-c++

二、安装mysql

tar zxvf mysql-5.6.31.tar.gz

cd mysql-5.6.31

cmake \-DCMAKE_INSTALL_PREFIX=/usr/local/webserver/mysql \-DMYSQL_DATADIR=/usr/local/webserver/mysql/data \-DSYSCONFDIR=/usr/local/webserver/mysql/ \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1  \-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \-DMYSQL_TCP_PORT=3306 \-DENABLED_LOCAL_INFILE=1 \-DWITH_PARTITION_STORAGE_ENGINE=1 \-DEXTRA_CHARSETS=all \-DDEFAULT_CHARSET=utf8mb4 \-DDEFAULT_COLLATION=utf8mb4_general_ci

make && make install

cp /usr/local/webserver/mysql/support-files/my-default.cnf /etc/my.cnf

cp /usr/local/webserver/mysql/support-files/mysql.server /etc/init.d/mysqld

chmod -R 755 /etc/init.d/mysqld

cd /usr/local/webserver/mysql/scripts

./mysql_install_db --user=mysql --basedir=/usr/local/webserver/mysql/ --datadir=/usr/local/webserver/mysql/data/

service mysqld start

三、数据库初始化

cd /usr/local/webserver/mysql/
chown mysql:mysql -R .
chown -R root .
chown -R mysql data
mkdir run
chown -R mysql ./run
./scripts/mysql_install_db --user=mysql --basedir=/usr/local/webserver/mysql --datadir=/usr/local/webserver/mysql/data/

cp support-files/my-default.cnf /etc/my.cnf
vim /etc/my.cnf  清空 然后把以下复制进去
[mysqld]
user=mysql
explicit_defaults_for_timestamp=true
federated
read_only=off

bin/mysqld_safe --user=mysql & 运行敲回车 没有Done说明成功了
设置密码./bin/mysqladmin -uroot password '123456'
/usr/local/webserver/mysql/bin/mysql -uroot -p
问题:-bash: mysql: command not found
解决: ln -s /usr/local/webserver/mysql/bin/mysql /usr/bin

-------------------------------------问题解决---------------------------------------------

一、如果执行cmake命令的时候遇到报错:Curses library not found. Please install appropriate package

解决办法:

rm CMakeCache.txt
yum install ncurses-devel

二、如果./scripts/mysql_install_db --user=mysql --basedir=/usr/local/webserver/mysql

报错ATAL ERROR: please install the following Perl modules before executing

解决办法:

yum -y install autoconf