MySQL: Unterschied zwischen den Versionen

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


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


[[Category:Linux]] [[Category:Datenbank]]
=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


Links