网络是联通的,因为在同一主机内,本地连接到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_substitutionmax_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_substitutionmax_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