Mysql5.7.15 Linux 安装教程

1上传安装包并解压到指定位置

santiago@slave2:~$ df -h   先查看磁盘使用情况


santiago@slave2:~$  sudo tar -zxf mysql-5.7.15-linux-glibc2.5-x86_64.tar.gz -C /usr/local

重命名

santiago@slave2: /usr/local$ sudo mv mysql-5.7.15-linux-glibc2.5-x86_64 mysql

2创建数据仓库


santiago@slave2:~$ mkdir data


santiago@slave2:~/data$ mkdir mysql


3 创建mysql组和用户，并更改mysql的所属组和用户


santiago@slave2:~$ groupadd mysql


santiago@slave2:~$ useradd -r -g mysql mysql


santiago@slave2:/usr/local$ sudo chown -R mysql:mysql mysql

4安装和初始化数据库


santiago@slave2:/usr/local/mysql$


bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/home/santiago/data/mysql

备注：

--user  启动mysql的用户

 --basedir  mysql安装目录

 --datadir  mysql数据仓库目录

显示临时密码


ZF%a)qod)9*w


 


santiago@slave2:/usr/local/mysql$ bin/mysql_ssl_rsa_setup --datadir=/home/santiago/data/mysql


 


5修改配置文件 ，mysql5.7配置文件需要修改my.cnf关键配置， mysql5.7之前默认配置文件中是有配置项的，不用手动修改


santiago@slave2:/usr/local/mysql/support-files$ ls


santiago@slave2:/usr/local/mysql/support-files$


sudo cp my-default.cnf /etc/my.cnf

 
并且修改以下内容

 
vim /etc/my.cnf


basedir =/usr/local/mysql


datadir =/home/santiago/data/mysql


port = 3306


socket =/tmp/mysql.sock

将mysqld服务加入开机自启动项,并修改mysql

cp mysql.server /etc/init.d/mysql

chmod +x /etc/init.d/mysql 
chkconfig --add mysql

chkconfig --list mysql

vi /etc/ini..d/mysql

basedir=/usr/local/mysql
datadir=/home/santiago/data/mysql

6启动Mysql


santiago@slave2:/usr/local/mysql$ bin/mysqld_safe --user=mysql &


santiago@slave2:/usr/local/mysql$ bin/mysql --user=root –p


 


但是报错进不去，于是更改初始密码


santiago@slave2:/etc/init.d$ mysql stop


santiago@slave2:/usr/local/mysql/bin$ mysqld_safe --user=mysql --skip-grant-tables --skip-networking &


santiago@slave2:/usr/local/mysql/bin$ mysql -u root mysql


 进入 mysql


mysql> update mysql.user set authentication_string=password('123') where user='root' and Host ='localhost';


mysql> FLUSH PRIVILEGES; 重载权限表


mysql> quit


 


重启mysql


santiago@slave2:/etc/init.d$ mysql restart


santiago@slave2:/usr/local/mysql/bin$ mysql -uroot -p


Enter password: <输入新设的密码newpassword>


键入  123


 成功


但是继续操作的时候仍需要密码登录


mysql> show databases;


ERROR 1820 (HY000): You must SET PASSWORD before executing this statement


mysql> SET PASSWORD = PASSWORD('123');


Query OK, 0 rows affected (0.03 sec)


 mysql> show databases;


Query OK, 1 row affected (0.00 sec)


 


到此Mysql 搭建成功