centos7 php开发环境安装-mysql教程

MySQL安装

1.安装cmake(作为mysql的安装工具)

tar -zxvf cmake-3.8.0.tar.gz

cd cmake-3.8.0

./bootstrap

gmake

gmake install

2.安装boost\_1\_59\_0

tar -zxvf boost\_1\_59\_0.tar.gz

cd boost\_1\_59\_0

./bootstrap.sh

./b2

./b2 install

3.创建用户、配置目录

添加mysql用户和所属组

/usr/sbin/groupadd mysql

/usr/sbin/useradd -g mysql mysql

创建mysql安装目录和数据目录

mkdir /usr/local/mysql

mkdir /usr/local/mysql/data

修改mysql目录所有者

chown -R mysql:mysql /usr/local/mysql

4.安装mysql

tar -zxvf mysql-5.7.14.tar.gz

cd mysql-5.7.14

以下复制到文本中

cmake . -DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql -DMYSQL\_DATADIR=/usr/local/mysql/data -DDOWNLOAD\_BOOST=1 -DWITH\_BOOST=/usr/local/src/boost\_1\_59\_0 -DMYSQL\_UNIX\_ADDR=/usr/local/mysql/tmp/mysql.sock -DDEFAULT\_CHARSET=utf8 -DDEFAULT\_COLLATION=utf8\_general\_ci -DENABLED\_LOCAL\_INFILE=ON -DWITH\_INNOBASE\_STORAGE\_ENGINE=1 -DWITH\_FEDERATED\_STORAGE\_ENGINE=1 -DWITH\_BLACKHOLE\_STORAGE\_ENGINE=1 -DWITHOUT\_EXAMPLE\_STORAGE\_ENGINE=1 -DWITHOUT\_PARTITION\_STORAGE\_ENGINE=1 -DWITH\_FAST\_MUTEXES=1 -DWITH\_ZLIB=bundled -DENABLED\_LOCAL\_INFILE=1 -DWITH\_READLINE=1 -DWITH\_EMBEDDED\_SERVER=1 -DWITH\_DEBUG=0

make

make install

5.mysql安装失败重新编译时，需要清除旧的对象文件和缓存信息

make clean

rm -f CMakeCache.txt

rm -rf /etc/my.cnf

6.配置mysql并初始化数据库

配置文件：

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

初始化数据库:

./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

启动mysql数据库

/usr/local/mysql/bin/mysqld\_safe -defaults-file=/etc/my.cnf -basedir=/usr/local/mysql --datadir=/usr/local/mysql/data -user=mysql & ./--mysqld\_safe --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql &

查看是否启动

ps -ef | grep mysqld

建立软链接：

ln -s /usr/local/mysql/bin/mysql /usr/bin

7.修改初始化密码

mysql -u root -p

Set password = password('xxx');

Alter user 'root'@'localhost' password expire never;

grant all privileges on *.* to root@'%' identified by 'xxx';

grant all privileges on *.* to 'root'@'%' identified by 'xxx' with grant option;

Flush privileges;

8.开机启动

1. touch /usr/lib/systemd/system/mysql.service

2.设置内容

<pre class="brush:csharp;gutter:true;">[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://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/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
#Restart=on-failure
#RestartPreventExitStatus=1
#PrivateTmp=false

9.操作

systemctl start mysql

systemctl stop mysql

systemctl restart mysql

systemctl disable mysql

systemctl enable mysql

systemctl status mysql