{"id":142,"date":"2019-02-10T18:09:49","date_gmt":"2019-02-10T10:09:49","guid":{"rendered":"http:\/\/b.yesiyu.top\/?p=142"},"modified":"2019-02-10T18:09:49","modified_gmt":"2019-02-10T10:09:49","slug":"mysql-%e5%ae%89%e8%a3%85%e9%85%8d%e7%bd%ae","status":"publish","type":"post","link":"https:\/\/b.yesiyu.top\/?p=142","title":{"rendered":"MySQL \u5b89\u88c5\u914d\u7f6e"},"content":{"rendered":"
\n
\n

MySQL \u5b89\u88c5\u914d\u7f6e<\/h1>\n

MySQL \u662f\u6700\u6d41\u884c\u7684\u5173\u7cfb\u578b\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\uff0c\u7531\u745e\u5178MySQL\u00a0AB\u516c\u53f8\u5f00\u53d1\uff0c\u76ee\u524d\u5c5e\u4e8eOracle\u516c\u53f8\u3002<\/p>\n

MySQL\u6240\u4f7f\u7528\u7684SQL\u8bed\u8a00\u662f\u7528\u4e8e\u8bbf\u95ee\u6570\u636e\u5e93\u7684\u6700\u5e38\u7528\u6807\u51c6\u5316\u8bed\u8a00\u3002<\/p>\n

MySQL\u7531\u4e8e\u5176\u4f53\u79ef\u5c0f\u3001\u901f\u5ea6\u5feb\u3001\u603b\u4f53\u62e5\u6709\u6210\u672c\u4f4e\uff0c\u5c24\u5176\u662f\u5f00\u653e\u6e90\u7801\u8fd9\u4e00\u7279\u70b9\uff0c\u4e00\u822c\u4e2d\u5c0f\u578b\u7f51\u7ad9\u7684\u5f00\u53d1\u90fd\u9009\u62e9MySQL\u4f5c\u4e3a\u7f51\u7ad9\u6570\u636e\u5e93\u3002<\/p>\n

\n

MySQL \u5b89\u88c5<\/h2>\n

\u672c\u6559\u7a0b\u7684\u7cfb\u7edf\u5e73\u53f0\uff1aCentOS release 6.6 (Final) 64\u4f4d\u3002<\/p>\n

\u4e00\u3001\u5b89\u88c5\u7f16\u8bd1\u5de5\u5177\u53ca\u5e93\u6587\u4ef6<\/h3>\n
yum <\/span>-<\/span>y install gcc gcc<\/span>-<\/span>c<\/span>++<\/span> make autoconf libtool<\/span>-<\/span>ltdl<\/span>-<\/span>devel gd<\/span>-<\/span>devel freetype<\/span>-<\/span>devel libxml2<\/span>-<\/span>devel libjpeg<\/span>-<\/span>devel libpng<\/span>-<\/span>devel openssl<\/span>-<\/span>devel curl<\/span>-<\/span>devel bison patch unzip libmcrypt<\/span>-<\/span>devel libmhash<\/span>-<\/span>devel ncurses<\/span>-<\/span>devel sudo bzip2 flex libaio<\/span>-<\/span>devel<\/span><\/pre>\n
\u4e8c\u3001\u00a0\u5b89\u88c5cmake \u7f16\u8bd1\u5668<\/h3>\n
cmake \u7248\u672c\uff1acmake-3.1.1\u3002<\/p>\n
1\u3001\u4e0b\u8f7d\u5730\u5740\uff1ahttp:\/\/www.cmake.org\/files\/v3.1\/cmake-3.1.1.tar.gz<\/a><\/p>\n
$ wget\u00a0http<\/span>:<\/span>\/\/www.cmake.org\/files\/v3.1\/cmake-3.1.1.tar.gz<\/span><\/pre>\n
\"mysql1\"2\u3001\u89e3\u538b\u5b89\u88c5\u5305<\/p>\n
$ tar zxvf cmake<\/span>-<\/span>3.1<\/span>.<\/span>1.tar<\/span>.<\/span>gz<\/span><\/pre>\n
3\u3001\u8fdb\u5165\u5b89\u88c5\u5305\u76ee\u5f55<\/p>\n
$ cd cmake<\/span>-<\/span>3.1<\/span>.<\/span>1<\/span><\/pre>\n
4\u3001\u7f16\u8bd1\u5b89\u88c5<\/p>\n
$ <\/span>.\/<\/span>bootstrap\r\n$ make <\/span>&&<\/span> make install<\/span><\/pre>\n
\n
\u4e09\u3001\u5b89\u88c5 MySQL<\/h3>\n
MySQL\u7248\u672c\uff1amysql-5.6.15\u3002<\/p>\n
1\u3001\u4e0b\u8f7d\u5730\u5740\uff1a\u00a0http:\/\/dev.mysql.com\/get\/Downloads\/MySQL-5.6\/mysql-5.6.15.tar.gz<\/a><\/p>\n
$ wget\u00a0http<\/span>:<\/span>\/\/dev.mysql.com\/get\/Downloads\/MySQL-5.6\/mysql-5.6.15.tar.gz<\/span><\/pre>\n
\"mysql2\"2\u3001\u89e3\u538b\u5b89\u88c5\u5305<\/p>\n
$ tar zxvf mysql<\/span>-<\/span>5.6<\/span>.<\/span>15.tar<\/span>.<\/span>gz<\/span><\/pre>\n
3\u3001\u8fdb\u5165\u5b89\u88c5\u5305\u76ee\u5f55<\/p>\n
$ cd mysql<\/span>-<\/span>5.6<\/span>.<\/span>15<\/span><\/pre>\n
4\u3001\u7f16\u8bd1\u5b89\u88c5<\/p>\n
$ cmake <\/span>-<\/span>DCMAKE_INSTALL_PREFIX<\/span>=<\/span>\/usr\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql<\/span>\/<\/span> -<\/span>DMYSQL_UNIX_ADDR<\/span>=<\/span>\/tmp\/<\/span>mysql<\/span>.<\/span>sock <\/span>-<\/span>DDEFAULT_CHARSET<\/span>=<\/span>utf8 <\/span>-<\/span>DDEFAULT_COLLATION<\/span>=<\/span>utf8_general_ci <\/span>-<\/span>DWITH_EXTRA_CHARSETS<\/span>=<\/span>all <\/span>-<\/span>DWITH_MYISAM_STORAGE_ENGINE<\/span>=<\/span>1<\/span> -<\/span>DWITH_INNOBASE_STORAGE_ENGINE<\/span>=<\/span>1<\/span> -<\/span>DWITH_MEMORY_STORAGE_ENGINE<\/span>=<\/span>1<\/span> -<\/span>DWITH_READLINE<\/span>=<\/span>1<\/span> -<\/span>DWITH_INNODB_MEMCACHED<\/span>=<\/span>1<\/span> -<\/span>DWITH_DEBUG<\/span>=<\/span>OFF <\/span>-<\/span>DWITH_ZLIB<\/span>=<\/span>bundled <\/span>-<\/span>DENABLED_LOCAL_INFILE<\/span>=<\/span>1<\/span> -<\/span>DENABLED_PROFILING<\/span>=<\/span>ON <\/span>-<\/span>DMYSQL_MAINTAINER_MODE<\/span>=<\/span>OFF <\/span>-<\/span>DMYSQL_DATADIR<\/span>=<\/span>\/usr\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql<\/span>\/<\/span>data <\/span>-<\/span>DMYSQL_TCP_PORT<\/span>=<\/span>3306<\/span>\r\n$ make <\/span>&&<\/span> make install<\/span><\/pre>\n
5\u3001\u67e5\u770bmysql\u7248\u672c:<\/p>\n
$ <\/span>\/<\/span>usr<\/span>\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql<\/span>\/<\/span>bin<\/span>\/<\/span>mysql <\/span>--<\/span>version<\/span><\/pre>\n
\"mysql3\"\u5230\u6b64\uff0cmysql\u5b89\u88c5\u5b8c\u6210\u3002<\/p>\n
\n
MySQL \u914d\u7f6e<\/h2>\n
1\u3001\u521b\u5efamysql\u8fd0\u884c\u4f7f\u7528\u7684\u7528\u6237mysql\uff1a<\/p>\n
$ <\/span>\/<\/span>usr<\/span>\/<\/span>sbin<\/span>\/<\/span>groupadd mysql\r\n$ <\/span>\/<\/span>usr<\/span>\/<\/span>sbin<\/span>\/<\/span>useradd <\/span>-<\/span>g mysql mysql<\/span><\/pre>\n
2\u3001\u521b\u5efabinlog\u548c\u5e93\u7684\u5b58\u50a8\u8def\u5f84\u5e76\u8d4b\u4e88mysql\u7528\u6237\u6743\u9650<\/p>\n
$ mkdir <\/span>-<\/span>p <\/span>\/<\/span>usr<\/span>\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql<\/span>\/<\/span>binlog <\/span>\/<\/span>www<\/span>\/<\/span>data_mysql\r\n$ chown mysql<\/span>.<\/span>mysql <\/span>\/<\/span>usr<\/span>\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql<\/span>\/<\/span>binlog<\/span>\/ \/<\/span>www<\/span>\/<\/span>data_mysql<\/span>\/<\/span><\/pre>\n
3\u3001\u521b\u5efamy.cnf\u914d\u7f6e\u6587\u4ef6<\/p>\n
\u5c06\/etc\/my.cnf\u66ff\u6362\u4e3a\u4e0b\u9762\u5185\u5bb9<\/p>\n
$ cat <\/span>\/<\/span>etc<\/span>\/<\/span>my<\/span>.<\/span>cnf\r\n\r\n<\/span>[<\/span>client<\/span>]<\/span>\r\nport <\/span>=<\/span> 3306<\/span>\r\nsocket <\/span>=<\/span> \/tmp\/<\/span>mysql<\/span>.<\/span>sock\r\n<\/span>[<\/span>mysqld<\/span>]<\/span>\r\nreplicate<\/span>-<\/span>ignore<\/span>-<\/span>db <\/span>=<\/span> mysql\r\nreplicate<\/span>-<\/span>ignore<\/span>-<\/span>db <\/span>=<\/span> test\r\nreplicate<\/span>-<\/span>ignore<\/span>-<\/span>db <\/span>=<\/span> information_schema\r\nuser <\/span>=<\/span> mysql\r\nport <\/span>=<\/span> 3306<\/span>\r\nsocket <\/span>=<\/span> \/tmp\/<\/span>mysql<\/span>.<\/span>sock\r\nbasedir <\/span>=<\/span> \/usr\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql\r\ndatadir <\/span>=<\/span> \/www\/<\/span>data_mysql\r\nlog<\/span>-<\/span>error <\/span>=<\/span> \/usr\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql<\/span>\/<\/span>mysql_error<\/span>.<\/span>log\r\npid<\/span>-<\/span>file <\/span>=<\/span> \/usr\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql<\/span>\/<\/span>mysql<\/span>.<\/span>pid\r\nopen_files_limit <\/span>=<\/span> 65535<\/span>\r\nback_log <\/span>=<\/span> 600<\/span>\r\nmax_connections <\/span>=<\/span> 5000<\/span>\r\nmax_connect_errors <\/span>=<\/span> 1000<\/span>\r\ntable_open_cache <\/span>=<\/span> 1024<\/span>\r\nexternal<\/span>-<\/span>locking <\/span>=<\/span> FALSE\r\nmax_allowed_packet <\/span>=<\/span> 32M<\/span>\r\nsort_buffer_size <\/span>=<\/span> 1M<\/span>\r\njoin_buffer_size <\/span>=<\/span> 1M<\/span>\r\nthread_cache_size <\/span>=<\/span> 600<\/span>\r\n#thread_concurrency = 8<\/span>\r\nquery_cache_size <\/span>=<\/span> 128M<\/span>\r\nquery_cache_limit <\/span>=<\/span> 2M<\/span>\r\nquery_cache_min_res_unit <\/span>=<\/span> 2k<\/span>\r\ndefault<\/span>-<\/span>storage<\/span>-<\/span>engine <\/span>=<\/span> MyISAM<\/span>\r\ndefault<\/span>-<\/span>tmp<\/span>-<\/span>storage<\/span>-<\/span>engine<\/span>=<\/span>MYISAM\r\nthread_stack <\/span>=<\/span> 192K<\/span>\r\ntransaction_isolation <\/span>=<\/span> READ<\/span>-<\/span>COMMITTED\r\ntmp_table_size <\/span>=<\/span> 128M<\/span>\r\nmax_heap_table_size <\/span>=<\/span> 128M<\/span>\r\nlog<\/span>-<\/span>slave<\/span>-<\/span>updates\r\nlog<\/span>-<\/span>bin <\/span>=<\/span> \/usr\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql<\/span>\/<\/span>binlog<\/span>\/<\/span>binlog\r\nbinlog<\/span>-<\/span>do<\/span>-<\/span>db<\/span>=<\/span>oa_fb\r\nbinlog<\/span>-<\/span>ignore<\/span>-<\/span>db<\/span>=<\/span>mysql\r\nbinlog_cache_size <\/span>=<\/span> 4M<\/span>\r\nbinlog_format <\/span>=<\/span> MIXED\r\nmax_binlog_cache_size <\/span>=<\/span> 8M<\/span>\r\nmax_binlog_size <\/span>=<\/span> 1G<\/span>\r\nrelay<\/span>-<\/span>log<\/span>-<\/span>index <\/span>=<\/span> \/usr\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql<\/span>\/<\/span>relaylog<\/span>\/<\/span>relaylog\r\nrelay<\/span>-<\/span>log<\/span>-<\/span>info<\/span>-<\/span>file <\/span>=<\/span> \/usr\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql<\/span>\/<\/span>relaylog<\/span>\/<\/span>relaylog\r\nrelay<\/span>-<\/span>log <\/span>=<\/span> \/usr\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql<\/span>\/<\/span>relaylog<\/span>\/<\/span>relaylog\r\nexpire_logs_days <\/span>=<\/span> 10<\/span>\r\nkey_buffer_size <\/span>=<\/span> 256M<\/span>\r\nread_buffer_size <\/span>=<\/span> 1M<\/span>\r\nread_rnd_buffer_size <\/span>=<\/span> 16M<\/span>\r\nbulk_insert_buffer_size <\/span>=<\/span> 64M<\/span>\r\nmyisam_sort_buffer_size <\/span>=<\/span> 128M<\/span>\r\nmyisam_max_sort_file_size <\/span>=<\/span> 10G<\/span>\r\nmyisam_repair_threads <\/span>=<\/span> 1<\/span>\r\nmyisam_recover\r\ninteractive_timeout <\/span>=<\/span> 120<\/span>\r\nwait_timeout <\/span>=<\/span> 120<\/span>\r\nskip<\/span>-<\/span>name<\/span>-<\/span>resolve\r\n<\/span>#master-connect-retry = 10<\/span>\r\nslave<\/span>-<\/span>skip<\/span>-<\/span>errors <\/span>=<\/span> 1032<\/span>,<\/span>1062<\/span>,<\/span>126<\/span>,<\/span>1114<\/span>,<\/span>1146<\/span>,<\/span>1048<\/span>,<\/span>1396<\/span>\r\n#master-host = 192.168.1.2<\/span>\r\n#master-user = username<\/span>\r\n#master-password = password<\/span>\r\n#master-port = 3306<\/span>\r\nserver<\/span>-<\/span>id <\/span>=<\/span> 1<\/span>\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>trx<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>locks<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>lock<\/span>-<\/span>waits<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>cmp<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>cmp<\/span>-<\/span>per<\/span>-<\/span>index<\/span>=<\/span>0<\/span>\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>cmp<\/span>-<\/span>per<\/span>-<\/span>index<\/span>-<\/span>reset<\/span>=<\/span>0<\/span>\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>cmp<\/span>-<\/span>reset<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>cmpmem<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>cmpmem<\/span>-<\/span>reset<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>buffer<\/span>-<\/span>page<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>buffer<\/span>-<\/span>page<\/span>-<\/span>lru<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>buffer<\/span>-<\/span>pool<\/span>-<\/span>stats<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>metrics<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>ft<\/span>-<\/span>default<\/span>-<\/span>stopword<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>ft<\/span>-<\/span>inserted<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>ft<\/span>-<\/span>deleted<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>ft<\/span>-<\/span>being<\/span>-<\/span>deleted<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>ft<\/span>-<\/span>config<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>ft<\/span>-<\/span>index<\/span>-<\/span>cache<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>ft<\/span>-<\/span>index<\/span>-<\/span>table<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>sys<\/span>-<\/span>tables<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>sys<\/span>-<\/span>tablestats<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>sys<\/span>-<\/span>indexes<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>sys<\/span>-<\/span>columns<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>sys<\/span>-<\/span>fields<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>sys<\/span>-<\/span>foreign<\/span>=<\/span>0<\/span>\u00a0\r\nloose<\/span>-<\/span>innodb<\/span>-<\/span>sys<\/span>-<\/span>foreign<\/span>-<\/span>cols<\/span>=<\/span>0<\/span>\r\n\r\nslow_query_log_file<\/span>=<\/span>\/usr\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql<\/span>\/<\/span>mysql_slow<\/span>.<\/span>log\r\nlong_query_time <\/span>=<\/span> 1<\/span>\r\n[<\/span>mysqldump<\/span>]<\/span>\r\nquick\r\nmax_allowed_packet <\/span>=<\/span> 32M<\/span><\/pre>\n
4\u3001\u521d\u59cb\u5316\u6570\u636e\u5e93<\/p>\n
$<\/span>\/<\/span>usr<\/span>\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql<\/span>\/<\/span>scripts<\/span>\/<\/span>mysql_install_db <\/span>--<\/span>defaults<\/span>-<\/span>file<\/span>=<\/span>\/etc\/<\/span>my<\/span>.<\/span>cnf \u00a0<\/span>--<\/span>user<\/span>=<\/span>mysql<\/span><\/pre>\n
\u663e\u793a\u5982\u4e0b\u4fe1\u606f\uff1a<\/p>\n
Installing<\/span> MySQL<\/span> system tables<\/span>...<\/span>2015<\/span>-<\/span>01<\/span>-<\/span>26<\/span> 20<\/span>:<\/span>18<\/span>:<\/span>51<\/span> 0<\/span> [<\/span>Warning<\/span>]<\/span> TIMESTAMP <\/span>with<\/span> implicit<\/span> DEFAULT value <\/span>is<\/span> deprecated<\/span>.<\/span> Please<\/span> use<\/span> --<\/span>explicit_defaults_for_timestamp server option <\/span>(<\/span>see documentation <\/span>for<\/span> more details<\/span>).<\/span>\r\nOK\r\n\r\n<\/span>Filling<\/span> help tables<\/span>...<\/span>2015<\/span>-<\/span>01<\/span>-<\/span>26<\/span> 20<\/span>:<\/span>18<\/span>:<\/span>57<\/span> 0<\/span> [<\/span>Warning<\/span>]<\/span> TIMESTAMP <\/span>with<\/span> implicit<\/span> DEFAULT value <\/span>is<\/span> deprecated<\/span>.<\/span> Please<\/span> use<\/span> --<\/span>explicit_defaults_for_timestamp server option <\/span>(<\/span>see documentation <\/span>for<\/span> more details<\/span>).<\/span>\r\nOK\r\n<\/span>...<\/span><\/pre>\n
5\u3001\u521b\u5efa\u5f00\u673a\u542f\u52a8\u811a\u672c<\/p>\n
$ cd <\/span>\/<\/span>usr<\/span>\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql<\/span>\/<\/span>\r\n$ cp support<\/span>-<\/span>files<\/span>\/<\/span>mysql<\/span>.<\/span>server <\/span>\/<\/span>etc<\/span>\/<\/span>rc<\/span>.<\/span>d<\/span>\/<\/span>init<\/span>.<\/span>d<\/span>\/<\/span>mysqld\u00a0\r\n$ chkconfig <\/span>--<\/span>add mysqld\u00a0\r\n$ chkconfig <\/span>--<\/span>level <\/span>35<\/span> mysqld on<\/span><\/pre>\n
6\u3001\u542f\u52a8mysql\u670d\u52a1\u5668<\/p>\n
$ service mysqld start<\/span><\/pre>\n
\"mysql4\"7\u3001\u8fde\u63a5 MySQL<\/p>\n
$ <\/span>\/<\/span>usr<\/span>\/<\/span>local<\/span>\/<\/span>webserver<\/span>\/<\/span>mysql<\/span>\/<\/span>bin<\/span>\/<\/span>mysql <\/span>-<\/span>u root <\/span>-<\/span>p<\/span><\/pre>\n
\"mysql5\"<\/p>\n
\u4fee\u6539MySQL\u7528\u6237\u5bc6\u7801<\/h2>\n
mysqladmin <\/span>-<\/span>u<\/span>\u7528\u6237\u540d<\/span> -<\/span>p<\/span>\u65e7\u5bc6\u7801<\/span> password <\/span>\u65b0\u5bc6\u7801<\/span><\/pre>\n
\u6216\u8fdb\u5165mysql\u547d\u4ee4\u884c<\/p>\n
SET PASSWORD FOR <\/span>'\u7528\u6237\u540d'<\/span>@<\/span>'\u4e3b\u673a'<\/span> =<\/span> PASSWORD<\/span>(\u2018\u5bc6\u7801<\/span>');<\/span><\/pre>\n
\u521b\u5efa\u65b0\u7528\u6237\u5e76\u6388\u6743:<\/p>\n
grant all privileges on <\/span>*.*<\/span> to <\/span>\u7528\u6237\u540d@<\/span>'%'<\/span> identified <\/span>by<\/span> '\u5bc6\u7801'<\/span> with<\/span> grant option<\/span>;<\/span><\/pre>\n
\u5176\u4ed6\u547d\u4ee4<\/h3>\n