WAMP服务器不允许访问PHPMyAdmin


WAMP server wont allow access to PHPMyAdmin

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

您没有在此服务器上访问/phpmyadmin/的权限。

我该如何度过难关?

顺便说一句,我正试图将MySQL workbenchPHP链接起来,但我不知道如何在我的笔记本电脑上运行一个小网站,但当我注册新会员时,我会得到

无法执行查询

编辑MySQL log中,它显示以下

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实例。