nethserver-mysql¶
Manage and configure MySQL server.
When installed, the module will trigger the mysql_secure_installation
script generating default configuration:
- Auto-generated root password saved in /var/lib/nethserver/secrets/mysql
- No anonymous user
- No remote root login allowed
- No test database
Differences from SME Server:
- InnoDB tables enabled, removed
InnoDB
property - TCP connections enabled: can be disabled setting
LocalNetworkingOnly
property toyes
- Removed
OpenFilesLimit
property max_allowed_packet
option is 1MB (as MySQL default). To change the value set theMaxAllowedPacket
property
The root password is also saved in /root/.my.cnf
, so the root user can use mysql client without typing any password.
Database example:
mysqld=service
LocalNetworkingOnly=no
MaxAllowedPacket=16MB
TCPPort=3306
status=enabled
Loading data¶
There is a special action /etc/e-smith/events/actions/nethserver-mysql-init
which can be used to load data inside the database.
OBSOLETE: For backward compatibility with SME Server, the mysql.init
service can also be used instead of the new action. The use of the service is HIGHLY discouraged.
When launched, the script will search for links in /etc/e-smith/sql/init
directory.
If a link point to a file with .sql extension, the content of the file will be loaded using the mysql
command.
Otherwise if the file is executable it will be simply executed.
If no error occurs, the link will be removed.
Given ad simple /tmp/test.sql
script, you can load it using this commands:
ln -s /tmp/test.sql /etc/e-smith/sql/init/temp.sql
service mysql.init start