MySQL????????? - PowerPoint PPT Presentation

1 / 25
About This Presentation
Title:

MySQL?????????

Description:

Title: MySQL Author: User Last modified by: Jacy Created Date: 1/8/2006 1:19:12 AM Document presentation format: Company – PowerPoint PPT presentation

Number of Views:95
Avg rating:3.0/5.0
Slides: 26
Provided by: edut1550
Category:
Tags: mysql | mysql

less

Transcript and Presenter's Notes

Title: 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),?????????
Write a Comment
User Comments (0)
About PowerShow.com