Ïê½â2020MySQL°²×°£¨Í¼ÎĽ̳̣©
![](/uploads/allimg/200930/5f0bed956cac547515699.jpg)
MySQL°²ÖÃͼÎĽ̳Ì(Windows10)
1¡¢MySQLÏÂÔØ
¿ÉÒÔÈ¥MySQL¹ÙÍøÏÂÔØ£¬»òÕßÔÚÎÒ¹©¸øµÄbaiduÔÆÁ´½ÓÏÂÔØ¡£¹ÙÍøÏÂÔØÍøËÙ½ÏÂý£¬ÎÒ´Ó¹ÙÍøÏÂÔØÁ˽«½üËĸöСʱ£¬È»ºó°ÑÏÂÔغõķÅÔÚÁËbaiduÍøÅÌ£¬ÐèÒªµÄ°ÕÁË×ÔÈ¡¡£
MySQL¹ÙÍøµØÖ·£ºMySQL¹ÙÍø
MySQLÏÂÔصØÖ·(ÕâÀïÏÂÔصÄÊÇmsi°²Öðü)
baiduÔÆÁ´½Ó£ºhttps://pan.baidu.com/s/1arPSTtKtvV9V_5v1Y6qQrw
ÌáÈ¡Â룺oj8n
2¡¢MySQL°²ÖÃ
Ë«»÷ÏÂÔصÄmsi°²ÖÃÎļþ£¬µ¯³ö°²ÖýçÃæ°´ÕÕָʾֹͣÏÂÒ»²½µÄ°²Öá£
ÔËת°²Öðüºó»áÖ±½ÓÏÔÏÖÒÔϽçÃæ
Ñ¡ÖÐCustom,È»ºóNext
Ñ¡Öа²ÖõIJúÆ·£¬Àë±ðΪ£ºMySQL Server¡¢MySQL Workbench£¬È»ºóNext
µã»÷ExecuteÊ©Ðа²ÖÃ
Ê©Ðа²Öúó»áÌø³öÒÔϽçÃ棬¹´Ñ¡¶ÔºÅ£¬È»ºó°²Öü´¿É
°²Öóɹ¦ºóµã»÷Next
ÏÔÏÖÒÔϽçÃ棬Ȼºóµã»÷Execute
Ê©ÐÐÀú³Ì
Ê©ÐÐÍê³ÉºóÈçÏÂͼËùʾ£¬Á¬Ðøµã»÷Next
ÈçÏ£¬Á¬ÐøNext
Ñ¡ÖÐStandalone MySQL Server£¬Á¬ÐøNext
ÎÞÐè¸ü»»ÅäÖã¬Á¬ÐøNext
°´ÕÕĬÐíÑ¡ÖУ¬Á¬ÐøNext
ÊäÈë×Ô¶¨ÒåÊý¾Ý¿âÃÜÂ룬Á¬Ðøµã»÷Next
É趨ЧÀÍÃû³ÆºÍ¿ª»ú×ÔÆô¶¯Ð§ÀÍ
µã»÷Execute°²ÖÃÒÔÏÂÎļþ
°²ÖÃÍê³É½ñºóÖ±½ÓFinish¼´¿É
µã»÷Next
µã»÷Finish£¬°²Öóɹ¦
WorkbenchÔËת½çÃæ
3¡¢ÅäÖû·¾³±äÁ¿
ΪÁËʹÓÃWindows10ÃüÁîÐвÙ×ÝMySQLÊý¾Ý¿â£¬ÎÒÃÇÒªÅäÖÃһϻ·¾³±äÁ¿
ÓÒ»÷´ËµçÄÔ=>ÊôÐÔ=>¸ß¼¶ÏµÍ³É趨=>¸ß¼¶=>»·¾³±äÁ¿£¬ÔÚ·¿ªµÄ´°¿ÚÖÐÑ¡ÖРϵͳ±äÁ¿ Ï嵀 ¡°´´½¨¡± °´Å¥´´Á¢»·¾³±äÁ¿
´´Á¢MYSQL_HOME»·¾³±äÁ¿
±äÁ¿Ãû£ºMYSQL_HOME£¬±äÁ¿Öµ£ºC:\Program Files\MySQL\MySQL Server 8.0
±äÁ¿Öµ¿Éͨ¹ýÔĶÁÃûÄ¿Ñ¡ÖÐ
±à×ëPath»·¾³±äÁ¿£¬ÔÚPath»·¾³±äÁ¿µ×²¿Ôö¼Ó£º%MYSQL_HOME%\bin
´Ëʱ»·¾³±äÁ¿ÅäÖÃÍê³É£¬µã»÷¿Ï¶¨Ò»Â··µ»Ø¼´¿É¡£
4¡¢²âÊÔ»·¾³±äÁ¿ÅäÖÃ
ÔÚWindowsÃüÁîÐмüÈënet stop mysql£¬µ«±¨ÈçÏ´í
´Ëʱ´ó¸ÅÊÇmysqlÃû³ÆûÓÐд¶Ô£¬¿ÉÒÔͨ¹ý¼üÈëservices.msc²é¿´mysqlÃû³Æ
ÈçÏÂÎÒ²é³öµÄMySQLÃû³ÆΪMySQL80
½Ó×ÅÔÚÊäÈënet stop MySQL80²âÊÔ£¬´Ëʱ·¢ÉúÁËϵͳ´íÎ󣬻ؾø°Ý·Ã£¬ÕâÊÇÓÉÓÚ²Ù×ÝȨÏÞ²»×㣬¸ÄΪÖÎÀíÔ±²Ù×ݼ´¿É¡£
´Ëʱ¿ÉÖ±½ÓËÑË÷cmd£¬²¢ÓÒ¼üÒÔÖÎÀíÔ±·½Ê½ÔËת£¬»òÕßÖ±½Ó·¿ªcmdÎļþËùÔÚλÖã¬È»ºóÓÒ¼üµã»÷ÃüÁîÐÐÌáÐÑ·û£¬Ñ¡ÖÐÊôÐÔ£¬Ñ¡ÖпìËÙ·½Ê½£¬Ñ¡Öи߼¶£¬¹´Ñ¡ÒÔÖÎÀíÔ±·½Ê½ÔËת¡£
ÎÊÌâÍêÉƽâ¾ö
5¡¢Í¼Ðλ¯ÖÎÀí½çÃæ
¿ÉÒÔÑ¡ÖÐNavicatÀ´Í£Ö¹Í¼Ðλ¯ÖÎÀí
Òý¼öÒ»¸öNavicatµÄ°²Öý̳̣¬ÎÒ¾ÍÊÇ°´ÕÕÕâ¸ö°²Öóɹ¦µÄ£ºhttps://www.cnblogs.com/zktww/p/11546786.html
¸Ð¼¤´ó¼ÒµÄÔĶÁ£¬µ«Ô¸´ó¼ÒÊÕÒæºÜ¶à¡£
±¾ÎÄת×Ô£ºhttps://blog.csdn.net/wyg1973017714/article/details/105163339
Òý¼ö½Ì³Ì£º¡¶MySQL½Ì³Ì¡·
ÒÔÉϾÍÊÇÏê½â2020MySQL°²Öã¨Í¼ÎĽ̳̣©µÄ¾ßÌåÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢°Ù·Ö°ÙÔ´ÂëÍøÆäËüÏà¹ØÎÄÕ£¡
![È¡Ïû](http://www.baidow.com/ds/img/close.jpg)
![°Ù·Ö°ÙÔ´ÂëÍø](http://www.baidow.com/ds/img/logos.png)
¸ÐлÄúµÄÖ§³Ö£¬ÎÒ»á¼ÌÐøŬÁ¦µÄ!
![ɨһɨ ɨÂëÖ§³Ö](http://www.baidow.com/ds/img/alipayimg.jpg)
![Ö§¸¶±¦](http://www.baidow.com/ds/img/alipay.jpg)
![΢ÐÅ](http://www.baidow.com/ds/img/wechat.jpg)
´ò¿ªÖ§¸¶±¦É¨Ò»É¨£¬¼´¿É½øÐÐɨÂë´òÉÍŶ
°Ù·Ö°ÙÔ´ÂëÍø ½¨Òé´òÉÍ1¡«10Ôª£¬ÍÁºÀËæÒ⣬¸ÐлÄúµÄÔĶÁ£¡