linux下mysql 5.7.22 安装

时间:2022-09-23 11:32:29

二进制安装

1.下载https://dev.mysql.com/downloads/mysql/5.6.html#downloads

2.官方文档https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html

[root@localhost local]# yum install libaio
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.aliyun.com
 * extras: mirrors.huaweicloud.com
 * updates: mirrors.aliyun.com
Package libaio-0.3.109-13.el7.x86_64 already installed and latest version
Nothing to do
[root@localhost local]# pwd
/usr/local
[root@localhost local]# tar -zxvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz 
[root@localhost local]# ln -s mysql-5.7.22-linux-glibc2.12-x86_64 mysql
[root@localhost local]groupadd mysql
[root@localhost local] useradd -r -g mysql -s /bin/false mysql
[root@localhost local] chown -R mysql:mysql mysql
[root@localhost local]# cd mysql
[root@localhost mysql]# ll
total 40
drwxr-xr-x.  2 root  root   4096 May 15 03:59 bin
-rw-r--r--.  1  7161 31415 17987 Mar  4 21:40 COPYING
drwxr-x---.  5 mysql mysql  4096 May 15 04:39 data
drwxr-xr-x.  2 root  root     55 May 15 03:59 docs
drwxr-xr-x.  3 root  root   4096 May 15 03:58 include
drwxr-xr-x.  5 root  root    229 May 15 03:59 lib
drwxr-xr-x.  4 root  root     30 May 15 03:59 man
-rw-r--r--.  1  7161 31415  2478 Mar  4 21:40 README
drwxr-xr-x. 28 root  root   4096 May 15 03:59 share
drwxr-xr-x.  2 root  root     90 May 15 03:59 support-files

[root@localhost mysql]bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

  linux下mysql 5.7.22 安装

[root@localhost mysql]# bin/mysql_ssl_rsa_setup  --datadir=/usr/local/mysql/data
[root@localhost mysql]# cd support-files/
[root@localhost support-files]# vi  /etc/my.cnf
[root@localhost mysql]# cat /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql/
datadir=/usr/local/mysql/data/
[root@localhost support-files]# cd ..
[root@localhost mysql]# cd bin/
[root@localhost bin]# ./mysqld_safe --user=mysql &
[1] 2942

  启动完毕

登录,修改root密码  设置远程登录

[root@localhost mysql]# mysql -uroot -p 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.22

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set password=password("root");
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update  user  set host='%' where user='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY '......' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> FLUSH PRIVILEGES;  
Query OK, 0 rows affected (0.00 sec)

mysql> exit;

  设置开机自启

[root@localhost support-files]# cp mysql.server /etc/init.d/mysql
[root@localhost support-files]# chmod +x /etc/init.d/mysql
[root@localhost support-files]# chkconfig --add mysql 
[root@localhost support-files]# chkconfig --list mysql  

  

[root@localhost support-files]# service mysql stop

[root@localhost support-files]# service mysql start

配置环境变量:

[root@localhost local]# mysql -uroot -p
-bash: mysql: command not found
[root@localhost local]# ln -s /usr/local/mysql/bin/mysql /usr/bin
[root@localhost local]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.22 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

 mysql远程登录问题:

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set host = '%' where user = 'root';
Query OK, 0 rows affected (0.11 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql> select host,user from user;
+-----------+---------------+
| host      | user          |
+-----------+---------------+
| %         | myuser        |
| %         | root          |
| %         | sec_user      |
| localhost | mysql.session |
| localhost | mysql.sys     |
| localhost | sec_user      |
+-----------+---------------+
6 rows in set (0.00 sec)

 

C:\Users\Administrator>mysql -u sec_user -h 192.168.222.13 -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.7.22 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| securities_master  |
+--------------------+
2 rows in set (0.00 sec)

mysql> use securities_master;
Database changed
mysql> show tables;
+-----------------------------+
| Tables_in_securities_master |
+-----------------------------+
| daily_price                 |
| data_vendor                 |
| exchange                    |
| symbol                      |
+-----------------------------+
4 rows in set (0.00 sec)

mysql>

  

 

参考文档:

https://blog.csdn.net/qq_37995908/article/details/79092363

https://blog.csdn.net/ctypyb2002/article/details/79757070

https://blog.csdn.net/mengfei86/article/details/51189624