網路是聯通的,因為在同一主機內,本地串連到mysql伺服器,和運行環境無關,php,python串連資料庫都有這種情況出現
提示
Can't connect to MySQL server on 'localhost'
下面是my.ini檔案內容,已經省略注釋
[client]port=3306[mysql]default-character-set=utf8[mysqld]port=3306basedir="E:/mysql/"datadir="e:/mysql/data/"default-character-set=utf8default-storage-engine=MYISAMsql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"max_connections=5000query_cache_size=52Mtable_cache=4100tmp_table_size=64Mthread_cache_size=64myisam_max_sort_file_size=100Gmyisam_sort_buffer_size=80Mkey_buffer_size=256Mread_buffer_size=64Kread_rnd_buffer_size=256Ksort_buffer_size=16Mskip-innodbinnodb_additional_mem_pool_size=2Minnodb_flush_log_at_trx_commit=1innodb_log_buffer_size=1Minnodb_buffer_pool_size=8Minnodb_log_file_size=10Minnodb_thread_concurrency=18wait_timeout=28800thread_concurrency=4skip-lockinglog-slow-queries = slow.loglong_query_time = 1max_connections = 1000max_allowed_packet = 32Minteractive_timeout = 28800
回複內容:
網路是聯通的,因為在同一主機內,本地串連到mysql伺服器,和運行環境無關,php,python串連資料庫都有這種情況出現
提示
Can't connect to MySQL server on 'localhost'
下面是my.ini檔案內容,已經省略注釋
[client]port=3306[mysql]default-character-set=utf8[mysqld]port=3306basedir="E:/mysql/"datadir="e:/mysql/data/"default-character-set=utf8default-storage-engine=MYISAMsql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"max_connections=5000query_cache_size=52Mtable_cache=4100tmp_table_size=64Mthread_cache_size=64myisam_max_sort_file_size=100Gmyisam_sort_buffer_size=80Mkey_buffer_size=256Mread_buffer_size=64Kread_rnd_buffer_size=256Ksort_buffer_size=16Mskip-innodbinnodb_additional_mem_pool_size=2Minnodb_flush_log_at_trx_commit=1innodb_log_buffer_size=1Minnodb_buffer_pool_size=8Minnodb_log_file_size=10Minnodb_thread_concurrency=18wait_timeout=28800thread_concurrency=4skip-lockinglog-slow-queries = slow.loglong_query_time = 1max_connections = 1000max_allowed_packet = 32Minteractive_timeout = 28800
連結參數試一下 127.0.0.1