1.下载:
Wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.19-linux-g libc2.12-x86_64.tar.gz
2.解压:
tar -xzvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz -C /usr/local/ #将 文件解压到指定目录
3.移除安装包
mv mysql-5.7.19-linux-glibc2.12-x86_64 mysql
4.检查库文件是否有删除,若有便删除(linux系统自带的)
rpm -qa | grep mysql
rpm -e –-nodeps mysql-libs-5.1.52.x86_64
rpm -e -nodeps mysql-libs-5.1.73-8.el6_8.x86_64
5.创建mysql组和用户
groupadd mysql
useradd -r -g mysql mysql
6.在mysql下添加data目录
mkdir data
7.更改mysql目录下所有的目录及文件夹所属组合用户
cd /usr/local/
chown -R mysql mysql/
chgrp -R mysql mysql/
cd mysql/
ls -l
8.安装和初始化数据库
./mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --lc_messages_dir=/usr/local/mysql/share --lc_messages=en_US
2017-08-31T09:00:54.941514Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-08-31T09:00:56.364312Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-08-31T09:00:56.602211Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-08-31T09:00:56.668145Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: e69986d2-8e2a-11e7-a335-
005056b427be.2017-08-31T09:00:56.671464Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-08-31T09:00:56.672453Z 1 [Note] A temporary password is generated for root@localhost: qfuqvCsHb2!.
注意初始密码:这里password is generated for root@localhost: qfuqvCsHb2!.
9.配置my.cnf
进入/usr/local/mysql/support-files/目录下
查看是否存在my-default.cnf文件,如果存在直接copy到/cdf文 件中
cp -a ./support-files/my-default.cnf /etc/my.cnf
如果不存在my-default.cnf文件,则在/etc/目录下创建my.cnf,并写 入以下内容
#[mysql]
#basedir=/usr/local/mysql/
#datadir=/usr/local/mysql/data/
10.启动服务:
cd bin/
./mysqld_safe --user=mysql &
Logging to '/var/log/mysql/mysql.log'.
11.查看mysql服务:
ps -ef|grep mysql
12.将mysqld服务加入开机自启动项:
将{mysql}/ support-files/mysql.server 拷贝为/etc/init.d/mysql并设 置运行权限,这样就可以使用service mysql命令启动/停止服务,
否则就只能使用{mysql}/bin/mysqld_safe &命令来启动服务
还需要把mysql.server中basedir的相关路径,改为自定义的路径, 默认路径是/usr/local/mysql
cp mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
-- 把mysql注册为开机启动的服务
chkconfig --add mysql
-- 查看是否添加成功
chkconfig --list mysql
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
13.启动服务:
service mysql start
14.将mysql配置环境:
vi /etc/profile
export PATH=/usr/local/mysql/bin
15.登录mysql:
mysql -uroot -p
密码是第八步产生的密码
quit或者exit退出mysql。
16.设置密码:
set password=password("root");
Query OK, 0 rows affected, 1 warning (0.00 sec)
17.设置远程登录权限:
grant all privileges on *.* to'账号' @'%' identified by '远程登陆密码 ';