作者:手机用户2502856553 | 来源:互联网 | 2023-05-16 07:39
phpMyAdmin图形化工具操作MYSQL,在地址栏输入:http:\\localhost\phpMyAdmin,输入账户和密码,正常可用,但不知怎么的,时好时坏,会在web页面提
phpMyAdmin图形化工具操作MYSQL,在地址栏输入:http:\\localhost\phpMyAdmin,输入账户和密码,正常可用,但不知怎么的,时好时坏,会在web页面提示:
phpMyAdmin - error
#2005 - Unknown MySQL server host 'localhost' (11001)
我自己也重启mysql服务,也不行,重启PC后再重启mysql,就会好,弄的很郁闷,要是每次出问题都重启,真是受不了,在网上也查询了一下,也没解决办法.
今天这这里提问,希望有前辈给予指导,俺是才刚开始学数据库.在线等................................
9 个解决方案
先在localhost用mysql客户端试试是否正常
可以将localhost改成127.0.0.1 试试看
3楼,我的mysql是启动;
2楼,我把localhost换成127.0.0.1后,确实是没问题了,但这样是否确保以后就正常? 127.0.0.1作为本机的环回地址,在地址栏输入localhost与127.0.0.1 在细节上有什么区别?
你的主机上的localhost对应不到本机
检查如下文件
Windows中hosts 在c:\windows\system32\drives\etc\hosts
linux 在 /etc/hosts
恩 ,我查看了下PC本地的host文件:如下
# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host
# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost
没有你所说的对应不上哦?
查看默认数据库mysql的user表,是否有localhost这个host
# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host
# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost
127.0.0.1 localhost
127.0.0.1 localhost
我的是这样,比你多两行