mysql安装后基本配置信息

一、查看mysql日志

1、journalctl -xe
2、vi /var/log/mysqld.log

二、mysql默认配置文件路径

1、/etc/my.cnf

三、mysql配置文件内容

[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[database]
character_set_database=utf8mb4
[mysqld]
transaction-isolation=READ-COMMITTED
server-id=1
log-bin
log_bin_trust_function_creators=1
port=3306
max_connect_errors=99999
max_error_count=88888
character-set-server=utf8mb4
lower_case_table_names=1
max_connections=9999
max_user_connections=8888
wait_timeout=31536000
interactive_timeout=31536000
innodb_buffer_pool_size=8192M
innodb_buffer_pool_instances=1
innodb_buffer_pool_chunk_size=8192M
max_allowed_packet=100M
sql-mode="STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ALLOW_INVALID_DATES"
datadir=var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid