MySQL

Aus crazylinux.de
Wechseln zu: Navigation, Suche

1 Konfiguration

1.1 Custom Settings

#/etc/mysql/conf.d/settings.cnf
[mysqld]
#
# * Basic Settings
#
datadir         = /srv/mysql/datadir55

ft_min_word_len=3

table_cache             = 256

1.2 Secure Installation

/usr/bin/mysqladmin -u root -h hostname password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

1.3 Apparmor config

#/etc/apparmor.d/usr.sbin.mysqld
#find and replace

  #/var/lib/mysql/ r,
  #/var/lib/mysql/** rwk,
  /srv/mysql/datadir55/ r,
  /srv/mysql/datadir55/** rwk,


2 Backup


3 Clients

4 Links