我正试图在笔记本电脑上设置PHP
,我正在使用WAMPP
服务器,但当我尝试进入PHPMyAdmin
位时,它显示
您没有在此服务器上访问/phpmyadmin/的权限。
我该如何度过难关?
顺便说一句,我正试图将MySQL workbench
与PHP
链接起来,但我不知道如何在我的笔记本电脑上运行一个小网站,但当我注册新会员时,我会得到
无法执行查询
编辑在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实例。