Mysql5.7.15 Linux 安装教程

Mysql 5.7.15 Linux 安装教程

 

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

santiago@slave2:~$ rz

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

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

 

显示临时密码

ZF%a)qod)9*w

 

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

 

5修改配置文件

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

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

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

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

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

 

并且修改以下内容

vim /etc/init.d/mysql

basedir=/usr/lcoal/mysql

datadir=/home/santiago/data/mysql

 

vim /etc/my.cnf

basedir =/usr/local/mysql

datadir =/home/santiago/data/mysql

port = 3306

socket =/tmp/mysql.sock

 

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 搭建成功

 

参考

http://www.111cn.net/database/mysql/44142.htm

http://blog.sina.com.cn/s/blog_7d553bb50102w9rb.html

http://blog.csdn.net/wb96a1007/article/details/51559741

http://www.jb51.net/article/90317.htm