本文共 1563 字，大约阅读时间需要 5 分钟。

MySQL????

1. MySQL??

1.1 ??

MySQL??????????????RDBMS???MySQL AB????????Oracle???????????????????????????????????????MySQL?????SQL?????????????????????????????????

MySQL????

• ????????????
• ??????????????????
• ????????PHP?Python?Java??
• ?PHP???????????Web?????PHP?MySQL????????
• ???????GPL???????????

1.2 ????

MySQL??????????????

• SQL??????????????
• ????????????????
• ????????????
• ????????MyISAM?InnoDB?

2. MySQL???

2.1 ????

1. ????

?????MySQL 5.7??????????????root?

2. ??????

• ????????ps -ef | grep mysql??????????
• ??????rpm -qa | grep -i mysql?????????

3. ?????

??????????????????

4. ?????

??????????Navicat?

5. ??????

????mysqladmin --version???????

6. ???????

• ???service mysql start
• ???service mysql stop

7. ????

????????????????

8. ?????

??my.cnf?????????

9. ??????

??????my.cnf????????

10. ????????

• ????????show variables like '%character%'?show variables like '%char%'?
• ???????my.cnf?????????
• ????????????/var/lib/mysql?

3. MySQL???????

3.1 ?????

????????????????????

3.2 ????

?????????????????

3.3 ????

??????????????

3.4 ????

???????

• Windows?D:\devSoft\MySQLServer5.5\data
• Linux??????/var/lib/mysql

?????

• frm???????
• myd??????
• myi??????

4. MySQL???

4.1 ????

MySQL??????????????????????????????????

4.2 ???

????????????????????

4.3 ???

??????????????????MyISAM?InnoDB?

5. MySQL?????

5.1 ??????

• ???mysql> show engines;
• ???????mysql> show variables like '%storage_engine%';

5.2 MyISAM?InnoDB

• MyISAM????????????
• InnoDB?????????????????????
• Percona?????????????????????
• AliSQL???Redis?????????

6. MySQL???

MySQL??????????????????????Web???????????????????????????????????