{"id":911,"date":"2018-07-08T14:48:07","date_gmt":"2018-07-08T06:48:07","guid":{"rendered":"https:\/\/blog.freesilo.com\/?p=911"},"modified":"2018-07-08T14:48:07","modified_gmt":"2018-07-08T06:48:07","slug":"mysql-%e6%95%b0%e6%8d%ae%e5%ba%93%e5%b8%b8%e7%94%a8%e5%91%bd%e4%bb%a4%e5%b0%8f%e7%bb%93","status":"publish","type":"post","link":"https:\/\/freesilo.com\/?p=911","title":{"rendered":"MySQL \u6570\u636e\u5e93\u5e38\u7528\u547d\u4ee4\u5c0f\u7ed3"},"content":{"rendered":"

MySQL \u6570\u636e\u5e93\u5e38\u7528\u547d\u4ee4<\/strong><\/span><\/p>\n

 <\/p>\n

1\u3001MySQL\u5e38\u7528\u547d\u4ee4<\/span><\/p>\n

create database name; \u521b\u5efa\u6570\u636e\u5e93<\/p>\n

use databasename; \u9009\u62e9\u6570\u636e\u5e93<\/p>\n

drop database name \u76f4\u63a5\u5220\u9664\u6570\u636e\u5e93\uff0c\u4e0d\u63d0\u9192<\/p>\n

show tables; \u663e\u793a\u8868<\/p>\n

describe tablename; \u8868\u7684\u8be6\u7ec6\u63cf\u8ff0<\/p>\n

select \u4e2d\u52a0\u4e0adistinct\u53bb\u9664\u91cd\u590d\u5b57\u6bb5<\/p>\n

mysqladmin drop databasename \u5220\u9664\u6570\u636e\u5e93\u524d\uff0c\u6709\u63d0\u793a\u3002<\/p>\n

\u663e\u793a\u5f53\u524dmysql\u7248\u672c\u548c\u5f53\u524d\u65e5\u671f<\/p>\n

select version(),current_date;<\/p>\n

 <\/p>\n

2\u3001\u4fee\u6539mysql\u4e2droot\u7684\u5bc6\u7801\uff1a<\/span><\/p>\n

shell>mysql -u root -p<\/p>\n

mysql> update user set password=password(\u201dxueok654123\u2033) where user=\u2019root\u2019;<\/p>\n

mysql> flush privileges \/\/\u5237\u65b0\u6570\u636e\u5e93<\/p>\n

mysql>use dbname\uff1b \u6253\u5f00\u6570\u636e\u5e93\uff1a<\/p>\n

mysql>show databases; \u663e\u793a\u6240\u6709\u6570\u636e\u5e93<\/p>\n

mysql>show tables; \u663e\u793a\u6570\u636e\u5e93mysql\u4e2d\u6240\u6709\u7684\u8868\uff1a\u5148use mysql\uff1b\u7136\u540e<\/p>\n

mysql>describe user; \u663e\u793a\u8868mysql\u6570\u636e\u5e93\u4e2duser\u8868\u7684\u5217\u4fe1\u606f\uff09\uff1b<\/p>\n

 <\/p>\n

3\u3001grant<\/span><\/p>\n

\u521b\u5efa\u4e00\u4e2a\u53ef\u4ee5\u4ece\u4efb\u4f55\u5730\u65b9\u8fde\u63a5\u670d\u52a1\u5668\u7684\u4e00\u4e2a\u5b8c\u5168\u7684\u8d85\u7ea7\u7528\u6237\uff0c\u4f46\u662f\u5fc5\u987b\u4f7f\u7528\u4e00\u4e2a\u53e3\u4ee4something\u505a\u8fd9\u4e2a<\/p>\n

mysql> grant all privileges on *.* to user@localhost identified by \u2019something\u2019 with<\/p>\n

\u589e\u52a0\u65b0\u7528\u6237<\/p>\n

\u683c\u5f0f\uff1agrant select on \u6570\u636e\u5e93.* to \u7528\u6237\u540d@\u767b\u5f55\u4e3b\u673a identified by \u201c\u5bc6\u7801\u201d<\/p>\n

GRANT ALL PRIVILEGES ON *.* TO monty@localhost IDENTIFIED BY \u2019something\u2019 WITH GRANT OPTION;<\/p>\n

GRANT ALL PRIVILEGES ON *.* TO monty@\u201d%\u201d IDENTIFIED BY \u2019something\u2019 WITH GRANT OPTION;<\/p>\n

\u5220\u9664\u6388\u6743\uff1a<\/p>\n

mysql> revoke all privileges on *.* from root@\u201d%\u201d;<\/p>\n

mysql> delete from user where user=\u201droot\u201d and host=\u201d%\u201d;<\/p>\n

mysql> flush privileges;<\/p>\n

\u521b\u5efa\u4e00\u4e2a\u7528\u6237custom\u5728\u7279\u5b9a\u5ba2\u6237\u7aefit363.com\u767b\u5f55\uff0c\u53ef\u8bbf\u95ee\u7279\u5b9a\u6570\u636e\u5e93fangchandb<\/p>\n

mysql >grant select, insert, update, delete, create,drop on fangchandb.* to custom@ it363.com identified by \u2018 passwd\u2019<\/p>\n

\u91cd\u547d\u540d\u8868:<\/p>\n

mysql > alter table t1 rename t2;<\/p>\n

 <\/p>\n

4\u3001mysqldump<\/span><\/p>\n

\u5907\u4efd\u6570\u636e\u5e93<\/p>\n

shell> mysqldump -h host -u root -p dbname >dbname_backup.sql<\/p>\n

\u6062\u590d\u6570\u636e\u5e93<\/p>\n

shell> mysqladmin -h myhost -u root -p create dbname<\/p>\n

shell> mysqldump -h host -u root -p dbname < dbname_backup.sql<\/p>\n

\u5982\u679c\u53ea\u60f3\u5378\u51fa\u5efa\u8868\u6307\u4ee4\uff0c\u5219\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n

shell> mysqladmin -u root -p -d databasename > a.sql<\/p>\n

\u5982\u679c\u53ea\u60f3\u5378\u51fa\u63d2\u5165\u6570\u636e\u7684sql\u547d\u4ee4\uff0c\u800c\u4e0d\u9700\u8981\u5efa\u8868\u547d\u4ee4\uff0c\u5219\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n

shell> mysqladmin -u root -p -t databasename > a.sql<\/p>\n

\u90a3\u4e48\u5982\u679c\u6211\u53ea\u60f3\u8981\u6570\u636e\uff0c\u800c\u4e0d\u60f3\u8981\u4ec0\u4e48sql\u547d\u4ee4\u65f6\uff0c\u5e94\u8be5\u5982\u4f55\u64cd\u4f5c\u5462\uff1f<\/p>\n

mysqldump -T.\/ phptest driver<\/p>\n

\u5176\u4e2d\uff0c\u53ea\u6709\u6307\u5b9a\u4e86-T\u53c2\u6570\u624d\u53ef\u4ee5\u5378\u51fa\u7eaf\u6587\u672c\u6587\u4ef6\uff0c\u8868\u793a\u5378\u51fa\u6570\u636e\u7684\u76ee\u5f55\uff0c.\/\u8868\u793a\u5f53\u524d\u76ee\u5f55\uff0c\u5373\u4e0emysqldump\u540c\u4e00\u76ee\u5f55\u3002\u5982\u679c\u4e0d\u6307\u5b9adriver \u8868\uff0c\u5219\u5c06\u5378\u51fa\u6574\u4e2a\u6570\u636e\u5e93\u7684\u6570\u636e\u3002\u6bcf\u4e2a\u8868\u4f1a\u751f\u6210\u4e24\u4e2a\u6587\u4ef6\uff0c\u4e00\u4e2a\u4e3a.sql\u6587\u4ef6\uff0c\u5305\u542b\u5efa\u8868\u6267\u884c\u3002\u53e6\u4e00\u4e2a\u4e3a.txt\u6587\u4ef6\uff0c\u53ea\u5305\u542b\u6570\u636e\uff0c\u4e14\u6ca1\u6709sql\u6307\u4ee4\u3002<\/p>\n

 <\/p>\n

5\u3001\u53ef\u5c06\u67e5\u8be2\u5b58\u50a8\u5728\u4e00\u4e2a\u6587\u4ef6\u4e2d\u5e76\u544a\u8bc9mysql\u4ece\u6587\u4ef6\u4e2d\u8bfb\u53d6\u67e5\u8be2\u800c\u4e0d\u662f\u7b49\u5f85\u952e\u76d8\u8f93\u5165\u3002\u53ef\u5229\u7528\u5916\u58f3\u7a0b\u5e8f\u952e\u5165\u91cd\u5b9a\u5411\u5b9e\u7528\u7a0b\u5e8f\u6765\u5b8c\u6210\u8fd9\u9879\u5de5\u4f5c\u3002<\/span><\/p>\n

\u4f8b\u5982\uff0c\u5982\u679c\u5728\u6587\u4ef6my_file.sql \u4e2d\u5b58\u653e\u6709\u67e5<\/p>\n

\u8be2\uff0c\u53ef\u5982\u4e0b\u6267\u884c\u8fd9\u4e9b\u67e5\u8be2\uff1a<\/p>\n

\u4f8b\u5982\uff0c\u5982\u679c\u60a8\u60f3\u5c06\u5efa\u8868\u8bed\u53e5\u63d0\u524d\u5199\u5728sql.txt\u4e2d:<\/p>\n

mysql > mysql -h myhost -u root -p database < sql.txt<\/p>\n

 <\/p>\n

\u8f6c\u8f7d\u58f0\u660e\uff1a<\/strong>\u672c\u6587\u8f6c\u81eahttp:\/\/news.newhua.com\/news1\/program_database\/2009\/217\/0921715343537K7H7IDI2CCI09JCI1DK8FJ4B07B3A04219G561C3JAB.html<\/a><\/p>\n

================================================================================<\/p>\n

 <\/p>\n

\u8f6c mysql\u547d\u4ee4<\/strong><\/p>\n

 <\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>\u4e00 . \u5b89\u88c5\u4e0e\u914d\u7f6eMYSQL\u00a0<\/span>
\n\u3000\u3000\u4e8c . \u5e38\u7528mysql\u547d\u4ee4\u884c\u547d\u4ee4\u00a0<\/span>
\n<\/strong>\u3000\u30001 .mysql\u7684\u542f\u52a8\u4e0e\u505c\u6b62
\n\u542f\u52a8MYSQL\u670d\u52a1 net start mysql
\n\u505c\u6b62MYSQL\u670d\u52a1 net stop mysql<\/p>\n

2 . netstat \u2013na | findstr 3306 \u67e5\u770b\u88ab\u76d1\u542c\u7684\u7aef\u53e3 , findstr\u7528\u4e8e\u67e5\u627e\u540e\u9762\u7684\u7aef\u53e3\u662f\u5426\u5b58\u5728<\/p>\n

3 . \u5728\u547d\u4ee4\u884c\u4e2d\u767b\u9646MYSQL\u63a7\u5236\u53f0 , \u5373\u4f7f\u7528 MYSQL COMMEND LINE TOOL
\n\u8bed\u6cd5\u683c\u5f0f mysql \u2013user=root \u2013password=123456 db_name
\n\u6216 mysql \u2013u root \u2013p123456 db_name<\/p>\n

4 . \u8fdb\u5165MYSQL\u547d\u4ee4\u884c\u5de5\u5177\u540e , \u4f7f\u7528status; \u6216\/s \u67e5\u770b\u8fd0\u884c\u73af\u5883\u4fe1\u606f<\/p>\n

5 . \u5207\u6362\u8fde\u63a5\u6570\u636e\u5e93\u7684\u8bed\u6cd5 : use new_dbname;<\/p>\n

6 . \u663e\u793a\u6240\u6709\u6570\u636e\u5e93 : show databases;<\/p>\n

7 . \u663e\u793a\u6570\u636e\u5e93\u4e2d\u7684\u6240\u6709\u8868 : show tables;<\/p>\n

8 . \u663e\u793a\u67d0\u4e2a\u8868\u521b\u5efa\u65f6\u7684\u5168\u90e8\u4fe1\u606f : show create table table_name;<\/p>\n

9 . \u67e5\u770b\u8868\u7684\u5177\u4f53\u5c5e\u6027\u4fe1\u606f\u53ca\u8868\u4e2d\u5404\u5b57\u6bb5\u7684\u63cf\u8ff0
\nDescribe table_name; \u7f29\u5199\u5f62\u5f0f : desc table_name;<\/p>\n

\u3000\u3000\u4e09 \u3002 MySql\u4e2d\u7684SQL\u8bed\u53e5\u00a0<\/strong><\/span>
\n1 . \u6570\u636e\u5e93\u521b\u5efa : Create database db_name;
\n\u6570\u636e\u5e93\u5220\u9664 : Drop database db_name; \u5220\u9664\u65f6\u53ef\u5148\u5224\u65ad\u662f\u5426\u5b58\u5728\uff0c\u5199\u6210 : drop database if exits db_name<\/p>\n

2 . \u5efa\u8868 : \u521b\u5efa\u6570\u636e\u8868\u7684\u8bed\u6cd5 : create table table_name (\u5b57\u6bb51 \u6570\u636e\u7c7b\u578b , \u5b57\u6bb52 \u6570\u636e\u7c7b\u578b);
\n\u4f8b : create table mytable (id int , username char(20));
\n\u5220\u8868 : drop table table_name; \u4f8b : drop table mytable;<\/p>\n

8 . \u6dfb\u52a0\u6570\u636e : Insert into \u8868\u540d [(\u5b57\u6bb51 , \u5b57\u6bb52 , \u2026.)] values (\u503c1 , \u503c2 , \u2026..);
\n\u5982\u679c\u5411\u8868\u4e2d\u7684\u6bcf\u4e2a\u5b57\u6bb5\u90fd\u63d2\u5165\u4e00\u4e2a\u503c,\u90a3\u4e48\u524d\u9762 [ ] \u62ec\u53f7\u5185\u5b57\u6bb5\u540d\u53ef\u5199\u4e5f\u53ef\u4e0d\u5199
\n\u4f8b : insert into mytable (id,username) values (1,\u2019zhangsan\u2019);<\/p>\n

9 . \u67e5\u8be2 : \u67e5\u8be2\u6240\u6709\u6570\u636e : select * from table_name;
\n\u67e5\u8be2\u6307\u5b9a\u5b57\u6bb5\u7684\u6570\u636e : select \u5b57\u6bb51 , \u5b57\u6bb52 from table_name;
\n\u4f8b : select id,username from mytable where id=1 order by desc;\u591a\u8868\u67e5\u8be2\u8bed\u53e5————\u53c2\u7167\u7b2c17\u6761\u5b9e\u4f8b<\/p>\n

10 . \u66f4\u65b0\u6307\u5b9a\u6570\u636e , \u66f4\u65b0\u67d0\u4e00\u4e2a\u5b57\u6bb5\u7684\u6570\u636e\uff08\u6ce8\u610f\uff0c\u4e0d\u662f\u66f4\u65b0\u5b57\u6bb5\u7684\u540d\u5b57\uff09
\nUpdate table_name set \u5b57\u6bb5\u540d=\u2019\u65b0\u503c\u2019 [, \u5b57\u6bb52 =\u2019\u65b0\u503c\u2019 , \u2026..][where id=id_num] [order by \u5b57\u6bb5 \u987a\u5e8f]
\n\u4f8b : update mytable set username=\u2019lisi\u2019 where id=1;
\nOrder\u8bed\u53e5\u662f\u67e5\u8be2\u7684\u987a\u5e8f , \u5982 : order by id desc(\u6216asc) , \u987a\u5e8f\u6709\u4e24\u79cd : desc\u5012\u5e8f(100\u20141,\u5373\u4ece\u6700\u65b0\u6570\u636e\u5f80\u540e\u67e5\u8be2),asc(\u4ece1-100)\uff0cWhere\u548corder\u8bed\u53e5\u4e5f\u53ef\u7528\u4e8e\u67e5\u8be2select \u4e0e\u5220\u9664delete<\/p>\n

11 . \u5220\u9664\u8868\u4e2d\u7684\u4fe1\u606f :
\n\u5220\u9664\u6574\u4e2a\u8868\u4e2d\u7684\u4fe1\u606f : delete from table_name;
\n\u5220\u9664\u8868\u4e2d\u6307\u5b9a\u6761\u4ef6\u7684\u8bed\u53e5 : delete from table_name where \u6761\u4ef6\u8bed\u53e5 ; \u6761\u4ef6\u8bed\u53e5\u5982 : id=3;<\/p>\n

12 . \u521b\u5efa\u6570\u636e\u5e93\u7528\u6237
\n\u4e00\u6b21\u53ef\u4ee5\u521b\u5efa\u591a\u4e2a\u6570\u636e\u5e93\u7528\u6237\u5982\uff1a
\nCREATE USER username1 identified BY \u2018password\u2019 , username2 IDENTIFIED BY \u2018password\u2019\u2026.<\/p>\n

13 . \u7528\u6237\u7684\u6743\u9650\u63a7\u5236\uff1agrant
\n\u5e93\uff0c\u8868\u7ea7\u7684\u6743\u9650\u63a7\u5236 : \u5c06\u67d0\u4e2a\u5e93\u4e2d\u7684\u67d0\u4e2a\u8868\u7684\u63a7\u5236\u6743\u8d4b\u4e88\u67d0\u4e2a\u7528\u6237
\nGrant all ON db_name.table_name TO user_name [ indentified by \u2018password\u2019 ];<\/p>\n

14 . \u8868\u7ed3\u6784\u7684\u4fee\u6539
\n\uff081\uff09\u589e\u52a0\u4e00\u4e2a\u5b57\u6bb5\u683c\u5f0f\uff1a
\nalter table table_name add column (\u5b57\u6bb5\u540d \u5b57\u6bb5\u7c7b\u578b); —-\u6b64\u65b9\u6cd5\u5e26\u62ec\u53f7
\n\uff082\uff09\u6307\u5b9a\u5b57\u6bb5\u63d2\u5165\u7684\u4f4d\u7f6e\uff1a
\nalter table table_name add column \u5b57\u6bb5\u540d \u5b57\u6bb5\u7c7b\u578b after \u67d0\u5b57\u6bb5\uff1b
\n\u5220\u9664\u4e00\u4e2a\u5b57\u6bb5\uff1a
\nalter table table_name drop\u5b57\u6bb5\u540d;
\n\uff083\uff09\u4fee\u6539\u5b57\u6bb5\u540d\u79f0\/\u7c7b\u578b
\nalter table table_name change \u65e7\u5b57\u6bb5\u540d \u65b0\u5b57\u6bb5\u540d \u65b0\u5b57\u6bb5\u7684\u7c7b\u578b;
\n\uff084\uff09\u6539\u8868\u7684\u540d\u5b57
\nalter table table_name rename to new_table_name;
\n\uff085\uff09\u4e00\u6b21\u6027\u6e05\u7a7a\u8868\u4e2d\u7684\u6240\u6709\u6570\u636e
\ntruncate table table_name; \u6b64\u65b9\u6cd5\u4e5f\u4f1a\u4f7f\u8868\u4e2d\u7684\u53d6\u53f7\u5668(ID)\u4ece1\u5f00\u59cb<\/p>\n

15 . \u589e\u52a0\u4e3b\u952e\uff0c\u5916\u952e\uff0c\u7ea6\u675f\uff0c\u7d22\u5f15\u3002\u3002\u3002\u3002(\u4f7f\u7528\u65b9\u6cd5\u89c117\u5b9e\u4f8b)
\n\u2460 \u7ea6\u675f\uff08\u4e3b\u952ePrimary key\u3001\u552f\u4e00\u6027Unique\u3001\u975e\u7a7aNot Null\uff09
\n\u2461 \u81ea\u52a8\u589e\u5f20 auto_increment
\n\u2462\u5916\u952eForeign key—–\u4e0ereference table_name(col_name\u5217\u540d)\u914d\u5408\u4f7f\u7528\uff0c\u5efa\u8868\u65f6\u5355\u72ec\u4f7f\u7528
\n\u2463 \u5220\u9664\u591a\u4e2a\u8868\u4e2d\u6709\u5173\u8054\u7684\u6570\u636e—-\u8bbe\u7f6eforeign key \u4e3aset null —\u5177\u4f53\u8bbe\u7f6e\u53c2\u8003\u5e2e\u52a9\u6587\u6863<\/p>\n

16 . \u67e5\u770b\u6570\u636e\u5e93\u5f53\u524d\u5f15\u64ce
\nSHOW CREATE TABLE table_name;
\n\u4fee\u6539\u6570\u636e\u5e93\u5f15\u64ce
\nALTER TABLE table_name ENGINE=MyISAM | InnoDB;<\/p>\n

17 . SQL\u8bed\u53e5\u8fd0\u7528\u5b9e\u4f8b:
\n–1 \u5efausers\u8868
\ncreate table users (id int primary key auto_increment,nikename varchar(20) not null unique,password varchar(100) not null,address varchar(200), reg_date timestamp not null default CURRENT_TIMESTAMP);<\/p>\n

–2 \u5efaarticles\u8868,\u5728\u5efa\u8868\u65f6\u8bbe\u7f6e\u5916\u952e
\ncreate table articles (id int primary key auto_increment,content longtext not null,userid int,constraint foreign key (userid) references users(id) on delete set null);<\/p>\n

———————————————————————–
\n–2.1 \u5efaarticles\u8868,\u5efa\u8868\u65f6\u4e0d\u8bbe\u7f6e\u5916\u952e
\ncreate table articles (id int primary key auto_increment,content longtext not null,userid int);
\n–2.2 \u7ed9articles\u8868\u8bbe\u7f6e\u5916\u952e
\nalter table articles add constraint foreign key (userid) references users(id) on delete set null;
\n————————————————————————<\/p>\n

–3. \u5411users\u8868\u4e2d\u63d2\u5165\u6570\u636e,\u540c\u65f6\u63d2\u5165\u591a\u6761
\ninsert into users (id,nikename,password,address) values (1,’lyh1′,’1234′,null),(10,’lyh22′,’4321′,’\u6e56\u5317\u6b66\u6c49’),(null,’lyh333′,’5678′, ‘\u5317\u4eac\u6d77\u6dc0’);<\/p>\n

–4. \u5411article\u4e2d\u63d2\u5165\u4e09\u6761\u6570\u636e
\ninsert into articles (id,content,userid) values (2,’hahahahahaha’,11),(null,’xixixixixix’,10),(13,’aiaiaiaiaiaiaiaiaiaiaiaia’,1),(14,’hohoahaoaoooooooooo’,10);<\/p>\n

–5. \u8fdb\u884c\u591a\u8868\u67e5\u8be2\uff0c\u9009\u62e9users\u8868\u4e2dID=10\u7684\u7528\u6237\u53d1\u5e03\u7684\u6240\u6709\u7559\u8a00\u53ca\u8be5\u7528\u6237\u7684\u6240\u6709\u4fe1\u606f
\nselect articles.id,articles.content,users.* from users,articles where users.id=10 and articles.userid=users.id order by articles.id desc;<\/p>\n

–6. \u67e5\u770b\u6570\u636e\u5e93\u5f15\u64ce\u7c7b\u578b
\nshow create table users;<\/p>\n

–7. \u4fee\u6539\u6570\u636e\u5e93\u5f15\u64ce\u7c7b\u578b
\nalter table users engine=MyISAM;\u00a0—\u56e0\u4e3ausers\u8868\u4e2dID\u88ab\u8bbe\u7f6e\u6210\u5916\u952e\uff0c\u6267\u884c\u6b64\u53e5\u4f1a\u51fa\u9519<\/p>\n

–8. \u540c\u8868\u67e5\u8be2,\u5df2\u77e5\u4e00\u4e2a\u6761\u4ef6\u7684\u60c5\u51b5\u4e0b.\u67e5\u8be2ID\u53f7\u5927\u4e8e\u7528\u6237lyh1\u7684ID\u53f7\u7684\u6240\u6709\u7528\u6237
\nselect a.id,a.nikename,a.address from users a,users b where b.nikename=’lyh1′ and a.id>b.id;
\n——\u4e5f\u53ef\u5199\u6210
\nselect id,nikename,address from users where id>(select id from users where nikename=’lyh1′);<\/p>\n

9. \u663e\u793a\u5e74\u9f84\u6bd4\u9886\u5bfc\u8fd8\u5927\u7684\u5458\u5de5\uff1a
\nselect a.name from users a,users b where a.managerid=b.id and a.age>b.age;<\/p>\n

\u67e5\u8be2\u7f16\u53f7\u4e3a2\u7684\u53d1\u5e16\u4eba: \u5148\u67e5articles\u8868,\u5f97\u5230\u53d1\u5e16\u4eba\u7684\u7f16\u53f7,\u518d\u6839\u636e\u7f16\u53f7\u67e5users\u5f97\u5230\u7684\u7528\u6237\u540d\u3002
\n\u63a5\u7740\u7528\u5173\u8054\u67e5\u8be2.
\nselect * from articles,users\u5f97\u5230\u7b1b\u5361\u513f\u79ef,\u518d\u52a0order by articles.id\u4ee5\u4fbf\u89c2\u5bdf<\/p>\n

\u4f7f\u7528select * from articles,users where articles.id=2 \u7b5b\u9009\u51fa2\u53f7\u5e16\u5b50\u4e0e\u6bcf\u4e2a\u7528\u6237\u7684\u7ec4\u5408\u8bb0\u5f55<\/p>\n

\u518d\u4f7f\u7528select * from articles,users where articles.id=2 and articles.userid=users.id\u9009\u51fausers.id\u7b49\u4e8e2\u53f7\u5e16\u7684\u53d1\u5e16\u4ebaid\u7684\u8bb0\u5f55.<\/p>\n

\u53ea\u53d6\u7528\u6237\u540d:select user where user.id=(select userid from articles where article.id =2)<\/p>\n

\u627e\u51fa\u5e74\u9f84\u6bd4\u5c0f\u738b\u8fd8\u5927\u7684\u4eba:\u5047\u8bbe\u5c0f\u738b\u662f28\u5c81,\u5148\u60f3\u627e\u51fa\u5e74\u9f84\u5927\u4e8e28\u7684\u4eba
\nselect * from users where age>(select age from users where name=’xiaowang’);
\n*****\u8981\u67e5\u8be2\u7684\u8bb0\u5f55\u9700\u8981\u53c2\u7167\u8868\u91cc\u9762\u7684\u5176\u4ed6\u8bb0\u5f55:
\nselect a.name from users a,users b where b.name=’xiaowang’ and a.age>b.age<\/p>\n

\u8868\u91cc\u7684\u6bcf\u4e2a\u7528\u6237\u90fd\u60f3pk\u4e00\u4e0b.select a.nickname,b.nickname from users a,users b where a.id>b.id ;<\/p>\n

\u66f4\u4fdd\u9669\u7684\u8bed\u53e5:select a.nickname,b.nickname from (select * from users order by id) a,(se
\nlect * from users order by id) b where a.id>b.id ;<\/p>\n

\u518d\u67e5\u8be2\u67d0\u4e2a\u4eba\u53d1\u7684\u6240\u6709\u5e16\u5b50.
\nselect b.* from articles a , articles b where a.id=2 and a.userid=b.userid<\/p>\n

\u8bf4\u660e: \u8868\u4e4b\u95f4\u5b58\u5728\u7740\u5173\u7cfb\uff0cER\u6982\u5ff5\u7684\u89e3\u91ca\uff0c\u7528access\u4e2d\u7684\u793a\u4f8b\u6570\u636e\u5e93\u6f14\u793a\u8868\u4e4b\u95f4\u7684\u5173\u7cfb.\u53ea\u6709innodb\u5f15\u64ce\u624d\u652f\u6301foreign key\uff0cmysql\u7684\u4efb\u4f55\u5f15\u64ce\u76ee\u524d\u90fd\u4e0d\u652f\u6301check\u7ea6\u675f\u3002
\n\u3000\u3000\u56db\u3001\u5b57\u7b26\u96c6\u51fa\u73b0\u9519\u8bef\u89e3\u51b3\u529e\u6cd5\u00a0<\/span>
\n\u51fa\u73b0\u7684\u95ee\u9898\uff1a
\nmysql> update users
\n-> set username=’\u5173\u7fbd’
\n-> where userid=2;
\nERROR 1366 (HY000): Incorrect string value: ‘\/xB9\/xD8\/xD3\/xF0’ for column ‘usern
\name’ at row 1
\n\u5411\u8868\u4e2d\u63d2\u5165\u4e2d\u6587\u5b57\u7b26\u65f6\uff0c\u51fa\u73b0\u9519\u8bef\u3002<\/p>\n

mysql> select * from users;
\n+——–+———-+
\n| userid | username |
\n+——–+———-+
\n| 2 | ???? |
\n| 3 | ???? |
\n| 4 | ?\u00ed?\u00f9 |
\n+——–+———-+
\n3 rows in set (0.00 sec)
\n\u8868\u4e2d\u7684\u4e2d\u6587\u5b57\u7b26\u4f4d\u4e71\u7801\u3002
\n\u89e3\u51b3\u529e\u6cd5\uff1a
\n\u4f7f\u7528\u547d\u4ee4\uff1a
\nmysql> status;
\n————–
\nmysql Ver 14.12 Distrib 5.0.45, for Win32 (ia32)<\/p>\n

Connection id: 8
\nCurrent database: test
\nCurrent user: root@localhost
\nSSL: Not in use
\nUsing delimiter: ;
\nServer version: 5.0.45-community-nt MySQL Community Edition (GPL)
\nProtocol version: 10
\nConnection: localhost via TCP\/IP
\nServer characterset: latin1
\nDb characterset: latin1
\nClient characterset: gbk
\nConn. characterset: gbk
\nTCP port: 3306
\nUptime: 7 hours 39 min 19 sec
\nThreads: 2 Questions: 174 Slow queries: 0 Opens: 57 Flush tables: 1 Open ta
\nbles: 1 Queries per second avg: 0.006
\n————–
\n\u67e5\u770bmysql\u53d1\u73b0Server characterset\uff0cDb characterset\u7684\u5b57\u7b26\u96c6\u8bbe\u6210\u4e86latin1\uff0c\u6240\u4ee5\u51fa\u73b0\u4e2d\u6587\u4e71\u7801\u3002<\/p>\n

mysql> show tables;
\n+—————-+
\n| Tables_in_test |
\n+—————-+
\n| users |
\n+—————-+
\n1 row in set (0.00 sec)<\/p>\n

\u66f4\u6539\u8868\u7684\u5b57\u7b26\u96c6\u3002
\nmysql> alter table users character set GBK;
\nQuery OK, 3 rows affected (0.08 sec)
\nRecords: 3 Duplicates: 0 Warnings: 0<\/p>\n

\u67e5\u770b\u8868\u7684\u7ed3\u6784\uff1a
\nmysql> show create users;
\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
\ncorresponds to your MySQL server version for the right syntax to use near ‘users
\n‘ at line 1
\nmysql> show create table users;
\n+——-+———————————————————————–
\n——————————————————————————+
\n| Table | Create Table
\n|
\n+——-+———————————————————————–
\n——————————————————————————+
\n| users | CREATE TABLE `users` (
\n`userid` int(11) default NULL,
\n`username` char(20) character set latin1 default NULL
\n) ENGINE=InnoDB DEFAULT CHARSET=gbk |
\n+——-+———————————————————————–
\n——————————————————————————+
\n1 row in set (0.00 sec)<\/p>\n

mysql> desc users;
\n+———-+———-+——+—–+———+——-+
\n| Field | Type | Null | Key | Default | Extra |
\n+———-+———-+——+—–+———+——-+
\n| userid | int(11) | YES | | NULL | |
\n| username | char(20) | YES | | NULL | |
\n+———-+———-+——+—–+———+——-+
\n2 rows in set (0.02 sec)<\/p>\n

\u8fd9\u65f6\u5411\u8868\u4e2d\u63d2\u5165\u4e2d\u6587\u7136\u540e\u6709\u9519\u8bef\u3002
\nmysql> insert into users values(88,’\u4e2d\u6587’);
\nERROR 1366 (HY000): Incorrect string value: ‘\/xD6\/xD0\/xCE\/xC4’ for column ‘usern
\name’ at row 1
\nmysql> insert into users values(88,’\u4e2d\u6587’);
\nERROR 1366 (HY000): Incorrect string value: ‘\/xD6\/xD0\/xCE\/xC4’ for column ‘usern
\name’ at row 1<\/p>\n

\u8fd8\u8981\u66f4\u6539users\u8868\u7684username\u7684\u5b57\u7b26\u96c6\u3002
\nmysql> alter table users modify username char(20) character set gbk;
\nERROR 1366 (HY000): Incorrect string value: ‘\/xC0\/xEE\/xCB\/xC4’ for column ‘usern
\name’ at row 1
\nmysql> alter table users modify username char(20) character set gbk;
\nERROR 1366 (HY000): Incorrect string value: ‘\/xC0\/xEE\/xCB\/xC4’ for column ‘usern
\name’ at row 1<\/p>\n

\u56e0\u4e3a\u8868\u4e2d\u5df2\u7ecf\u6709\u6570\u636e\uff0c\u6240\u4ee5\u66f4\u6539username\u5b57\u7b26\u96c6\u7684\u64cd\u4f5c\u6ca1\u6709\u6210***
\n\u6e05\u7a7ausers\u8868\u4e2d\u7684\u6570\u636e
\nmysql> truncate table users;
\nQuery OK, 3 rows affected (0.01 sec)<\/p>\n

\u4ece\u65b0\u66f4\u6539user\u8868\u4e2dusername\u7684\u5b57\u7b26\u96c6
\nmysql> alter table users modify username char(20) character set gbk;
\nQuery OK, 0 rows affected (0.06 sec)
\nRecords: 0 Duplicates: 0 Warnings: 0<\/p>\n

\u8fd9\u65f6\u518d\u63d2\u5165\u4e2d\u6587\u5b57\u7b26\uff0c\u63d2\u5165\u6210***\u3002
\nmysql> insert into users values(88,’\u4e2d\u6587’);
\nQuery OK, 1 row affected (0.01 sec)<\/p>\n

mysql> select * from users;
\n+——–+———-+
\n| userid | username |
\n+——–+———-+
\n| 88 | \u4e2d\u6587 |
\n+——–+———-+
\n1 row in set (0.00 sec)
\nmysql><\/p>\n

\u8f6c\u8f7d\u58f0\u660e\uff1a<\/strong>\u672c\u6587\u8f6c\u81eahttp:\/\/hi.baidu.com\/zhjlabm\/blog\/item\/b939fc3307a1d445ad4b5fbd.html<\/a><\/p>\n

================================================================================<\/p>\n

 <\/p>\n

\u5b66\u4e60MySQL\u5e38\u7528\u64cd\u4f5c\u547d\u4ee4<\/strong><\/span><\/p>\n

 <\/p>\n

1\u3001\u542f\u52a8MySQL\u670d\u52a1\u5668<\/span><\/p>\n

\u5b9e\u9645\u4e0a\u4e0a\u7bc7\u5df2\u8bb2\u5230\u5982\u4f55\u542f\u52a8MySQL\u3002\u4e24\u79cd\u65b9\u6cd5\uff1a \u4e00\u662f\u7528winmysqladmin\uff0c\u5982\u679c\u673a\u5668\u542f\u52a8\u65f6\u5df2\u81ea\u52a8\u8fd0\u884c\uff0c\u5219\u53ef\u76f4\u63a5\u8fdb\u5165\u4e0b\u4e00\u6b65\u64cd\u4f5c\u3002 \u4e8c\u662f\u5728DOS\u65b9\u5f0f\u4e0b\u8fd0\u884c d:mysqlbinmysqld<\/p>\n

 <\/p>\n

2\u3001\u8fdb\u5165mysql\u4ea4\u4e92\u64cd\u4f5c\u754c\u9762<\/span><\/p>\n

\u5728DOS\u65b9\u5f0f\u4e0b\uff0c\u8fd0\u884c\uff1a d:mysqlbinmysql<\/p>\n

\u51fa\u73b0: mysql \u7684\u63d0\u793a\u7b26\uff0c\u6b64\u65f6\u5df2\u8fdb\u5165mysql\u7684\u4ea4\u4e92\u64cd\u4f5c\u65b9\u5f0f\u3002<\/p>\n

\u5982\u679c\u51fa\u73b0 “ERROR 2003: Can\u2032t connect to MySQL server on \u2032localhost\u2032 (10061)\u201c\uff0c<\/p>\n

\u8bf4\u660e\u4f60\u7684MySQL\u8fd8\u6ca1\u6709\u542f\u52a8\u3002<\/p>\n

 <\/p>\n

3\u3001\u9000\u51faMySQL\u64cd\u4f5c\u754c\u9762<\/span><\/p>\n

\u5728mysql>\u63d0\u793a\u7b26\u4e0b\u8f93\u5165quit\u53ef\u4ee5\u968f\u65f6\u9000\u51fa\u4ea4\u4e92\u64cd\u4f5c\u754c\u9762\uff1a
\nmysql> quit
\nBye
\n\u4f60\u4e5f\u53ef\u4ee5\u7528control-D\u9000\u51fa\u3002<\/p>\n

 <\/p>\n

4\u3001\u7b2c\u4e00\u6761\u547d\u4ee4<\/span><\/p>\n

mysql> select version(),current_date();
\n+—————-+—————–+
\n| version() | current_date() |
\n+—————-+—————–+
\n| 3.23.25a-debug | 2001-05-17 |
\n+—————-+—————–+
\n1 row in set (0.01 sec)
\nmysql><\/p>\n

\u6b64\u547d\u4ee4\u8981\u6c42mysql\u670d\u52a1\u5668\u544a\u8bc9\u4f60\u5b83\u7684\u7248\u672c\u53f7\u548c\u5f53\u524d\u65e5\u671f\u3002\u5c1d\u8bd5\u7528\u4e0d\u540c\u5927\u5c0f\u5199\u64cd\u4f5c\u4e0a\u8ff0\u547d\u4ee4\uff0c\u770b\u7ed3\u679c\u5982\u4f55\u3002\u7ed3\u679c\u8bf4\u660emysql\u547d\u4ee4\u7684\u5927\u5c0f\u5199\u7ed3\u679c\u662f\u4e00\u81f4\u7684\u3002<\/p>\n

\u7ec3\u4e60\u5982\u4e0b\u64cd\u4f5c\uff1a<\/p>\n

mysql>Select (20+5)*4;
\nmysql>Select (20+5)*4,sin(pi()\/3);
\nmysql>Select (20+5)*4 AS Result,sin(pi()\/3); (AS: \u6307\u5b9a\u5047\u540d\u4e3aResult)<\/p>\n

 <\/p>\n

5\u3001\u591a\u884c\u8bed\u53e5<\/span>
\n\u4e00\u6761\u547d\u4ee4\u53ef\u4ee5\u5206\u6210\u591a\u884c\u8f93\u5165\uff0c\u76f4\u5230\u51fa\u73b0\u5206\u53f7\u201c\uff1b\u201d\u4e3a\u6b62\uff1a
\n<ccid_nobr>
\n<table width=”400″ border=”1″ cellspacing=”0″ cellpadding=”2″
\nbordercolorlight = “black” bordercolordark = “#FFFFFF” align=”center”>
\n<tr>
\n<td bgcolor=”e6e6e6″ class=”code” style=”font-size:9pt”>
\n<pre><ccid_code> mysql> select
\n-> USER()
\n-> ,
\n-> now()
\n->;
\n+——————–+———————+
\n| USER() | now() |
\n+——————–+———————+
\n| ODBC@localhost | 2001-05-17 22:59:15 |
\n+——————–+———————+
\n1 row in set (0.06 sec)
\nmysql><\/p>\n

\u6ce8\u610f\u4e2d\u95f4\u7684\u9017\u53f7\u548c\u6700\u540e\u7684\u5206\u53f7\u7684\u4f7f\u7528\u65b9\u6cd5\u3002<\/p>\n

 <\/p>\n

6\u3001\u4e00\u884c\u591a\u547d\u4ee4<\/span><\/p>\n

\u8f93\u5165\u5982\u4e0b\u547d\u4ee4\uff1a<\/p>\n

mysql> SELECT USER(); SELECT NOW();
\n+——————+
\n| USER() |
\n+——————+
\n| ODBC@localhost |
\n+——————+
\n1 row in set (0.00 sec)<\/p>\n

+———————+
\n| NOW() |
\n+———————+
\n| 2001-05-17 23:06:15 |
\n+———————+
\n1 row in set (0.00 sec)
\nmysql><\/p>\n

\u6ce8\u610f\u4e2d\u95f4\u7684\u5206\u53f7\uff0c\u547d\u4ee4\u4e4b\u95f4\u7528\u5206\u53f7\u9694\u5f00\u3002<\/p>\n

 <\/p>\n

7\u3001\u663e\u793a\u5f53\u524d\u5b58\u5728\u7684\u6570\u636e\u5e93<\/span><\/p>\n

mysql> show databases;
\n+———-+
\n| Database |
\n+———-+
\n| mysql |
\n| test |
\n+———-+
\n2 row in set (0.06 sec)
\nmysql><\/p>\n

8\u3001\u9009\u62e9\u6570\u636e\u5e93\u5e76\u663e\u793a\u5f53\u524d\u9009\u62e9\u7684\u6570\u636e\u5e93<\/span><\/p>\n

mysql> USE mysql
\nDatabase changed
\nmysql>
\n(USE \u548c QUIT \u547d\u4ee4\u4e0d\u9700\u8981\u5206\u53f7\u7ed3\u675f\u3002\uff09
\nmysql> select database();
\n+—————+
\n| database() |
\n+—————+
\n| mysql |
\n+—————+
\n1 row in set (0.00 sec)<\/p>\n

9\u3001\u663e\u793a\u5f53\u524d\u6570\u636e\u5e93\u4e2d\u5b58\u5728\u7684\u8868\u00a0<\/span>
\nmysql> SHOW TABLES;<\/p>\n

 <\/p>\n

10\u3001\u663e\u793a\u8868(db)\u7684\u5185\u5bb9\u00a0<\/span>
\nmysql>select * from db;<\/p>\n

 <\/p>\n

11\u3001\u547d\u4ee4\u7684\u53d6\u6d88<\/span><\/p>\n

\u5f53\u547d\u4ee4\u8f93\u5165\u9519\u8bef\u800c\u53c8\u65e0\u6cd5\u6539\u53d8\uff08\u591a\u884c\u8bed\u53e5\u60c5\u5f62\uff09\u65f6\uff0c\u53ea\u8981\u5728\u5206\u53f7\u51fa\u73b0\u524d\u5c31\u53ef\u4ee5\u7528 c\u6765\u53d6\u6d88\u8be5\u6761\u547d\u4ee4<\/p>\n

mysql> select
\n-> user()
\n-> c
\nmysql><\/p>\n

\u8fd9\u662f\u4e00\u4e9b\u6700\u5e38\u7528\u7684\u6700\u57fa\u672c\u7684\u64cd\u4f5c\u547d\u4ee4\uff0c\u901a\u8fc7\u591a\u6b21\u7ec3\u4e60\u5c31\u53ef\u4ee5\u7262\u7262\u638c\u6342\u4e86<\/p>\n

 <\/p>\n

==========================================================================<\/p>\n

 <\/p>\n

mysql\u547d\u4ee4<\/strong><\/span><\/p>\n

 <\/p>\n

\u6d4b\u8bd5\u73af\u5883\uff1amysql 5.0.45
\n\u3010\u6ce8\uff1a\u53ef\u4ee5\u5728mysql\u4e2d\u901a\u8fc7mysql> SELECT VERSION();\u6765\u67e5\u770b\u6570\u636e\u5e93\u7248\u672c\u3011
\n\u6574\u7406\uff1aleo<\/p>\n

\u4e00\u3001\u8fde\u63a5MYSQL\u3002<\/strong><\/span>
\n\u683c\u5f0f\uff1a\u00a0mysql -h\u4e3b\u673a\u5730\u5740 -u\u7528\u6237\u540d \uff0dp\u7528\u6237\u5bc6\u7801<\/p>\n

1\u3001\u8fde\u63a5\u5230\u672c\u673a\u4e0a\u7684MYSQL\u3002
\n\u9996\u5148\u6253\u5f00DOS\u7a97\u53e3\uff0c\u7136\u540e\u8fdb\u5165\u76ee\u5f55mysql\/bin\uff0c\u518d\u952e\u5165\u547d\u4ee4mysql -u root -p\uff0c\u56de\u8f66\u540e\u63d0\u793a\u4f60\u8f93\u5bc6\u7801.\u6ce8\u610f\u7528\u6237\u540d\u524d\u53ef\u4ee5\u6709\u7a7a\u683c\u4e5f\u53ef\u4ee5\u6ca1\u6709\u7a7a\u683c\uff0c\u4f46\u662f\u5bc6\u7801\u524d\u5fc5\u987b\u6ca1\u6709\u7a7a\u683c\uff0c\u5426\u5219\u8ba9\u4f60\u91cd\u65b0\u8f93\u5165\u5bc6\u7801.
\n\u5982\u679c\u521a\u5b89\u88c5\u597dMYSQL\uff0c\u8d85\u7ea7\u7528\u6237root\u662f\u6ca1\u6709\u5bc6\u7801\u7684\uff0c\u6545\u76f4\u63a5\u56de\u8f66\u5373\u53ef\u8fdb\u5165\u5230MYSQL\u4e2d\u4e86\uff0cMYSQL\u7684\u63d0\u793a\u7b26\u662f\uff1a mysql>
\n2\u3001\u8fde\u63a5\u5230\u8fdc\u7a0b\u4e3b\u673a\u4e0a\u7684MYSQL\u3002\u5047\u8bbe\u8fdc\u7a0b\u4e3b\u673a\u7684IP\u4e3a\uff1a110.110.110.110\uff0c\u7528\u6237\u540d\u4e3aroot,\u5bc6\u7801\u4e3aabcd123\u3002\u5219\u952e\u5165\u4ee5\u4e0b\u547d\u4ee4\uff1a
\nmysql -h110.110.110.110 -u root -p 123;\u00a0\uff08\u6ce8:u\u4e0eroot\u4e4b\u95f4\u53ef\u4ee5\u4e0d\u7528\u52a0\u7a7a\u683c\uff0c\u5176\u5b83\u4e5f\u4e00\u6837\uff09
\n3\u3001\u9000\u51faMYSQL\u547d\u4ee4\uff1a exit \uff08\u56de\u8f66\uff09<\/p>\n

\u4e8c\u3001\u4fee\u6539\u5bc6\u7801\u3002<\/strong><\/span>
\n\u683c\u5f0f\uff1amysqladmin -u\u7528\u6237\u540d -p\u65e7\u5bc6\u7801 password \u65b0\u5bc6\u7801
\n1\u3001\u7ed9root\u52a0\u4e2a\u5bc6\u7801ab12\u3002\u9996\u5148\u5728DOS\u4e0b\u8fdb\u5165\u76ee\u5f55mysql\/bin\uff0c\u7136\u540e\u952e\u5165\u4ee5\u4e0b\u547d\u4ee4
\nmysqladmin -u root -password ab12
\n\u6ce8\uff1a\u56e0\u4e3a\u5f00\u59cb\u65f6root\u6ca1\u6709\u5bc6\u7801\uff0c\u6240\u4ee5-p\u65e7\u5bc6\u7801\u4e00\u9879\u5c31\u53ef\u4ee5\u7701\u7565\u4e86\u3002
\n2\u3001\u518d\u5c06root\u7684\u5bc6\u7801\u6539\u4e3adjg345\u3002
\nmysqladmin -u root -p ab12 password djg345<\/p>\n

\u4e09\u3001\u589e\u52a0\u65b0\u7528\u6237\u3002<\/strong><\/span>
\n\uff08\u6ce8\u610f\uff1a\u548c\u4e0a\u9762\u4e0d\u540c\uff0c\u4e0b\u9762\u7684\u56e0\u4e3a\u662fMYSQL\u73af\u5883\u4e2d\u7684\u547d\u4ee4\uff0c\u6240\u4ee5\u540e\u9762\u90fd\u5e26\u4e00\u4e2a\u5206\u53f7\u4f5c\u4e3a\u547d\u4ee4\u7ed3\u675f\u7b26\uff09
\n\u683c\u5f0f\uff1agrant select on \u6570\u636e\u5e93.* to \u7528\u6237\u540d@\u767b\u5f55\u4e3b\u673a identified by \u201c\u5bc6\u7801\u201d
\n1\u3001\u589e\u52a0\u4e00\u4e2a\u7528\u6237test1\u5bc6\u7801\u4e3aabc\uff0c\u8ba9\u4ed6\u53ef\u4ee5\u5728\u4efb\u4f55\u4e3b\u673a\u4e0a\u767b\u5f55\uff0c\u5e76\u5bf9\u6240\u6709\u6570\u636e\u5e93\u6709\u67e5\u8be2\u3001\u63d2\u5165\u3001\u4fee\u6539\u3001\u5220\u9664\u7684\u6743\u9650\u3002\u9996\u5148\u7528root\u7528\u6237\u8fde\u5165MYSQL\uff0c\u7136\u540e\u952e\u5165\u4ee5\u4e0b\u547d\u4ee4\uff1a
\ngrant select,insert,update,delete on *.* to [email=test1@\u201d%]test1@\u201d%[\/email]\u201d Identified by \u201cabc\u201d;
\n\u4f46\u589e\u52a0\u7684\u7528\u6237\u662f\u5341\u5206\u5371\u9669\u7684\uff0c\u4f60\u60f3\u5982\u67d0\u4e2a\u4eba\u77e5\u9053test1\u7684\u5bc6\u7801\uff0c\u90a3\u4e48\u4ed6\u5c31\u53ef\u4ee5\u5728internet\u4e0a\u7684\u4efb\u4f55\u4e00\u53f0\u7535\u8111\u4e0a\u767b\u5f55\u4f60\u7684mysql\u6570\u636e\u5e93\u5e76\u5bf9\u4f60\u7684\u6570\u636e\u53ef\u4ee5\u4e3a\u6240\u6b32\u4e3a\u4e86\uff0c\u89e3\u51b3\u529e\u6cd5\u89c12\u3002<\/p>\n

2\u3001\u589e\u52a0\u4e00\u4e2a\u7528\u6237test2\u5bc6\u7801\u4e3aabc,\u8ba9\u4ed6\u53ea\u53ef\u4ee5\u5728localhost\u4e0a\u767b\u5f55\uff0c\u5e76\u53ef\u4ee5\u5bf9\u6570\u636e\u5e93mydb\u8fdb\u884c\u67e5\u8be2\u3001\u63d2\u5165\u3001\u4fee\u6539\u3001\u5220\u9664\u7684\u64cd\u4f5c\uff08localhost\u6307\u672c\u5730\u4e3b\u673a\uff0c\u5373MYSQL\u6570\u636e\u5e93\u6240\u5728\u7684\u90a3\u53f0\u4e3b\u673a\uff09\uff0c
\n\u8fd9\u6837\u7528\u6237\u5373\u4f7f\u7528\u77e5\u9053test2\u7684\u5bc6\u7801\uff0c\u4ed6\u4e5f\u65e0\u6cd5\u4eceinternet\u4e0a\u76f4\u63a5\u8bbf\u95ee\u6570\u636e\u5e93\uff0c\u53ea\u80fd\u901a\u8fc7MYSQL\u4e3b\u673a\u4e0a\u7684web\u9875\u6765\u8bbf\u95ee\u4e86\u3002
\ngrant select,insert,update,delete on mydb.* to [email=test2@localhost]test2@localhost[\/email] identified by \u201cabc\u201d;
\n\u5982\u679c\u4f60\u4e0d\u60f3test2\u6709\u5bc6\u7801\uff0c\u53ef\u4ee5\u518d\u6253\u4e00\u4e2a\u547d\u4ee4\u5c06\u5bc6\u7801\u6d88\u6389\u3002
\ngrant select,insert,update,delete on mydb.* to [email=test2@localhost]test2@localhost[\/email] identified by \u201c\u201d;
\n\u4e0b\u7bc7\u6211\u662fMYSQL\u4e2d\u6709\u5173\u6570\u636e\u5e93\u65b9\u9762\u7684\u64cd\u4f5c\u3002\u6ce8\u610f\uff1a\u4f60\u5fc5\u987b\u9996\u5148\u767b\u5f55\u5230MYSQL\u4e2d\uff0c\u4ee5\u4e0b\u64cd\u4f5c\u90fd\u662f\u5728MYSQL\u7684\u63d0\u793a\u7b26\u4e0b\u8fdb\u884c\u7684\uff0c\u800c\u4e14\u6bcf\u4e2a\u547d\u4ee4\u4ee5\u5206\u53f7\u7ed3\u675f\u3002<\/p>\n

\u4e00\u3001\u64cd\u4f5c\u6280\u5de7<\/strong><\/span>
\n1\u3001\u5982\u679c\u4f60\u6253\u547d\u4ee4\u65f6\uff0c\u56de\u8f66\u540e\u53d1\u73b0\u5fd8\u8bb0\u52a0\u5206\u53f7\uff0c\u4f60\u65e0\u987b\u91cd\u6253\u4e00\u904d\u547d\u4ee4\uff0c\u53ea\u8981\u6253\u4e2a\u5206\u53f7\u56de\u8f66\u5c31\u53ef\u4ee5\u4e86\u3002
\n\u4e5f\u5c31\u662f\u8bf4\u4f60\u53ef\u4ee5\u628a\u4e00\u4e2a\u5b8c\u6574\u7684\u547d\u4ee4\u5206\u6210\u51e0\u884c\u6765\u6253\uff0c\u5b8c\u540e\u7528\u5206\u53f7\u4f5c\u7ed3\u675f\u6807\u5fd7\u5c31OK\u3002
\n2\u3001\u4f60\u53ef\u4ee5\u4f7f\u7528\u5149\u6807\u4e0a\u4e0b\u952e\u8c03\u51fa\u4ee5\u524d\u7684\u547d\u4ee4\u3002<\/p>\n

\u4e8c\u3001\u663e\u793a\u547d\u4ee4<\/strong><\/span>
\n1\u3001\u663e\u793a\u5f53\u524d\u6570\u636e\u5e93\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\u5217\u8868\uff1a
\nmysql> SHOW DATABASES;
\n\u6ce8\u610f\uff1amysql\u5e93\u91cc\u9762\u6709MYSQL\u7684\u7cfb\u7edf\u4fe1\u606f\uff0c\u6211\u4eec\u6539\u5bc6\u7801\u548c\u65b0\u589e\u7528\u6237\uff0c\u5b9e\u9645\u4e0a\u5c31\u662f\u7528\u8fd9\u4e2a\u5e93\u8fdb\u884c\u64cd\u4f5c\u3002<\/p>\n

2\u3001\u663e\u793a\u6570\u636e\u5e93\u4e2d\u7684\u6570\u636e\u8868\uff1a
\nmysql> USE \u5e93\u540d\uff1b
\nmysql> SHOW TABLES;<\/p>\n

3\u3001\u663e\u793a\u6570\u636e\u8868\u7684\u7ed3\u6784\uff1a
\nmysql> DESCRIBE \u8868\u540d;<\/p>\n

4\u3001\u5efa\u7acb\u6570\u636e\u5e93\uff1a
\nmysql> CREATE DATABASE \u5e93\u540d;<\/p>\n

5\u3001\u5efa\u7acb\u6570\u636e\u8868\uff1a
\nmysql> USE \u5e93\u540d;
\nmysql> CREATE TABLE \u8868\u540d (\u5b57\u6bb5\u540d VARCHAR(20), \u5b57\u6bb5\u540d CHAR(1));<\/p>\n

6\u3001\u5220\u9664\u6570\u636e\u5e93\uff1a
\nmysql> DROP DATABASE \u5e93\u540d;<\/p>\n

7\u3001\u5220\u9664\u6570\u636e\u8868\uff1a
\nmysql> DROP TABLE \u8868\u540d\uff1b<\/p>\n

8\u3001\u5c06\u8868\u4e2d\u8bb0\u5f55\u6e05\u7a7a\uff1a
\nmysql> DELETE FROM \u8868\u540d;<\/p>\n

9\u3001\u663e\u793a\u8868\u4e2d\u7684\u8bb0\u5f55\uff1a
\nmysql> SELECT * FROM \u8868\u540d;<\/p>\n

10\u3001\u5f80\u8868\u4e2d\u63d2\u5165\u8bb0\u5f55\uff1a
\nmysql> INSERT INTO \u8868\u540d VALUES (\u201dhyq\u201d,\u201dM\u201d);<\/p>\n

11\u3001\u66f4\u65b0\u8868\u4e2d\u6570\u636e\uff1a
\nmysql-> UPDATE \u8868\u540d SET \u5b57\u6bb5\u540d1=\u2019a’,\u5b57\u6bb5\u540d2=\u2019b\u2019 WHERE \u5b57\u6bb5\u540d3=\u2019c’;<\/p>\n

12\u3001\u7528\u6587\u672c\u65b9\u5f0f\u5c06\u6570\u636e\u88c5\u5165\u6570\u636e\u8868\u4e2d\uff1a
\nmysql> LOAD DATA LOCAL INFILE \u201cD:\/mysql.txt\u201d INTO TABLE \u8868\u540d;<\/p>\n

13\u3001\u5bfc\u5165.sql\u6587\u4ef6\u547d\u4ee4\uff1a
\nmysql> USE \u6570\u636e\u5e93\u540d;
\nmysql> SOURCE d:\/mysql.sql;<\/p>\n

14\u3001\u547d\u4ee4\u884c\u4fee\u6539root\u5bc6\u7801\uff1a
\nmysql> UPDATE mysql.user SET password=PASSWORD(\u2019\u65b0\u5bc6\u7801\u2019) WHERE User=\u2019root\u2019;
\nmysql> FLUSH PRIVILEGES;<\/p>\n

15\u3001\u663e\u793ause\u7684\u6570\u636e\u5e93\u540d\uff1a
\nmysql> SELECT DATABASE();<\/p>\n

16\u3001\u663e\u793a\u5f53\u524d\u7684user\uff1a
\nmysql> SELECT USER();<\/p>\n

\u4e09\u3001\u4e00\u4e2a\u5efa\u5e93\u548c\u5efa\u8868\u4ee5\u53ca\u63d2\u5165\u6570\u636e\u7684\u5b9e\u4f8b<\/strong><\/span>
\ndrop database if exists school;\u00a0\/\/\u5982\u679c\u5b58\u5728SCHOOL\u5219\u5220\u9664
\ncreate database school;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\u5efa\u7acb\u5e93SCHOOL
\nuse school;\u00a0 \u00a0\/\/\u6253\u5f00\u5e93SCHOOL
\ncreate table teacher\u00a0\/\/\u5efa\u7acb\u8868TEACHER
\n(
\nid int(3) auto_increment not null primary key,
\nname char(10) not null,
\naddress varchar(50) default \u2018\u6df1\u5733\u2019,
\nyear date
\n);\u00a0\/\/\u5efa\u8868\u7ed3\u675f<\/p>\n

\/\/\u4ee5\u4e0b\u4e3a\u63d2\u5165\u5b57\u6bb5
\ninsert into teacher values(\u201d,\u2019allen\u2019,’\u5927\u8fde\u4e00\u4e2d\u2019,’1976-10-10\u2032);
\ninsert into teacher values(\u201d,\u2019jack\u2019,’\u5927\u8fde\u4e8c\u4e2d\u2019,’1975-12-23\u2032);<\/p>\n

\u5982\u679c\u4f60\u5728mysql\u63d0\u793a\u7b26\u952e\u5165\u4e0a\u9762\u7684\u547d\u4ee4\u4e5f\u53ef\u4ee5\uff0c\u4f46\u4e0d\u65b9\u4fbf\u8c03\u8bd5\u3002<\/strong>
\n\uff081\uff09\u4f60\u53ef\u4ee5\u5c06\u4ee5\u4e0a\u547d\u4ee4\u539f\u6837\u5199\u5165\u4e00\u4e2a\u6587\u672c\u6587\u4ef6\u4e2d\uff0c\u5047\u8bbe\u4e3aschool.sql\uff0c\u7136\u540e\u590d\u5236\u5230c:\/\/\u4e0b\uff0c\u5e76\u5728DOS\u72b6\u6001\u8fdb\u5165\u76ee\u5f55[url=file:\/\/\/\/mysql\/\/bin]\/\/mysql\/\/bin[\/url]\uff0c\u7136\u540e\u952e\u5165\u4ee5\u4e0b\u547d\u4ee4\uff1a
\nmysql -uroot -p\u5bc6\u7801 < c:\/\/school.sql
\n\u5982\u679c\u6210\u529f\uff0c\u7a7a\u51fa\u4e00\u884c\u65e0\u4efb\u4f55\u663e\u793a\uff1b\u5982\u6709\u9519\u8bef\uff0c\u4f1a\u6709\u63d0\u793a\u3002\uff08\u4ee5\u4e0a\u547d\u4ee4\u5df2\u7ecf\u8c03\u8bd5\uff0c\u4f60\u53ea\u8981\u5c06\/\/\u7684\u6ce8\u91ca\u53bb\u6389\u5373\u53ef\u4f7f\u7528\uff09\u3002
\n\uff082\uff09\u6216\u8005\u8fdb\u5165\u547d\u4ee4\u884c\u540e\u4f7f\u7528 mysql> source c:\/\/school.sql; \u4e5f\u53ef\u4ee5\u5c06school.sql\u6587\u4ef6\u5bfc\u5165\u6570\u636e\u5e93\u4e2d\u3002<\/p>\n

\u56db\u3001\u5c06\u6587\u672c\u6570\u636e\u8f6c\u5230\u6570\u636e\u5e93\u4e2d<\/strong><\/span>
\n1\u3001\u6587\u672c\u6570\u636e\u5e94\u7b26\u5408\u7684\u683c\u5f0f\uff1a\u5b57\u6bb5\u6570\u636e\u4e4b\u95f4\u7528tab\u952e\u9694\u5f00\uff0cnull\u503c\u7528[url=file:\/\/\/\/n]\/\/n[\/url]\u6765\u4ee3\u66ff.\u4f8b\uff1a
\n3 rose \u5927\u8fde\u4e8c\u4e2d 1976-10-10
\n4 mike \u5927\u8fde\u4e00\u4e2d 1975-12-23
\n\u5047\u8bbe\u4f60\u628a\u8fd9\u4e24\u7ec4\u6570\u636e\u5b58\u4e3aschool.txt\u6587\u4ef6\uff0c\u653e\u5728c\u76d8\u6839\u76ee\u5f55\u4e0b\u3002
\n2\u3001\u6570\u636e\u4f20\u5165\u547d\u4ee4 load data local infile \u201cc:\/\/school.txt\u201d into table \u8868\u540d;
\n\u6ce8\u610f\uff1a\u4f60\u6700\u597d\u5c06\u6587\u4ef6\u590d\u5236\u5230[url=file:\/\/\/\/mysql\/\/bin]\/\/mysql\/\/bin[\/url]\u76ee\u5f55\u4e0b\uff0c\u5e76\u4e14\u8981\u5148\u7528use\u547d\u4ee4\u6253\u8868\u6240\u5728\u7684\u5e93\u3002<\/p>\n

\u4e94\u3001\u5907\u4efd\u6570\u636e\u5e93<\/span>
\n<\/strong>1.\u5bfc\u51fa\u6574\u4e2a\u6570\u636e\u5e93
\n\u5bfc\u51fa\u6587\u4ef6\u9ed8\u8ba4\u662f\u5b58\u5728mysql\/bin\u76ee\u5f55\u4e0b
\nmysqldump -u \u7528\u6237\u540d -p \u6570\u636e\u5e93\u540d > \u5bfc\u51fa\u7684\u6587\u4ef6\u540d
\nmysqldump -u user_name -p123456 database_name > outfile_name.sql<\/p>\n

2.\u5bfc\u51fa\u4e00\u4e2a\u8868
\nmysqldump -u \u7528\u6237\u540d -p \u6570\u636e\u5e93\u540d \u8868\u540d> \u5bfc\u51fa\u7684\u6587\u4ef6\u540d
\nmysqldump -u user_name -p database_name table_name > outfile_name.sql<\/p>\n

3.\u5bfc\u51fa\u4e00\u4e2a\u6570\u636e\u5e93\u7ed3\u6784
\nmysqldump -u user_name -p -d \u2013add-drop-table database_name > outfile_name.sql
\n-d \u6ca1\u6709\u6570\u636e \u2013add-drop-table \u5728\u6bcf\u4e2acreate\u8bed\u53e5\u4e4b\u524d\u589e\u52a0\u4e00\u4e2adrop table<\/p>\n

4.\u5e26\u8bed\u8a00\u53c2\u6570\u5bfc\u51fa
\nmysqldump -uroot -p \u2013default-character-set=latin1 \u2013set-charset=gbk \u2013skip-opt database_name > outfile_name.sql<\/p>\n

\u516d\u3001\u5bfc\u5165\u6570\u636e\u5e93<\/strong><\/span><\/p>\n

\u4f8b\u5982\uff1a\u6570\u636e\u5e93\u540d\u4e3a dbTest<\/p>\n

\u9996\u5148\uff0c\u8fdb\u5165mysql<\/p>\n

mysql -uroot -p123456<\/p>\n

\u7136\u540e\uff0c\u521b\u5efa\u6570\u636e\u5e93<\/p>\n

create\u00a0dbTest<\/p>\n

exit<\/p>\n

\u6700\u540e\uff0c\u5bfc\u5165\u6570\u636e\u5e93<\/p>\n

mysql -uroot -p123456\u00a0dbTest\u00a0<\u00a0dbTest_bk.sql<\/p>\n

\u6570\u636e\u5e93\u53ca\u8868\u5bfc\u51fa\u5bfc\u5165\u793a\u4f8b\uff1a<\/strong><\/span><\/p>\n

\u5bfc\u51fa\u6570\u636e\u5e93
\nmysqldump -u root -p123456 gameTop >\u00a0gameTop_db.sql<\/p>\n

\u5bfc\u51fa\u6570\u636e\u5e93\u7684\u8868
\nmysqldump -u\u00a0-p123456\u00a0root\u00a0gameTop\u00a0gametop800 >\u00a0gameTop_table.sql<\/p>\n

\u5bfc\u51fa\u6570\u636e\u5e93\u7684\u7279\u5b9a\u8868
\nmysqldump -u root -p123456 \u00a0gameTop\u00a0–table\u00a0gametop800\u00a0\u00a0>\u00a0gameTop_table.sql<\/p>\n

\u5bfc\u51fa\u6570\u636e\u5e93\uff08\u53ea\u5bfc\u7ed3\u6784\uff0c\u4e0d\u8981\u6570\u636e\uff09
\nmysqldump -u root -p123456\u00a0–opt -d\u00a0gameTop >\u00a0gameTop_db.sql<\/p>\n

\u6216\u8005<\/strong><\/p>\n

mysqldump -u root -p123456 \u00a0-d\u00a0gameTop >\u00a0gameTop_db.sql<\/p>\n

\u5bfc\u51fa\u6570\u636e\u5e93\uff08\u53ea\u5bfc\u6570\u636e\uff0c\u4e0d\u8981\u7ed3\u6784\uff09
\nmysqldump -u root -p123456 \u00a0-t\u00a0gameTop >\u00a0gameTop_db.sql<\/p>\n

\u6ce8\uff1a<\/strong>\u4e0d\u52a0 -d \u548c -t \u5219\u65e2\u5bfc\u51fa\u7ed3\u6784\uff0c\u4e5f\u5bfc\u51fa\u6570\u636e<\/p>\n

mysqldump\u5bfc\u51fa\u629b\u51fa\u5f02\u5e38\uff1a<\/strong><\/p>\n

mysqldump: Got error: 1044: Access denied for user ‘username’@’%’ to database ‘dbname’ when using LOCK TABLES<\/p>\n

\u89e3\u51b3\u529e\u6cd5\uff0c\u6dfb\u52a0\u53c2\u6570\u00a0–skip-lock-tables<\/strong>\uff1a<\/p>\n

mysqldump\u00a0–skip-lock-tables<\/strong>\u00a0-h172.88.12.102 -username-pAnJnVs3C2tYXyTwV dbname> dbname_bk.sql<\/p>\n

————————–
\n\u5bfc\u5165\u6570\u636e\u5e93\uff1a<\/strong><\/span><\/p>\n

\u767b\u5f55MySQL: \u00a0 \u00a0 \u00a0mysql -uroot -p123456
\n\u521b\u5efa\u6570\u636e\u5e93\uff1a \u00a0 \u00a0create database\u00a0gameTop;<\/p>\n

\u5bfc\u5165\u6570\u636e\u5e93\uff1a<\/p>\n

mysql -uroot -p123456\u00a0gameTop\u00a0<\u00a0gameTop_db.sql<\/p>\n

\u5bfc\u5165\u6570\u636e\u5e93\u8868\uff1a<\/p>\n

mysql -uroot -p123456\u00a0gameTop \u00a0gametop800\u00a0< \u00a0gameTop_table.sql<\/p>\n

\u5bfc\u5165\u6570\u636e\u5e93\u8868\uff1a
\nmysql -uroot -p123456\u00a0gameTop \u00a0<\u00a0gameTop_table.sql \u00a0 \uff08\u4e0d\u6307\u5b9a\u8868\u540d\uff09<\/p>\n

 <\/p>\n

\u8f6c\u8f7d\u58f0\u660e\uff1a<\/strong>\u672c\u6587\u8f6c\u81eahttp:\/\/blog.csdn.net\/networld2002\/archive\/2009\/04\/23\/4103407.aspx<\/a><\/p>\n

==================================================================================<\/p>\n

 <\/p>\n

 <\/p>\n

1:\u4f7f\u7528SHOW\u8bed\u53e5\u627e\u51fa\u5728\u670d\u52a1\u5668\u4e0a\u5f53\u524d\u5b58\u5728\u4ec0\u4e48\u6570\u636e\u5e93\uff1a
\nmysql> SHOW DATABASES;<\/p>\n

2:\u521b\u5efa\u4e00\u4e2a\u6570\u636e\u5e93MYSQLDATA
\nmysql> CREATE DATABASE MYSQLDATA;<\/p>\n

3:\u9009\u62e9\u4f60\u6240\u521b\u5efa\u7684\u6570\u636e\u5e93
\nmysql> USE MYSQLDATA; (\u6309\u56de\u8f66\u952e\u51fa\u73b0Database changed \u65f6\u8bf4\u660e\u64cd\u4f5c\u6210\u529f\uff01)<\/p>\n

4:\u67e5\u770b\u73b0\u5728\u7684\u6570\u636e\u5e93\u4e2d\u5b58\u5728\u4ec0\u4e48\u8868
\nmysql> SHOW TABLES;<\/p>\n

5:\u521b\u5efa\u4e00\u4e2a\u6570\u636e\u5e93\u8868
\nmysql> CREATE TABLE MYTABLE (name VARCHAR(20), sex CHAR(1));<\/p>\n

6:\u663e\u793a\u8868\u7684\u7ed3\u6784\uff1a
\nmysql> DESCRIBE MYTABLE;<\/p>\n

7:\u5f80\u8868\u4e2d\u52a0\u5165\u8bb0\u5f55
\nmysql> insert into MYTABLE values (\u201dhyq\u201d,\u201dM\u201d);<\/p>\n

8:\u7528\u6587\u672c\u65b9\u5f0f\u5c06\u6570\u636e\u88c5\u5165\u6570\u636e\u5e93\u8868\u4e2d\uff08\u4f8b\u5982D:\/mysql.txt\uff09
\nmysql> LOAD DATA LOCAL INFILE \u201cD:\/mysql.txt\u201d INTO TABLE MYTABLE;<\/p>\n

9:\u5bfc\u5165.sql\u6587\u4ef6\u547d\u4ee4\uff08\u4f8b\u5982D:\/mysql.sql\uff09
\nmysql>use database;
\nmysql>source d:\/mysql.sql;<\/p>\n

10:\u5220\u9664\u8868
\nmysql>drop TABLE MYTABLE;<\/p>\n

11:\u6e05\u7a7a\u8868
\nmysql>delete from MYTABLE;<\/p>\n

12:\u66f4\u65b0\u8868\u4e2d\u6570\u636e
\nmysql>update MYTABLE set sex=\u201df\u201d where name=\u2019hyq\u2019;<\/p>\n

 <\/p>\n

\u4ee5\u4e0b\u662f\u65e0\u610f\u4e2d\u5728\u7f51\u7edc\u770b\u5230\u7684\u4f7f\u7528MySql\u7684\u7ba1\u7406\u5fc3\u5f97,<\/strong>
\n\u5728windows\u4e2dMySql\u4ee5\u670d\u52a1\u5f62\u5f0f\u5b58\u5728\uff0c\u5728\u4f7f\u7528\u524d\u5e94\u786e\u4fdd\u6b64\u670d\u52a1\u5df2\u7ecf\u542f\u52a8\uff0c\u672a\u542f\u52a8\u53ef\u7528net start mysql\u547d\u4ee4\u542f\u52a8\u3002\u800cLinux\u4e2d\u542f\u52a8\u65f6\u53ef\u7528\u201c\/etc\/rc.d\/init.d\/mysqld start\u201d\u547d\u4ee4\uff0c\u6ce8\u610f\u542f\u52a8\u8005\u5e94\u5177\u6709\u7ba1\u7406\u5458\u6743\u9650\u3002
\n\u521a\u5b89\u88c5\u597d\u7684MySql\u5305\u542b\u4e00\u4e2a\u542b\u7a7a\u5bc6\u7801\u7684root\u5e10\u6237\u548c\u4e00\u4e2a\u533f\u540d\u5e10\u6237\uff0c\u8fd9\u662f\u5f88\u5927\u7684\u5b89\u5168\u9690\u60a3\uff0c\u5bf9\u4e8e\u4e00\u4e9b\u91cd\u8981\u7684\u5e94\u7528\u6211\u4eec\u5e94\u5c06\u5b89\u5168\u6027\u5c3d\u53ef\u80fd\u63d0\u9ad8\uff0c\u5728\u8fd9\u91cc\u5e94\u628a\u533f\u540d\u5e10\u6237\u5220\u9664\u3001 root\u5e10\u6237\u8bbe\u7f6e\u5bc6\u7801\uff0c\u53ef\u7528\u5982\u4e0b\u547d\u4ee4\u8fdb\u884c\uff1a
\nuse mysql;
\ndelete from User where User=\u201d”;
\nupdate User set Password=PASSWORD(\u2019newpassword\u2019) where User=\u2019root\u2019;<\/p>\n

\u5982\u679c\u8981\u5bf9\u7528\u6237\u6240\u7528\u7684\u767b\u5f55\u7ec8\u7aef\u8fdb\u884c\u9650\u5236\uff0c\u53ef\u4ee5\u66f4\u65b0User\u8868\u4e2d\u76f8\u5e94\u7528\u6237\u7684Host\u5b57\u6bb5\uff0c\u5728\u8fdb\u884c\u4e86\u4ee5\u4e0a\u66f4\u6539\u540e\u5e94\u91cd\u65b0\u542f\u52a8\u6570\u636e\u5e93\u670d\u52a1\uff0c\u6b64\u65f6\u767b\u5f55\u65f6\u53ef\u7528\u5982\u4e0b\u7c7b\u4f3c\u547d\u4ee4\uff1a
\nmysql -uroot -p;
\nmysql -uroot -pnewpassword;
\nmysql mydb -uroot -p;
\nmysql mydb -uroot -pnewpassword;<\/p>\n

\u4e0a\u9762\u547d\u4ee4\u53c2\u6570\u662f\u5e38\u7528\u53c2\u6570\u7684\u4e00\u90e8\u5206\uff0c\u8be6\u7ec6\u60c5\u51b5\u53ef\u53c2\u8003\u6587\u6863\u3002\u6b64\u5904\u7684mydb\u662f\u8981\u767b\u5f55\u7684\u6570\u636e\u5e93\u7684\u540d\u79f0\u3002<\/strong>
\n\u5728 \u8fdb\u884c\u5f00\u53d1\u548c\u5b9e\u9645\u5e94\u7528\u4e2d\uff0c\u7528\u6237\u4e0d\u5e94\u8be5\u53ea\u7528root\u7528\u6237\u8fdb\u884c\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u867d\u7136\u4f7f\u7528root\u7528\u6237\u8fdb\u884c\u6d4b\u8bd5\u65f6\u5f88\u65b9\u4fbf\uff0c\u4f46\u4f1a\u7ed9\u7cfb\u7edf\u5e26\u6765\u91cd\u5927\u5b89\u5168\u9690\u60a3\uff0c\u4e5f\u4e0d\u5229\u4e8e\u7ba1\u7406\u6280 \u672f\u7684\u63d0\u9ad8\u3002\u6211\u4eec\u7ed9\u4e00\u4e2a\u5e94\u7528\u4e2d\u4f7f\u7528\u7684\u7528\u6237\u8d4b\u4e88\u6700\u6070\u5f53\u7684\u6570\u636e\u5e93\u6743\u9650\u3002\u5982\u4e00\u4e2a\u53ea\u8fdb\u884c\u6570\u636e\u63d2\u5165\u7684\u7528\u6237\u4e0d\u5e94\u8d4b\u4e88\u5176\u5220\u9664\u6570\u636e\u7684\u6743\u9650\u3002<\/p>\n

MySql\u7684\u7528\u6237\u7ba1\u7406\u662f\u901a\u8fc7 User\u8868\u6765\u5b9e\u73b0\u7684\uff0c\u6dfb\u52a0\u65b0\u7528\u6237\u5e38\u7528\u7684\u65b9\u6cd5\u6709\u4e24\u4e2a\uff0c\u4e00\u662f\u5728User\u8868\u63d2\u5165\u76f8\u5e94\u7684\u6570\u636e\u884c\uff0c\u540c\u65f6\u8bbe\u7f6e\u76f8\u5e94\u7684\u6743\u9650\uff1b\u4e8c\u662f\u901a\u8fc7GRANT\u547d\u4ee4\u521b\u5efa\u5177\u6709\u67d0\u79cd\u6743\u9650\u7684\u7528 \u6237\u3002\u5176\u4e2dGRANT\u7684\u5e38\u7528\u7528\u6cd5\u5982\u4e0b\uff1a
\ngrant all on mydb.* to NewUserName@HostName identified by \u201cpassword\u201d ;
\ngrant usage on *.* to NewUserName@HostName identified by \u201cpassword\u201d;
\ngrant select,insert,update on mydb.* to NewUserName@HostName identified by \u201cpassword\u201d;
\ngrant update,delete on mydb.TestTable to NewUserName@HostName identified by \u201cpassword\u201d;<\/p>\n

\u82e5 \u8981\u7ed9\u6b64\u7528\u6237\u8d4b\u4e88\u4ed6\u5728\u76f8\u5e94\u5bf9\u8c61\u4e0a\u7684\u6743\u9650\u7684\u7ba1\u7406\u80fd\u529b\uff0c\u53ef\u5728GRANT\u540e\u9762\u6dfb\u52a0WITH GRANT OPTION\u9009\u9879\u3002\u800c\u5bf9\u4e8e\u7528\u63d2\u5165User\u8868\u6dfb\u52a0\u7684\u7528\u6237\uff0cPassword\u5b57\u6bb5\u5e94\u7528PASSWORD \u51fd\u6570\u8fdb\u884c\u66f4\u65b0\u52a0\u5bc6\uff0c\u4ee5\u9632\u4e0d\u8f68\u4e4b\u4eba\u7a83\u770b\u5bc6\u7801\u3002\u5bf9\u4e8e\u90a3\u4e9b\u5df2\u7ecf\u4e0d\u7528\u7684\u7528\u6237\u5e94\u7ed9\u4e88\u6e05\u9664\uff0c\u6743\u9650\u8fc7\u754c\u7684\u7528\u6237\u5e94\u53ca\u65f6\u56de\u6536\u6743\u9650\uff0c\u56de\u6536\u6743\u9650\u53ef\u4ee5\u901a\u8fc7\u66f4\u65b0User\u8868\u76f8\u5e94\u5b57\u6bb5\uff0c \u4e5f\u53ef\u4ee5\u4f7f\u7528REVOKE\u64cd\u4f5c\u3002
\n\u4e0b\u9762\u7ed9\u51fa\u672c\u4eba\u4ece\u5176\u5b83\u8d44\u6599(www.cn-java.com)\u83b7\u5f97\u7684\u5bf9\u5e38\u7528\u6743\u9650\u7684\u89e3\u91ca\uff1a
\n\u5168\u5c40\u7ba1\u7406\u6743\u9650\uff1a
\nFILE: \u5728MySQL\u670d\u52a1\u5668\u4e0a\u8bfb\u5199\u6587\u4ef6\u3002
\nPROCESS: \u663e\u793a\u6216\u6740\u6b7b\u5c5e\u4e8e\u5176\u5b83\u7528\u6237\u7684\u670d\u52a1\u7ebf\u7a0b\u3002
\nRELOAD: \u91cd\u8f7d\u8bbf\u95ee\u63a7\u5236\u8868\uff0c\u5237\u65b0\u65e5\u5fd7\u7b49\u3002
\nSHUTDOWN: \u5173\u95edMySQL\u670d\u52a1\u3002
\n\u6570\u636e\u5e93\/\u6570\u636e\u8868\/\u6570\u636e\u5217\u6743\u9650\uff1a
\nALTER: \u4fee\u6539\u5df2\u5b58\u5728\u7684\u6570\u636e\u8868(\u4f8b\u5982\u589e\u52a0\/\u5220\u9664\u5217)\u548c\u7d22\u5f15\u3002
\nCREATE: \u5efa\u7acb\u65b0\u7684\u6570\u636e\u5e93\u6216\u6570\u636e\u8868\u3002
\nDELETE: \u5220\u9664\u8868\u7684\u8bb0\u5f55\u3002
\nDROP: \u5220\u9664\u6570\u636e\u8868\u6216\u6570\u636e\u5e93\u3002
\nINDEX: \u5efa\u7acb\u6216\u5220\u9664\u7d22\u5f15\u3002
\nINSERT: \u589e\u52a0\u8868\u7684\u8bb0\u5f55\u3002
\nSELECT: \u663e\u793a\/\u641c\u7d22\u8868\u7684\u8bb0\u5f55\u3002
\nUPDATE: \u4fee\u6539\u8868\u4e2d\u5df2\u5b58\u5728\u7684\u8bb0\u5f55\u3002
\n\u7279\u522b\u7684\u6743\u9650\uff1a
\n<\/strong>ALL: \u5141\u8bb8\u505a\u4efb\u4f55\u4e8b(\u548croot\u4e00\u6837)\u3002
\nUSAGE: \u53ea\u5141\u8bb8\u767b\u5f55\u2013\u5176\u5b83\u4ec0\u4e48\u4e5f\u4e0d\u5141\u8bb8\u505a\u3002<\/p>\n

 <\/p>\n

\u77e5\u8bc6\u62d3\u5c55\uff1a<\/strong><\/p>\n

Ubuntu\u4e0b\u8fdc\u7a0b\u8bbf\u95eeMySQL\u6570\u636e\u5e93<\/a><\/p>\n

mysql -uroot -p123456\u00a0gameTop \u00a0gametop800 <\u00a0gameTop_db.sql<\/div>\n","protected":false},"excerpt":{"rendered":"

MySQL \u6570\u636e\u5e93\u5e38\u7528\u547d\u4ee4   1\u3001MySQL\u5e38\u7528\u547d\u4ee4 create …
Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-911","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=911"}],"version-history":[{"count":1,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/911\/revisions"}],"predecessor-version":[{"id":912,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/911\/revisions\/912"}],"wp:attachment":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}