:
MySQL
|
|
|
|
: ...,
..
|
: |
MySQL
| 2014 | ||
|
| ||||
| : ..., .. | ||||
. 2
I. MySQL Server. 3
II. Eclipse. 12
III. . 16
IV. ( ). 17
. 18
Eclipse Java. MySQL server.
, 25, .
:
;
( ) ;
.doc (.docx,.rtf), :
o ,
o ,
o ,
o ,
o ,
o ,
o java- ,
o java- ,
o ,
o ;
-, ;
.
I. MySQL Server
MySQL, : http://www.mysql.ru/download/.
[ ].msi. .
MySQL *.* Command Line Client.
: http://www.mysql.ru/docs/
MySQL
mysql MySQL , , . , , .
, . , ( 1).
1
, , 2 :
mysql>
2
1.1.2.
1: MySQL, .
GRANT, :
GRANT priv_type [(column_list)] [, priv_type [(column_list)]...]
|
|
|
ON {tbl_name | * | *.* | db_name.*}
TO user_name [IDENTIFIED BY [PASSWORD] 'password']
[, user_name [IDENTIFIED BY 'password']...]
[REQUIRE
[{SSL| X509}]
[CIPHER cipher [AND]]
[ISSUER issuer [AND]]
[SUBJECT subject]]
[WITH [GRANT OPTION | MAX_QUERIES_PER_HOUR # |
MAX_UPDATES_PER_HOUR # |
MAX_CONNECTIONS_PER_HOUR #]]
user_name ( ) , , .
:
mysql> GRANT ALL PRIVILEGES ON *.* TO elen_vik@localhost
-> IDENTIFIED BY 'kokoreva' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO elen_vik@"%"
-> IDENTIFIED BY 'kokoreva' WITH GRANT OPTION;
elen_vik, , localhost (, MySQL) 'kokoreva'. . 3 .
3 MySQL
vasya vasya ( SELECT, INSERT, UPDATE) localhost 'user'.
mysql> GRANT SELECT, INSERT, UPDATE
-> ON vasya.*
-> TO vasya@localhost
-> IDENTIFIED BY 'user';
MySQL
, , SHOW:
mysql> SHOW DATABASES;
:
, mysql ;. mysql , , ( 4).
4 SHOW DATABASES MySQL
.
CREATE:
mysql> CREATE DATABASE < >;
:
, . , USE:
mysql> USE < >
:
, .
|
|
|
|
|
|
: 2018-11-10; !; : 339 |
:
| 1262 - 