MySQL

SHOW CREATE TABLE table;

use CONSTRAINT and KEY!!!

ALTER TABLE table_name
DROP FOREIGN KEY the_name_after_CONSTRAINT,
DROP KEY the_name_after_FOREIGN_KEY;

Ubuntu 12.04 LTS alatt mysql ssl adatait csak az /etc/mysql mapaban fogadta el.Masik mapaba akkor fogaja el ha modositjuk ezt a fajlt :
/etc/apparmor.d/usr.sbin.mysqld
/xx/xx/*.pem r

http://ubuntuforums.org/showthread.php?t=1121458

http://www.techrepublic.com/blog/howdoi/how-do-i-stress-test-mysql-with-...

http://scottlinux.com/2011/01/01/optimize-mysql/

mysql --ssl-ca=/root/openssl/6120cacert.pem --ssl-cert=/root/openssl/client_tania-cert.pem --ssl-key=/root/openssl/client_tania-private-key.pem -u XXXX -p

Szerver inditasa :
C:\Program Files\MySQL\MySQL Server 5.5\bin\MySQLInstanceConfig.exe

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON databse_name.* TO 'user'@'host' IDENTIFIED BY 'password';

SSL:
GRANT ALL PRIVILEGES ON adatbazis.* TO 'felhasznalo'@'%' IDENTIFIED BY 'titok' REQUIRE SSL;

host :
% - all
ip - 192.168.1.2
ip % - 192.168.1.%
domain - renko.homeip.net

FLUSH PRIVILEGES;