php - WAMP 服务器不允许访问 PHPMyAdmin-6ren

php - WAMP 服务器不允许访问 PHPMyAdmin

转载作者：行者123 更新时间：2023-11-29 11:31:34

我正在尝试在笔记本电脑上设置 PHP，并且使用 WAMPP 服务器，但是当我尝试进入 PHPMyAdmin位，它显示

You don't have permission to access /phpmyadmin/ on this server.

我该如何解决这个问题？

顺便说一句，我正在尝试将 MySQL workbench 与 PHP 链接起来，但我不知道如何做，因为我想在上面运行一个小网站我的笔记本电脑，但是当我去注册新成员(member)时，我得到

Could not execute query

编辑在 MySQL 日志 中显示以下内容

160518 16:11:56 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160518 16:11:56  InnoDB: Initializing buffer pool, size = 128.0M
160518 16:11:56  InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
160518 16:11:56  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
160518 16:11:57  InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...   
160518 16:11:57  InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
160518 16:11:59  InnoDB: 1.1.4 started; log sequence number 0
160518 16:11:59 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160518 16:11:59 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160518 16:11:59 [ERROR] Aborting

160518 16:11:59  InnoDB: Starting shutdown...
160518 16:12:01  InnoDB: Shutdown completed; log sequence number 1595675
160518 16:12:01 [Note] wampmysqld: Shutdown complete

160518 16:34:02 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160518 16:34:02  InnoDB: Initializing buffer pool, size = 128.0M
160518 16:34:02  InnoDB: Completed initialization of buffer pool
160518 16:34:02  InnoDB: highest supported file format is Barracuda.
160518 16:34:02  InnoDB: 1.1.4 started; log sequence number 1595675
160518 16:34:02 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160518 16:34:02 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160518 16:34:02 [ERROR] Aborting

160518 16:34:03  InnoDB: Starting shutdown...
160518 16:34:04  InnoDB: Shutdown completed; log sequence number 1595675
160518 16:34:04 [Note] wampmysqld: Shutdown complete

160518 16:54:31 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160518 16:54:31  InnoDB: Initializing buffer pool, size = 128.0M
160518 16:54:31  InnoDB: Completed initialization of buffer pool
160518 16:54:32  InnoDB: highest supported file format is Barracuda.
160518 16:54:32  InnoDB: 1.1.4 started; log sequence number 1595675
160518 16:54:32 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160518 16:54:32 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160518 16:54:32 [ERROR] Aborting

160518 16:54:32  InnoDB: Starting shutdown...
160518 16:54:33  InnoDB: Shutdown completed; log sequence number 1595675
160518 16:54:33 [Note] wampmysqld: Shutdown complete

160518 17:48:21 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160518 17:48:21  InnoDB: Initializing buffer pool, size = 128.0M
160518 17:48:21  InnoDB: Completed initialization of buffer pool
160518 17:48:21  InnoDB: highest supported file format is Barracuda.
160518 17:48:22  InnoDB: 1.1.4 started; log sequence number 1595675
160518 17:48:22 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160518 17:48:22 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160518 17:48:22 [ERROR] Aborting

160518 17:48:22  InnoDB: Starting shutdown...
160518 17:48:23  InnoDB: Shutdown completed; log sequence number 1595675
160518 17:48:23 [Note] wampmysqld: Shutdown complete

160519  8:42:25 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160519  8:42:25  InnoDB: Initializing buffer pool, size = 128.0M
160519  8:42:25  InnoDB: Completed initialization of buffer pool
160519  8:42:26  InnoDB: highest supported file format is Barracuda.
160519  8:42:27  InnoDB: 1.1.4 started; log sequence number 1595675
160519  8:42:27 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160519  8:42:27 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160519  8:42:27 [ERROR] Aborting

160519  8:42:27  InnoDB: Starting shutdown...
160519  8:42:28  InnoDB: Shutdown completed; log sequence number 1595675
160519  8:42:28 [Note] wampmysqld: Shutdown complete

160519  9:48:56 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160519  9:48:56  InnoDB: Initializing buffer pool, size = 128.0M
160519  9:48:56  InnoDB: Completed initialization of buffer pool
160519  9:48:56  InnoDB: highest supported file format is Barracuda.
160519  9:48:56  InnoDB: 1.1.4 started; log sequence number 1595675
160519  9:48:56 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160519  9:48:56 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160519  9:48:56 [ERROR] Aborting

160519  9:48:56  InnoDB: Starting shutdown...
160519  9:48:57  InnoDB: Shutdown completed; log sequence number 1595675
160519  9:48:57 [Note] wampmysqld: Shutdown complete

160519  9:50:35 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160519  9:50:35  InnoDB: Initializing buffer pool, size = 128.0M
160519  9:50:35  InnoDB: Completed initialization of buffer pool
160519  9:50:35  InnoDB: highest supported file format is Barracuda.
160519  9:50:35  InnoDB: 1.1.4 started; log sequence number 1595675
160519  9:50:35 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160519  9:50:35 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160519  9:50:35 [ERROR] Aborting

160519  9:50:35  InnoDB: Starting shutdown...
160519  9:50:37  InnoDB: Shutdown completed; log sequence number 1595675
160519  9:50:37 [Note] wampmysqld: Shutdown complete

160519  9:51:03 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160519  9:51:03  InnoDB: Initializing buffer pool, size = 128.0M
160519  9:51:03  InnoDB: Completed initialization of buffer pool
160519  9:51:03  InnoDB: highest supported file format is Barracuda.
160519  9:51:04  InnoDB: 1.1.4 started; log sequence number 1595675
160519  9:51:04 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160519  9:51:04 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160519  9:51:04 [ERROR] Aborting

160519  9:51:04  InnoDB: Starting shutdown...
160519  9:51:05  InnoDB: Shutdown completed; log sequence number 1595675
160519  9:51:05 [Note] wampmysqld: Shutdown complete

160519  9:51:15 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160519  9:51:15  InnoDB: Initializing buffer pool, size = 128.0M
160519  9:51:15  InnoDB: Completed initialization of buffer pool
160519  9:51:15  InnoDB: highest supported file format is Barracuda.
160519  9:51:15  InnoDB: 1.1.4 started; log sequence number 1595675
160519  9:51:15 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160519  9:51:15 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160519  9:51:15 [ERROR] Aborting

160519  9:51:15  InnoDB: Starting shutdown...
160519  9:51:16  InnoDB: Shutdown completed; log sequence number 1595675
160519  9:51:16 [Note] wampmysqld: Shutdown complete

160519  9:51:36 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160519  9:51:36  InnoDB: Initializing buffer pool, size = 128.0M
160519  9:51:36  InnoDB: Completed initialization of buffer pool
160519  9:51:36  InnoDB: highest supported file format is Barracuda.
160519  9:51:36  InnoDB: 1.1.4 started; log sequence number 1595675
160519  9:51:36 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160519  9:51:36 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160519  9:51:36 [ERROR] Aborting

160519  9:51:37  InnoDB: Starting shutdown...
160519  9:51:37  InnoDB: Shutdown completed; log sequence number 1595675
160519  9:51:37 [Note] wampmysqld: Shutdown complete

160519  9:51:41 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160519  9:51:41  InnoDB: Initializing buffer pool, size = 128.0M
160519  9:51:41  InnoDB: Completed initialization of buffer pool
160519  9:51:41  InnoDB: highest supported file format is Barracuda.
160519  9:51:41  InnoDB: 1.1.4 started; log sequence number 1595675
160519  9:51:42 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160519  9:51:42 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160519  9:51:42 [ERROR] Aborting

160519  9:51:42  InnoDB: Starting shutdown...
160519  9:51:43  InnoDB: Shutdown completed; log sequence number 1595675
160519  9:51:43 [Note] wampmysqld: Shutdown complete

160519  9:51:51 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160519  9:51:51  InnoDB: Initializing buffer pool, size = 128.0M
160519  9:51:51  InnoDB: Completed initialization of buffer pool
160519  9:51:51  InnoDB: highest supported file format is Barracuda.
160519  9:51:51  InnoDB: 1.1.4 started; log sequence number 1595675
160519  9:51:52 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160519  9:51:52 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160519  9:51:52 [ERROR] Aborting

160519  9:51:52  InnoDB: Starting shutdown...
160519  9:51:53  InnoDB: Shutdown completed; log sequence number 1595675
160519  9:51:53 [Note] wampmysqld: Shutdown complete

160519 10:12:25 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160519 10:12:25  InnoDB: Initializing buffer pool, size = 128.0M
160519 10:12:25  InnoDB: Completed initialization of buffer pool
160519 10:12:25  InnoDB: highest supported file format is Barracuda.
160519 10:12:25  InnoDB: 1.1.4 started; log sequence number 1595675
160519 10:12:26 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160519 10:12:26 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160519 10:12:26 [ERROR] Aborting

160519 10:12:26  InnoDB: Starting shutdown...
160519 10:12:27  InnoDB: Shutdown completed; log sequence number 1595675
160519 10:12:27 [Note] wampmysqld: Shutdown complete

160519 10:12:31 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160519 10:12:31  InnoDB: Initializing buffer pool, size = 128.0M
160519 10:12:31  InnoDB: Completed initialization of buffer pool
160519 10:12:31  InnoDB: highest supported file format is Barracuda.
160519 10:12:32  InnoDB: 1.1.4 started; log sequence number 1595675
160519 10:12:32 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160519 10:12:32 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160519 10:12:32 [ERROR] Aborting

160519 10:12:32  InnoDB: Starting shutdown...
160519 10:12:33  InnoDB: Shutdown completed; log sequence number 1595675
160519 10:12:33 [Note] wampmysqld: Shutdown complete

160519 10:12:38 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160519 10:12:38  InnoDB: Initializing buffer pool, size = 128.0M
160519 10:12:38  InnoDB: Completed initialization of buffer pool
160519 10:12:38  InnoDB: highest supported file format is Barracuda.
160519 10:12:39  InnoDB: 1.1.4 started; log sequence number 1595675
160519 10:12:39 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160519 10:12:39 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160519 10:12:39 [ERROR] Aborting

160519 10:12:39  InnoDB: Starting shutdown...
160519 10:12:40  InnoDB: Shutdown completed; log sequence number 1595675
160519 10:12:40 [Note] wampmysqld: Shutdown complete

160519 10:12:54 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160519 10:12:54  InnoDB: Initializing buffer pool, size = 128.0M
160519 10:12:54  InnoDB: Completed initialization of buffer pool
160519 10:12:54  InnoDB: highest supported file format is Barracuda.
160519 10:12:54  InnoDB: 1.1.4 started; log sequence number 1595675
160519 10:12:54 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160519 10:12:54 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160519 10:12:54 [ERROR] Aborting

160519 10:12:54  InnoDB: Starting shutdown...
160519 10:12:56  InnoDB: Shutdown completed; log sequence number 1595675
160519 10:12:56 [Note] wampmysqld: Shutdown complete

160519 10:13:21 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
160519 10:13:21  InnoDB: Initializing buffer pool, size = 128.0M
160519 10:13:21  InnoDB: Completed initialization of buffer pool
160519 10:13:21  InnoDB: highest supported file format is Barracuda.
160519 10:13:21  InnoDB: 1.1.4 started; log sequence number 1595675
160519 10:13:21 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
160519 10:13:21 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160519 10:13:21 [ERROR] Aborting

160519 10:13:21  InnoDB: Starting shutdown...
160519 10:13:22  InnoDB: Shutdown completed; log sequence number 1595675
160519 10:13:22 [Note] wampmysqld: Shutdown complete

最佳答案

看起来您有 2 个 MYSQL 服务器正在运行。

当您安装 MYSQL Workbench 时，它还安装了另一个 MYSQL Server。两者都使用端口 3306。一个 MySQL Server 实例对于任何人来说都足够了。

Workbench 附带的 MYSQL Server 设置为“启动时自动启动”，但 WAMPServer 仅在启动 WAMPServer 时才启动 MYSQL Server。所以WAMPServer中的那个说别人抢了3306端口，我无法启动。

你只需要一台MYSQL Server就可以运行100个数据库，所以我建议你卸载WorkBench自带的MYSQL Server。

完全卸载 WorkBench 可能会更容易。然后重新安装它，但没有附带的MYSQL Server实例。

关于php - WAMP 服务器不允许访问 PHPMyAdmin，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/37318564/

文章推荐： php mysqli 查询期望参数 1 为字符串

文章推荐： python - Django 和 PostgreSQL 事务的默认隔离级别 (@atomic)

文章推荐： ios - iphone "add to home screen"忽略查询字符串参数

文章推荐： postgresql - 将数据从 postgres 卸载到 s3

asp.net - 允许允许 AD 组访问
我有一个 ASP.NET 网站，我希望只允许 AD 组中的用户访问该网站。我正在使用如下的 web.config 片段，但这似乎不起作用:
javascript - 即使有一个框未选中，如何禁用“允许”按钮？仅当选中所有复选框时才应启用“允许”按钮？
仅当选中所有框时才应禁用“允许”按钮。我该怎么做？我已经完成了 HTML 部分，如下所示。如何执行其中的逻辑部分？即使未选中一个复选框，也应禁用“允许”按钮
flutter - 允许 'context'移至不同的Dart文件
当前有一个Navigator.push(context，route)，但是上下文部分返回了错误，在尝试调试后，我发现问题是因为我在调用一个函数而不是直接将home设置为widget树。但是现在我不确定
java - 邮政编码的正则表达式 - 允许
这是我的邮政编码正则表达式 ^[a-zA-Z0-9]{1,9}$ 但不允许 A-12345。如何更改 - 也将被允许的正则表达式？最佳答案在字符集的开头或结尾添加-([...]): ^[-a-zA
javascript - 允许/激活浏览器中的混合内容
我目前正在建立我的网站，但遇到了一个问题 JavaScript 中的混合内容阻止当我尝试加载和显示来自的图像和页面时，Chrome、Mozilla 和 Explorer 会发生这种情况http 我
mysql - 远程连接mysql，允许 *
我见过使用: [mysqld] bind-address = 255.112.324.12 允许远程访问单个 IP。我如何允许从 mysql 远程访问所有 IP？最佳答案如果你想允许它用于所
c++ - 允许/禁用模板的特定复制构造函数和赋值操作
我想知道是否可以使用模板实现某些功能。我想要做的是允许特定的“复制构造函数和赋值运算符”从一个模板到另一个模板并禁用其他模板。我想我只完成了一件我想要的事情，所以我提供了下面的类(class)。对于
php - 允许 + 在正则表达式电子邮件中验证电子邮件
这个问题在这里已经有了答案: How to validate an email address in PHP (15 个答案) 关闭 2 年前。正则表达式让我大吃一惊。我如何更改此设置以验证带有加
允许 -/或 .作为日期内的分隔符
解析可以采用以下格式之一的日期的最佳方法是什么 "dd-MM-yyyy HH:mm" "dd/MM/yyyy HH:mm" "dd.MM.yyyy HH:mm" 无需创建 3 个 SimpleD
c++ - 允许 `this->` 访问依赖基类的成员的规则是什么？
我们知道，下面的代码格式不正确，因为成员 x 在依赖的基类中。但是，将指定行上的 x 更改为 this->x 将修复错误。 template struct B { int x; }; tem
java - 允许 this 引用转义
如果能帮助我理解“Java 并发实践”中的以下内容，我将不胜感激: Calling an overrideable instance method(one that is neither privat
允许 WordPress 上传任意文件的方法
此时如果上传一个不在预定义的安全扩展名列表，如.lrc，会报错： File type does not meet security guidelines. Try another. 解决此问题有
passwords - 允许 XMPP 用户根据韵律更改密码
我有一个运行韵律，可以为我的几个域和一个 friend 域处理 XMPP。我 friend 域中的一位用户(他的妻子)想更改她的密码(实际上她忘记了她，所以我会用 prosodyctl 设置一个，然后
nginx 允许|拒绝 $realip_remote_addr
使用 nginx，您可以允许和拒绝范围和 ips (https://www.nginx.com/resources/admin-guide/restricting-access/)。使用realip模
r - 允许 map 上权重重的点压倒其他权重低的点的选项
什么是一些好的克里金法/插值想法/选项，可以让重度权重的点在绘制的 R map 上的轻权重点上流血？康涅狄格州有八个县。我找到了质心并想绘制这八个县中每个县的贫困率。其中三个县人口稠密(约 100
virtualbox - 允许 Vagrant 访问主机互联网
我正在使用 virtualbox + ubuntu + vagrant . 但是我不能ping或 wget任何网址。请指导我如何允许虚拟机访问我的主机的互联网？最佳答案这对我有用。使用此配置 V
swift - 允许 inout 参数的默认值
标题可能有点令人困惑，所以让我向您解释一下。在 Swift 中，我们可以拥有带有默认参数值的函数，例如: func foo(value: Int = 32) { } 我们也可以有 In-Out 参数
android - 允许 TextView 增长到约束布局中的某个点
有TextView1 和TextView2。 TextView2 应该 float 在 TextView1 的右侧。只要两个 TextView 的总宽度不使 TextView2 与右侧的框重叠，Tex
Magento addFieldToFilter 允许 NULL
使用 Magento 收集方法 addFieldToFilter 时是否可以允许按 NULL 值进行过滤？我想选择集合中具有自定义属性的所有产品，即使没有为该属性分配任何值。最佳答案您不需要使用
.htaccess - 允许 .htaccess 文件中的文件夹的规则
我正试图从 .htaccess 文件中的规则中“排除”一个目录(及其所有文件夹)... 不确定这是否可能？ .htaccess 文件是这样的: Order Allow,Deny Deny from a

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

php - WAMP 服务器不允许访问 PHPMyAdmin