• src=http___img.mp.itc.cn_q_70,c_zoom,w_640_upload_20170422_2dcdfe1a026140269765e5735b18eb30_th.jpeg&refer=http___img.mp.itc.jpg 苦味 萝卜
    开心大侠 开心 大侠
  • 2021-03-11

第一步、安装mysql 安装源:

[root@localhost local]# yum -y localinstall mysql57-community-release-el7-11.noarch.rpm

第二步,在线安装MySQL

[root@localhost local]# yum -y install mysql-community-server

等待时间比较久:

20200410105952503.png
MySQL - 安装MYSQL

第三步、启动mysql 服务

[root@localhost local]# systemctl start mysqld

第四步,设置开机启动

[root@localhost local]# systemctl enable mysqld

[root@localhost local]# systemctl daemon-reload

第五步,修改root登录密码

mysql安装完成之后,会在 /var/log/mysqld.log 文件中给root生成了一个临时的默认密码。

[root@localhost local]# vim /var/log/mysqld.log

20200410113043183.png
MySQL - 修改root登录密码

记住初始密码:

修改root 密码

[root@localhost local]# mysql -u root -p

20200410113214101.png

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'daasan7ujm^YHN';

Query OK, 0 rows affected (0.00 sec)

# 设置远程登录

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'daasan7ujm^YHN' WITH GRANT OPTION;

Query OK, 0 rows affected, 1 warning (0.00 sec)

第六步,退出

mysql> exit

第七步,防火墙开放3306端口

[root@localhost sysconfig]# cd /etc/sysconfig/

[root@localhost sysconfig]# vim iptables

#添加代码如下

-A INPUT -p tcp --dport 3306 -j ACCEPT

20200410115225561.png
-

第八步,重启防火墙。

[root@localhost sysconfig]# service iptables restart

第九步,配置mysql默认编码为utf-8

[root@localhost sysconfig]# vim /etc/my.cnf

添加如下代码

character_set_server=utf8

init_connect='SET NAMES utf8'

20200410115828728.png

:wq 保存退出

第十步,重启MySQL

[root@localhost data]# systemctl restart mysqld

第十一步, root 用户登录查看编码

[root@localhost sysconfig]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.7.29 MySQL Community Server (GPL)

Copyright (c) 2000, 2020, 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 variables like '%character%';

+--------------------------+----------------------------+

| Variable_name | Value |

+--------------------------+----------------------------+

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | utf8 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | utf8 |

| character_set_system | utf8 |

| character_sets_dir | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

8 rows in set (0.00 sec)

mysql>

最后本地连接测试:

20200410120331487.png
-
标签:   mysql php