MySQL: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
K (secure) |
(x) |
||
Zeile 31: | Zeile 31: | ||
/srv/mysql/datadir55/ r, | /srv/mysql/datadir55/ r, | ||
/srv/mysql/datadir55/** rwk,</source> | /srv/mysql/datadir55/** rwk,</source> | ||
= Clients = | = Clients = | ||
*[http://dev.mysql.com/downloads/query-browser/1.1.html MySQL QueryBrowser] | |||
*[http://www.sqlmanager.net/products/mysql/manager SQLManager] | |||
*[http://www.navicat.de/ Navicat] | |||
*[http://www.webyog.com/ SQLyog] | |||
[ | =Links= | ||
*[http://www.thomas-krenn.com/de/wiki/MySQL_Performance_Tuning MySQL Performance Tuning] | |||
[[Kategorie:Datenbank]] | [[Kategorie:Datenbank]] | ||
[[Kategorie:MySQL]] | [[Kategorie:MySQL]] |
Version vom 1. September 2013, 21:49 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,
Clients