mysql的安装和常见问题

一、安装mysql

centos 安装 mysql：

1.下载与操作系统匹配的发布包
方法1.访问官网下载
方法2.使用直接使用wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
2.rpm -Uvh mysql80-community-release-el7-1.noarch.rpm
3.yum install -y mysql-community-server

启动：
service mysqld start

停止：
service mysqld stop

查看状态：
service mysqld status

查看 mysql 临时密码：
grep 'temporary password' /var/log/mysqld.log

登录 mysql:
mysql -u root -p

修改 mysql 当前用户密码：
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPass';

授权外网访问(此处以 root 用户为例):

1. 登录数据库
2. use mysql;
3. update user set host='%' where user='root';
4. flush privileges;

二、常见问题

插入生僻字

如：，提示“ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value”

将字符集设为 utf8mb4，可解决该问题。在 my.cnf 文件中添加如下内容：
[mysql]
default-character-set=utf8mb4

ER_NOT_SUPPORTED_AUTH_MODE

Client does not support authentication protocol

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码';
flush privileges;

Error Code: 1055.

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

set sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'