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 klient
dalsi info
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 :)
PHP MySQL TutorialPoslední změna: 18.09.2009 09:45:00