MySQL安装教程

MySQL

MySQL配置文件位置

Linux下MySQL创建的数据库默认存在于/var/lib/mysql目录下

Linux下MySQL的配置文件my.cnf默认在/etc/my.cnf下

.

centos7安装MySQL（一）

1、去https://mirror.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-5.7/下载rpm包：mysql-5.7.31-1.el7.x86_64.rpm-bundle.tar。

2、解压到/usr/local/mysql目录下

3、检查是否安装了mysql的rpm包，如果有就删除

[root@iZ2ze7y54l8o2whhrj0taxZ opt]# rpm -qa | grep mysql
[root@iZ2ze7y54l8o2whhrj0taxZ opt]# rpm -qa | grep mariadb
mariadb-libs-5.5.64-1.el7.x86_64
[root@iZ2ze7y54l8o2whhrj0taxZ opt]# rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64

4、进入mysql目录，执行四个rpm文件

rpm -ivh mysql-community-common-5.7.31-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.31-1.el7.x86_64.rpm 

rpm -ivh mysql-community-client-5.7.31-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-5.7.31-1.el7.x86_64.rpm

5、启动mysqld服务：systemctl start mysqld

6、查看mysql默认密码

[root@iZ2ze7y54l8o2whhrj0taxZ mysql]# cat /var/log/mysqld.log | grep password
2021-04-04T09:46:56.430936Z 1 [Note] A temporary password is generated for root@localhost: %=o(=qlGY7Lb

7、修改/etc/my.cnf配置文件，[mysqld]下添加一行：validate_password=off（为了使123456等简单密码生效），重启mysqld服务

8、进入mysql命令行，修改mysql登录密码：alter user ‘root’@‘localhost’ identified by ‘123456’;

.

centos7安装MySQL（二）

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

yum -y install mysqld57-community-release-el7-10.noarch.rpm

yum -y install mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql-community-server

systemctl start mysqld

grep "password" /var/log/mysqld.log

mysql -uroot -p 8.4iTw/0Jyl:

mysql> set global validate_password_policy=0;

mysql> set global validate_password_length=6;

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

.

Docker安装MySQL

1、运行容器

docker run -p 3306:3306 --name mysql-master \

-v /zyh/mysql/master/log:/var/log/mysql \

-v /zyh/mysql/master/data:/var/lib/mysql \

-v /zyh/mysql/master/conf:/etc/mysql \

-e MYSQL_ROOT_PASSWORD=123456 \

-d mysql:5.7.32

2、配置my.cnf文件

vim /zyh/mysql/master/conf/my.cnf

[client]

default-character-set=utf8

[mysql]

default-character-set=utf8

[mysqld]

init_connect='SET collation_connection = utf8_unicode_ci'

init_connect='SET NAMES utf8'

character-set-server=utf8

collation-server=utf8_unicode_ci

skip-character-set-client-handshake

skip-name-resolve  # 注意：一定要加上这个，不然连接mysql很慢

.

如果navicat连不上MySQL

一定是权限不足的原因。

mysql> use mysql;

mysql> select user,host from user;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| mysql.session | localhost |
| mysql.sys     | localhost |
| root          | localhost |
+---------------+-----------+

mysql> update user set host = '%' where user = 'root';

mysql> select user,host from user;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| root          | %         |
| mysql.session | localhost |
| mysql.sys     | localhost |
+---------------+-----------+

mysql> flush privileges;