MySQL: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(x) |
(x) |
||
Zeile 34: | Zeile 34: | ||
= Clients = | = Clients = | ||
*[http://dev.mysql.com/downloads/ | *[http://dev.mysql.com/downloads/tools/workbench/ MySQL Workbench] | ||
*[http://www.navicat.de/ Navicat] | *[http://www.navicat.de/ Navicat] | ||
=Links= | =Links= |
Version vom 1. September 2013, 21:51 Uhr
Konfiguration
Custom Settings
#/etc/mysql/conf.d/settings.cnf
[mysqld]
#
# * Basic Settings
#
datadir = /srv/mysql/datadir55
ft_min_word_len=3
table_cache = 256
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.
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,