MySQL
:
..
2011
: .
: .
: MySQL.
: MySQL.
1.
, , , .
, ( ) . , . ϳ - , . :
( ), , . , , . menagerie, , web- MySQL. tar- (http://www.mysql.com/Downloads/Contrib/Examples/menagerie.tar.gz) Zip (http://www.mysql.com/Downloads/Contrib/Examples/menagerie.zip).
, , SHOW:
mysql> SHOW DATABASES;
+----------+
|Database |
+----------+
| mysql |
| test |
| tmp |
+----------+
, , , , , mysql test. mysql , . test .
, , SHOW DATABASES.
test , :
mysql> USE test
Database changed
USE, QUIT, (, ). USE : .
test (, , ) , - , . MySQL . , menagerie (). :
mysql> GRANT ALL ON menagerie.* TO your_mysql_name;
your_mysql_name ' MySQL.
|
|
, . :
mysql> CREATE DATABASE menagerie;
Unix ( SQL), menagerie, Menagerie, MENAGERIE -. ( Windows 䳺, , ).
; . menagerie :
mysql> USE menagerie
Database changed
, mysql. USE, . mysql. 璺, . :
shell> mysql -h host -u user -p menagerie
Enter password: ********
: menagerie . -p (, -pmypassword, -p mypassword). , , .
2.
, . , , , .
3.