Linux下安装mysql

oracle官网下载mysql-5.7.15-linux-glibc2.5-x86_64.tar.gz,需要登录,没有账号先注册。

安装目录尽量放在/usr/local/mysql下,因为MySQL启动脚本默认的也是这个目录。

将安装包移动到/usr/local

解压:

tar xvf mysql-5.7.15-linux-glibc2.5-x86_64.tar.gz

将解压后的文件夹重命名为mysql:

mv mysql-5.7.15-linux-glibc2.5-x86_64 mysql

[root@iZ25xf935m3Z mysql]# pwd
/usr/local/mysql
[root@iZ25xf935m3Z mysql]# ls
bin  COPYING  docs  include  lib  man  README  share  support-files
//创建数据仓库,将数据存放在/data/mysql目录中:
[root@iZ25xf935m3Z mysql]# mkdir /data
[root@iZ25xf935m3Z mysql]# mkdir /data/mysql

增加用户组mysql:

[root@iZ25xf935m3Z mysql]# groupadd mysql

为MySQL创建单独用户mysql,设置不能登录Linux系统,并把/usr/local/mysql分配给mysql组的mysql:

[root@iZ25xf935m3Z mysql]# useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql
授权:
[root@iZ25xf935m3Z mysql]# chown -R mysql .
[root@iZ25xf935m3Z mysql]# chgrp -R mysql .

数据仓库同样授权:

chown -R mysql /data/mysql

初始化并获得初始root密码:

[root@iZ25xf935m3Z usr]# cd mysql
[root@iZ25xf935m3Z mysql]# bin/mysqld --initialize --user=mysql --basedir=/usr/mysql --datadir=/data/mysql
2016-09-13T09:29:58.455618Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-09-13T09:30:00.539528Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-09-13T09:30:00.796729Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-09-13T09:30:00.876881Z 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: a4d2a8d4-7994-11e6-a1a1-00163e0a06f0.
2016-09-13T09:30:00.879300Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-09-13T09:30:00.880010Z 1 [Note] A temporary password is generated for root@localhost: Z68kTLj(6l6_

安全设置:

[root@iZ25xf935m3Z mysql]# bin/mysql_ssl_rsa_setup  --datadir=/data/mysql
Generating a 2048 bit RSA private key
....................................................................+++
.....................+++
writing new private key to 'ca-key.pem'
-----
Generating a 2048 bit RSA private key
.......................................................................................................................+++
.......................+++
writing new private key to 'server-key.pem'
-----
Generating a 2048 bit RSA private key
...............................+++
.................+++
writing new private key to 'client-key.pem'
-----
修改系统配置文件

[root@iZ25xf935m3Z mysql]# cd support-files/
[root@iZ25xf935m3Z support-files]# ls
magic  my-default.cnf  mysqld_multi.server  mysql-log-rotate  mysql.server
[root@iZ25xf935m3Z support-files]# cp my-default.cnf /etc/my.cnf
cp: overwrite `/etc/my.cnf'? y
[root@iZ25xf935m3Z support-files]# cp mysql.server /etc/init.d/mysql

vim /etc/init.d/mysql

vim /etc/my.cnf

后台启动MySQL:

[root@iZ25xf935m3Z mysql]# bin/mysqld_safe --user=mysql &

客户端连接:

bin/mysql --user=root –p
--输入上面生成的临时密码

修改root密码:

mysql> set password=password('A123456');

授权给root:

mysql>grant all privileges on *.* to root@'%' identified by 'A123456';
mysql> flush privileges;


添加系统路径
# vim /etc/profile
添加:
export PATH=/usr/local/mysql/bin:$PATH

source /etc/profile


配置mysql自动启动
# chmod 755 /etc/init.d/mysql
# chkconfig --add mysql
# chkconfig --level 345 mysql on


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值