MySQL?????????

1
MySQL?????????
2
?Outlines

• MySQL??????????
• my.ini?????
• ????????

3
?MySQL??????????

• ???MySQL 5????,????????????,????????????
• bin??????MySQL??????,??????????,??mysql?mysqldum
  p? mysqladmin?mysqld-nt?
• data? MySQL ?????????????????????????????
  ??????????????????
• shareMySQL ??????? (message) ???? (error log)
  ????????

4
????MySQL?????

• ???????? root ??
• ? ??? ? MySQL ??? MySQL Command Line
  Client,???????root??????
• ?????????? (?????root??)
• ? ??? ? ?????? ??? ??????
• ?? ?????? ?,???????????? mysql ????????????
  (??????AppServ)
• C\AppServ\MySQL\bingt
• ???? mysql u ????? p,?Enter?????????
• -u ??????,???????????
• -p ???Enter?,???????,??????????

5
MySQL???????????

• MySQL 5????????,???????????? (????????????????????
  )
• mysql ??????MySQL ???????,???host?user?db?tables_
  priv?colimns_priv?func?????
• test ????????,????????

6

• ????? mysql ?,???????????
• user???????????MySQL?????????????????????????????
  ??MySQL??????
• db?????????????????????????????????
• host??????db?????,??????????? ?
• tables_priv?????????????????????
• columns_priv?????????????????????
• func?????????????????

7

• ??? db ??

8
? my.ini?????

• MySQL?????????,?????????????????????DBA????????MyS
  QL Server???,??MySQL???????????????
• ???????MySQL?????????,?????????????????????
• Windows my.ini
• Linux my.cnf

9

• my.ini???

???my.ini????,??????????
10
????????????

• key_buffer_size
• ?????????,?????????????????,????????????,????????
  ????,????key_buffer_size?????,???????
• ???????????10MB,??????????????1/5
  (???????2GB???,??400MB???),???key_buffer_size?
• max_connections
• ?????????????????????????????
• sort_buffer
• ??????????????????????,????ORDER BY?GROUP BY?????
• ???????????256KB,????????2MB16MB

11
??????my.ini????

• my-small.ini (lt64MB)
• my-medium.ini (32MB64MB)
• my-large.ini (512MB)
• my-huge.ini (1GB2GB)
• my-innodb-heave-4G.ini (4GB, InnoDB only, ACID,
  Heavy Queries)

12
??my.ini

• ???my.ini????my.ini???,?????????!!
• ?????my.ini??,???????my.ini????

13
MySQL?????????????

• ??????my.ini
• ?? max_connections100 (????????????)
• ?100???50
• ?????MySQL

14
?????????

• ????MySQL???,??????????MySQL???????MySQL 5
  (?AppServ) ?,????????????? root?????root???,????
  ????
• set password for root_at_localhost
  password(???)
• ??????????localhost?????root??????????
• ?????????,??????????????

15
??root????

• ?????????
• ??MySQL 5???
• ?my.ini???mysqld??,?? skip_grant_tables
• ????MySQL 5???
• ???? mysql u root,????,?Enter?????
• ??mysql????????
• ????????????mysql??user???
• ????MySQL 5???
• ?my.ini???mysqld??,?? skip_grant_tables
• ????MySQL 5???

16
??MySQL 5???
17
?my.ini??mysqld???? skip_grant_tables
?? skip_grant_tables
18
????MySQL 5???
19
???? mysql u root

• ???? mysql u root,????,?Enter?????

20
??mysql????????
21
????????????mysql??user???

• ??user????,user???root?host?localhost?????????
  ??????????????????????
• update user set password password(123456789)
  where userroot and hostlocalhost

22
????MySQL 5???

• ??MySQL???,?????MySQL 5????

23
?my.ini???mysqld???? skip_grant_tables

• ???????

?? skip_grant_tables
24
????MySQL 5???

• ????MySQL DB,????????????????

25

• ?? show processlist ???????????????,???process??
  ???
• INFORMATION_SCHEMA??????,???????MySQL?????????????
  ?????????INFORMATION_SCHEMA?,?????????????????
  (View),?????????