91ÖÆÆ¬×°ÖÃÏêϸ°ì·¨¼°Çé¿öÅäÖÃ

À´Ô´£ºÖ¤È¯Ê±±¨Íø×÷Õߣº
×ÖºÅ

Êý¾Ý¿â

ÏÂÔØ²¢½âѹÊý¾Ý¿âÈí¼þ°ü£º´Ó¹Ù·½ÍøÕ¾ÏÂÔØ×îа汾µÄMySQL£¬²¢½âѹµ½?ЧÀÍÆ÷µÄÖ¸¶¨Ä¿Â¼¡£³õʼ»¯Êý¾Ý¿â£ºÔÚÊý¾Ý¿âĿ¼Ï£¬Ö´ÐÐÒÔÏÂÃüÁî³õʼ»¯Êý¾Ý¿â£ºsudomysql_install_db--user=mysql--basedir=/path/to/mysql--datadir=/path/to/dataÆô¶¯Êý¾Ý¿âЧÀÍ£ºÖ´ÐÐÒÔÏÂÃüÁîÆô¶¯MySQLЧÀÍ£ºsudosystemctlstartmysqlÉèÖÃÊý¾Ý¿â¸ùÃÜÂ룺ִÐÐÒÔÏÂÃüÁîÉèÖÃMySQLÊý¾Ý¿âµÄ¸ùÓû§ÃÜÂ룺sudomysql_secure_installation

Ô¤ÀÀÓëÉú´æ

ÔÚ±à?¼­Íê³Éºó£¬Äú¿ÉÒÔµã»÷¡°Ô¤ÀÀ¡±°´Å¥£¬¼ì²ìÊÓÆµÐ§¹û¡£Èç¹ûÂúÒ⣬¿ÉÒÔµã»÷¡°Éú´æ¡±°´Å¥£¬Ñ¡ÔñºÏÊʵύÑùºÍÇø·ÖÂʽøÐе¼³ö¡£

±¾Îĵ½´Ë½áÊø£¬Ï£Íûͨ¹ýÏêϸµÄ×°Öð취ºÍÇé¿öÅäÖÃÖ¸ÄÏ£¬Äܹ»×ÊÖúÄú¿ìËÙÉÏÊÖ91ÖÆÆ¬£¬¸ßЧÍê³ÉÊÓÆµÖÆ×÷ÈÎÎñ¡£ÎÞÂÛÊÇÐÂÊÖÕÕ¾ÉÓо­ÑéµÄÓû§£¬Ö»Òª×ñÑ­±¾ÎÄÖеİ취£¬ÄúÒ»¶¨Äܹ»ÇáËÉÕÆÎÕÕâ¿îÇ¿´óµÄÊÓÆµÖÆ×÷¹¤¾ß£¬´´×÷³öÁîÈ˾ªÌ¾µÄÊÓÆµ×÷Æ·¡£

Êý¾Ý¿âÓû§È¨ÏÞ

´´Á¢×¨ÓõÄÊý¾Ý¿âÓû§£¬²¢½öÊÚÓèÆäËùÐèµÄ×îСȨÏÞ¡£ÖÆÖ¹Ê¹ÓÃrootÓû§½øÐÐÈÕ³£²Ù×÷¡£

CREATEUSER'91ÖÆÆ¬_user'@'localhost'IDENTIFIEDBY'your_password';GRANTALLPRIVILEGESON91ÖÆÆ¬.*TO'91ÖÆÆ¬_user'@'localhost';FLUSHPRIVILEGES;

ϵͳҪÇó

ÔÚ¿ªÊ¼×°ÖÃ91ÖÆÆ¬Ö®Ç°£¬ÇëÈ·±£ÄúµÄµçÄÔÇкÏÒÔÏÂϵͳҪÇó£º

²Ù×÷ϵͳ£ºWindows7¼°ÒÔÉϰ汾£¨ÍƼöʹÓÃWindows10£©Äڴ棺ÖÁÉÙ4GBRAMÓ²Å̿ռ䣺ÖÁÉÙ500MBµÄ¿ÉÓÿռäCPU£ºÖ§³Ö¶àÏ̴߳¦ÀíµÄ´¦ÀíÆ÷ÏÔ¿¨£ºÖ§³ÖDirectX11»ò¸ü¸ß°æ±¾µÄÏÔ¿¨

Íê³É×°Öò¢²âÊÔ

×°ÖÃÍê³É?ºó£¬ÄúÐèÒª¶Ôϵͳ½øÐвâÊÔ£¬ÒÔÈ·±£Ò»ÇÐÕý³£ÔËÐС £¿ÉÒÔʵÑéµÇ¼ϵͳ£¬¼ì²ì»ù±¾¹¦Ð§ÊÇ·ñÕý³££¬ÈçÓû§ÖÎÀí¡¢ÏîÄ¿ÖÎÀíµÈ¡£

ÔÚÈ·±£91ÖÆÆ¬Èí¼þ×°ÖÃÀֳɺó£¬ÎÒÃǽ«½øÒ»²½Ì½ÌÖÇé¿öÅäÖõÄϸ½Ú£¬È·±£ÏµÍ³µÄ¸ßЧÔËÐкÍÊý¾ÝÄþ¾²¡£Çé¿öÅäÖðüÀ¨Ð§ÀÍÆ÷ÉèÖá¢Êý¾Ý¿âÓÅ»¯¡¢Äþ¾²ÅäÖõȶà¸ö·½Ãæ¡£

Êý¾Ý¿â¼ÓÃÜ

ÆôÓÃÊý¾Ý¿â¼ÓÃÜ£¬±£»¤Ãô¸ÐÊý¾Ý¡ £¿ÉÒÔʹÓÃMySQLµÄSSL/TLS¹¦Ð§£º

#MySQLÅäÖÃÎļþ£¨my.cnf£©clientssl-ca=/path/to/ca-cert.pemssl-cert=/path/to/client-cert.pemssl-key=/path/to/client-key.pemmysqldssl-ca=/path/to/ca-cert.pemssl-cert=/path/to/server-cert.pemssl-key=/path/to/server-key.pem

Êý¾Ý¿â²ÎÊýµ÷½â

ƾ¾Ýϵͳ¸ºÔØÇé¿ö£¬µ÷½âMySQL»òPostgreSQLµÄ²ÎÊý£¬ÒÔÌá¸ßÅÌÎÊËٶȺÍÏìӦʱ¼ä¡£ÀýÈ磬¿ÉÒÔµ÷½âÒÔϲÎÊý£º

#MySQLÅäÖÃÎļþ£¨my.cnf£©innodb_buffer_pool_size=2Gquery_cache_size=64Mquery_cache_type=1

×ñѭһЩÄþ¾²×î¼Ñʵ¼ù£¬°üÀ¨µ«²»ÏÞÓÚ£º

°´ÆÚ¸ü»»ÃÜÂ룺°´ÆÚ¸ü»»ÏµÍ³ºÍÊý¾Ý¿âµÄÃÜÂë£¬ÖÆÖ¹³¤Ê±¼äʹÓÃÏàͬÃÜÂ롣ʹÓüÓÃÜ´«Ê䣺ȷ±£Êý¾ÝÔÚ´«ÊäÀú³ÌÖÐʹÓüÓÃÜ£¨ÈçHTTPS£©¡£×îСȨÏÞÔ­Ôò£ºÖ»ÊÚÓèÓû§ºÍ½ø³ÌËùÐèµÄ×îСȨÏÞ¡£

ͨ¹ýÒÔÉϰ취ºÍ²½·¥£¬Äú¿ÉÒÔÈ·±£91ÖÆÆ¬Èí¼þµÄ×°ÖúÍÇé¿öÅäÖÃÊÇÄþ¾²¡¢¸ßЧÇÒÎȶ¨µÄ¡£Èç¹ûÐèÒª½øÒ»²½µÄ×ÊÖú»òÓÐÈκÎÎÊÌ⣬ÇëËæÊ±ÁªÏµ¼¼ÊõÖ§³ÖÍŶӡ£

У¶Ô£ºÕÅÑÅÇÙ(1C0m4pJyqZtPma0S7t9ZFfz4hTykKag)

ÔðÈα༭£º ÂÞÓÑÖ¾
ΪÄãÍÆ¼ö
Óû§ÆÀÂÛ
µÇ¼ºó¿ÉÒÔ̸»°
ÍøÓÑÆÀÂÛ½ö¹©Æä±í´ï¸öÈË¿´·¨£¬²¢²»±êÃ÷֤ȯʱ±¨Á¢³¡
ÔÝÎÞÆÀÂÛ