MySQL: Unterschied zwischen den Versionen

Aus crazylinux.de
Zur Navigation springen Zur Suche springen
(x)
(x)
Zeile 34: Zeile 34:


= Clients =
= Clients =
*[http://dev.mysql.com/downloads/query-browser/1.1.html MySQL QueryBrowser]
*[http://dev.mysql.com/downloads/tools/workbench/ MySQL Workbench]
*[http://www.sqlmanager.net/products/mysql/manager SQLManager]
*[http://www.navicat.de/ Navicat]
*[http://www.navicat.de/ Navicat]
*[http://www.webyog.com/ SQLyog]


=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,


Clients

Links