Wait_timeout = 1800 # The default value of MySQL wait_timeout is 8 hours. Interactive_timeout = 1800 # MySQL connection will be forcibly closed after it has been idle for more than a certain period of time (in seconds) Max_allowed_packet = 128M # The size of the SQL packet sent, if there is a BLOB object suggested to be modified to 1G Max_connect_errors = 1000 # Maximum number of false connectionsĮxplicit_defaults_for_timestamp = true # TIMESTAMP allows NULL values if no declaration NOT NULL is displayed Max_connections = 400 # maximum connection Lower_case_table_names = 1 # Is it case sensitive to sql statements, 1 means insensitive Init_connect='SET NAMES utf8mb4' # Set up the character set when client connects mysql to prevent scrambling Be careful to correspond to character-set-server. MySQL is repeatable by default.Ĭollation-server = utf8mb4_general_ci # The character set of database corresponds to some sort rules, etc.
Transaction_isolation = READ-COMMITTED # Transaction isolation level, which is repeatable by default. Skip_name_resolve = 1 # Only use IP address to check the client's login, not the host name.Ĭharacter-set-server = utf8mb4 # Database default character set, mainstream character set support some special emoticons (special emoticons occupy 4 bytes) Pid-file = /home/mysql/3306/log/mysql.pid # The directory where the pid file is located Socket = /home/mysql/3306/tmp/mysql.sock # Specify a socket file for local communication between MySQL client program and server Tmpdir = /home/mysql/3306/tmp # Temporary directories, such as load data infile, will be used Server-id = 1 # The unique number of Mysql service Each MySQL service Id needs to be uniqueīasedir = /usr/local/mysql # MySQL installation root directoryĭatadir = /home/mysql/3306/data # MySQL Data File Location Socket = /home/mysql/3306/tmp/mysql.sock # For socket sockets for local connections, the mysqld daemon generates this fileīind-address = 0.0.0.0 # Allow any ip host to access this database
# Modify users and user groups of all files under mysql folderĬreate my.cnf configuration file, which is recommended to be written and uploaded to the ET directory # Client settings, the default connection parameters for the client # Establish soft links for future upgrades Upload the downloaded mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz installation package to the server/usr/local directory # Decompress again
Centos 7 install mysql mariadb password#
# Modify the login password of mysql usersĢ.3 Create temporary directories, data directories, and log directories /home/mysql/3306/data Upload to the server through xftp6 and other tools.Ģ.1 Query and uninstall Mariadb from the system rpm -qa | grep mariadbĬheck the existence of mysql composite users # Check whether mysql groups and users exist or not, or create if none existsĬreate a mysql user and mysql user group # Add mysql user groups
Centos 7 install mysql mariadb Offline#
The internal network is installed by offline package.Īfter entering the page, click the link on the right.
0 kommentar(er)
