MySQL: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
K (x) |
K (secure) |
||
Zeile 14: | Zeile 14: | ||
table_cache = 256</source> | table_cache = 256</source> | ||
==Secure Installation== | |||
<source lang="bash">/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.</source> | |||
== Apparmor config == | == Apparmor config == |
Version vom 25. Januar 2013, 01:10 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
MySQL QueryBrowser
http://dev.mysql.com/downloads/query-browser/1.1.html
SQLManager
http://www.sqlmanager.net/products/mysql/manager
http://www.navicat.de/
SQLyog
http://www.webyog.com/