MySQL

instalace v ubuntu / debian

sudo apt-get install apache2 php5 php5-mysql mysql-server phpmyadmin
sudo apt-get install php5-gd php5-curl php5-imagick php5-ffmpeg mysql-query-browser

sql administrace (GUI)

• heidisql - jHeidi
• SQLyog - dl SQLyog715.exe
• workbench puvodni: dbdesigner4
• linux-mysql-server-monitoring
• sudo apt-get install mysql-admin
• sudo apt-get install phpmyadmin

zaloha sql

• mysqldump -p jmenodatabaze > dump.sql
• s zabalenim
  mysqldump -uuzivatel -pheslo mysql-access-denied-for-user-debian-sys-maintlocalhost

  • import-velkych-souborudumpu-do-mysql-databaze BIGDUMP

  '>-___ sql klient
  

  • java
  • sqltalk

  ORACLE

  • apex

  sql v openoffice

  • jdbc a odbc v ooffice
  • konektory

  uzivatele

  • how-to-create-a-mysql-database-and-set-privileges-to-a-user

  php

  • sql 2 xls
  • mysql - tvroba-webu.cz
  • php.net/mysql
  • interval - dotaz na php + sql
  • SQL smarty-chytre-sablony-pro-php
  • triggery

  kousky kodu

  • sql php codango.com
  • mysql yourfreescripts.com
  • flexigrid - pekna tabulka

  15:07 robinLTNB: zadal jsem prikaz "\\\\r postfix"
  15:07 robinLTNB: connectionid 3325 dbase postfix
  15:08 robinLTNB: chapu li to dobre, pak mam pristup do databaze
  15:09 robinLTNB: urcite existuje nejaky prikaz na vypsani vsech dostupnych tabulek/databazi
  15:10 Aldar: Vse podstatne pro ten vypis je v tabulce postfix_users
  15:10 Aldar: show tables;
  15:10 Aldar: describe postfix_users;
  15:10 robinLTNB: a pripadne neco jako dotaz ... napis vsechny uzivatele z tabulky XX ... napr "list users=all tab=neco
  15:10 Aldar: select email from postfix_users;

  dalsi info
  

  --- MySQL
  apt-get install mysql-server mysql-client libmysqlclient15-dev
  - New password for the MySQL "root" user: <-- yourrootsqlpassword
  - Repeat password for the MySQL "root" user: <-- yourrootsqlpassword
  

  nano /etc/mysql/my.cnf
  #bind-address = 127.0.0.1
  

  /etc/init.d/mysql restart
  netstat -tap | grep mysql
  

  vytvoreni usera:
  http://www.databasef1.com/tutorial/mysql-create-user.html

  povoleni pristupu ze site:
  http://hashmysql.org/index.php?title=Remote_Clients_Cannot_Connect "mysql -u root -p"
  SELECT User, Host FROM mysql.user WHERE Host <> 'localhost';
  

  GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'heslo' WITH GRANT OPTION;
  (nebo omezene: GRANT ALL PRIVILEGES ON . TO 'root'@'192.168.100.%' IDENTIFIED BY 'my-new-password' WITH GRANT OPTION;)
  

  CREATE USER 'rr'@'localhost' IDENTIFIED BY 'heslo';
  GRANT ALL PRIVILEGES ON . TO 'rr'@'%' IDENTIFIED BY 'heslo' WITH GRANT OPTION;
  

  CREATE USER 'radim'@'localhost' IDENTIFIED BY 'heslo';
  GRANT SELECT,INSERT,UPDATE,DELETE ON . TO 'radim'@'%' IDENTIFIED BY 'heslo' WITH GRANT OPTION;
  GRANT CREATE,SELECT,INSERT,UPDATE,DELETE ON . TO 'radim'@'%' IDENTIFIED BY 'heslo' WITH GRANT OPTION;
  

  CREATE USER 'apache'@'localhost' IDENTIFIED BY 'apache';
  GRANT SELECT,INSERT,UPDATE,DELETE ON . TO 'apache'@'%' IDENTIFIED BY 'apache' WITH GRANT OPTION;
  

  pouzivani:
  "mysql -u root -p"
  (-u user -p password)
  "create database postfix;"
  "\\\\r postfix"
  se pripoji do databaze postfix
  "show tables;"
  "describe postfix_users;"
  "a pripadne neco jako dotaz ... napis vsechny uzivatele z tabulky XX ... napr "list users=all tab=neco"
  "select email from postfix_users;"
  

  14:59 Roksteady: remote
  14:59 the_wench: remove bind-address= and skip-networking from my.cnf and grant permission to the external 'user'@'host' and remove any firewall rules blocking port 3306 and make sure no overrides on the mysqld commandline. See http://hashmysql.org/index.php?title=Remote_Clients_Cannot_Connect 14:59 Roksteady: rrob_: aha, then you need to create some GRANTs
  14:59 kaushal: Roksteady, is it ok
  14:59 Roksteady: man GRANT SYNTAX
  14:59 the_wench: see http://dev.mysql.com/doc/refman/5.0/en/grant.html 15:00 Roksteady: kaushal: fine by me but I wont be here then :)
  

  další info

  • kompletni navody

  • fzu.cz > zakladni sql info
  • mysql pro zelenace - linuxexpres.cz
  • PHP MySQL Tutorial
  • change-and-reset-mysql-root-password
  • sql-tvorba-tabulek

  • freewebmasterhelp.com/tutorials/
  • sql tutorial na w3schools
  • create user

  Poslední změna: 18.09.2009 09:45:00
  na zacatek edit.php wiki