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 SERVER PASSWORD 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 SERVER PASSWORD OFFLINE#
The internal network is installed by offline package.Īfter entering the page, click the link on the right.
0 kommentar(er)
