Listen only on the loopback addressīy default, MariaDB will listen on the 0.0.0.0 address, which includes all network interfaces. To prevent MySQL from listening on an external interface, see the #Listen only on the loopback address and #Enable access locally only via Unix sockets sections. Warning: After running this, please note that TCP port 3306 will still be open, but refusing connections with an error message. The mariadb-secure-installation command will interactively guide you through a number of recommended security measures, such as removing anonymous accounts and removing the test database: $ mariadb-tzinfo-to-sql timezone_file timezone_name | mariadb -u root -p mysql Optionally, you may populate the table with specific time zone files: $ mariadb-tzinfo-to-sql /usr/share/zoneinfo | mariadb -u root -p mysql To populate the time zone tables with all the time zones: They need to be populated if you are planning on using CONVERT_TZ() in SQL queries. Stop rvice, mount /var/lib/mysqltmp/ and start rvice.Īlthough time zone tables are created during the installation, they are not automatically populated. Tmpfs /var/lib/mysqltmp tmpfs rw,gid=mysql,uid=mysql,size=100M,mode=0750,noatime 0 0Īdd to your /etc/my.cnf.d/server.cnf file under the mysqld group: For example, it is used to perform disk based large sorts, as well as for internal and explicit temporary tables.Ĭreate the directory with appropriate permissions:Īdd the following tmpfs mount to your /etc/fstab file: The directory used by MariaDB for storing temporary files is named tmpdir. See #Maintenance to optimize and check the database health. Changing the character set does not change existing table formats, only newly created tables, and the protocol interaction that fetches data. Īppend the following values to the main configuration file located at /etc/my.cnf.d/my.cnf:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |