Mysql5.7.15 Linux 安装教程

小灰灰 2022-06-16 21:13 98阅读 0赞

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