MySQL: Unterschied zwischen den Versionen

Aus crazylinux.de
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

Navicat

http://www.navicat.de/

SQLyog

http://www.webyog.com/