许吉友 - 运维

MySQL 最新版本安装

当前 MySQL 的最新版本为 8.0,下面使用 yum 来安装 MySQL 8.0。

先安装 yum 库,下载地址:https://dev.mysql.com/downloads/repo/yum/

或者使用命令直接下载(CentOS 7):

$ wget https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm

下载下来之后,YUM 本地安装:

$ sudo yum localinstall mysql80-community-release-el7-3.noarch.rpm

然后安装 MySQL:

$ sudo yum install mysql-community-server -y

此过程将安装以下包:

image-20200513110643194

启动:

$ sudo systemctl enable mysqld
$ sudo systemctl start mysqld

查看初始密码:

$ grep 'temporary password'  /var/log/mysqld.log

然后进入命令行:

$ mysql -u root -p

进去之后先修改密码:

mysql> ALTER USER root@localhost identified by 'BBDERS1@bbdops.com';

查看用户:

mysql> select user,host from mysql.user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)

上边看到,root 仅允许 localhost 访问,下面让 root 允许外网访问:

mysql> use mysql;
mysql> UPDATE user SET `Host` = '%' WHERE `User` = 'root' LIMIT 1;
mysql> flush privileges;
mysql> select user,host from user;

mysql8 创建数据库及用户步骤:

create database ambari  default character set utf8mb4;
CREATE USER 'ambari'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON ambari.* TO 'ambari'@'%'; 

这样外部就可以连接了。

经常数据密码很烦人,这里做一下免密登录:

$ vim ~/.my.cnf
[client]
host=127.0.0.1
user=root
password=BBDERS1@bbdops.com

然后登录时使用:

$ mysql

如果不是默认的文件,需要指定客户端配置文件:

$ mysql --defaults-file=~/.mysql/localhost.cnf