使用XAMPP在phpmyadmin上拒绝访问

Question

当我试图导航到这个URLhttp://localhost/phpmyadmin/(使用Access denied! )时，我得到了http://localhost/phpmyadmin/。

今天发生了这件事。昨天它运行得很好，从那以后我没有改变xampp文件夹中的任何东西。

下面是我的mysq.log文件输出。

2022-03-21 15:39:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-03-21 15:39:35 0 [Note] InnoDB: Uses event mutexes
2022-03-21 15:39:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-21 15:39:35 0 [Note] InnoDB: Number of pools: 1
2022-03-21 15:39:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-03-21 15:39:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-03-21 15:39:35 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-21 15:39:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-03-21 15:39:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-03-21 15:39:39 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-03-21 15:39:39 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-03-21 15:39:39 0 [Note] InnoDB: Waiting for purge to start
2022-03-21 15:39:39 2 [ERROR] InnoDB: Page [page id: space=647, page number=1] log sequence number 3470890319 is in the future! Current system log sequence number 598292042.
2022-03-21 15:39:39 2 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-03-21 15:39:39 2 [ERROR] InnoDB: Page [page id: space=615, page number=1] log sequence number 3339553304 is in the future! Current system log sequence number 598292042.
2022-03-21 15:39:39 2 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-03-21 15:39:39 4 [ERROR] InnoDB: Page [page id: space=618, page number=0] log sequence number 3462892962 is in the future! Current system log sequence number 598292042.
2022-03-21 15:39:39 1 [ERROR] InnoDB: Page [page id: space=579, page number=1] log sequence number 3262714642 is in the future! Current system log sequence number 598292042.
2022-03-21 15:39:39 4 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-03-21 15:39:39 1 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-03-21 15:39:39 4 [ERROR] InnoDB: Page [page id: space=618, page number=1] log sequence number 3462891605 is in the future! Current system log sequence number 598292042.
2022-03-21 15:39:39 4 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-03-21 15:39:39 1 [ERROR] InnoDB: Page [page id: space=616, page number=1] log sequence number 3426045456 is in the future! Current system log sequence number 598292042.
2022-03-21 15:39:39 1 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-03-21 15:39:39 0 [Note] InnoDB: 10.4.14 started; log sequence number 598292033; transaction id 2595064
2022-03-21 15:39:39 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-03-21 15:39:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-21 15:39:39 0 [Note] InnoDB: Buffer pool(s) load completed at 220321 15:39:39
2022-03-21 15:39:39 0 [Note] Server socket created on IP: '::'.

下面是我的phpmyadmin用户界面错误。

​

​

Answer 1

我解决了问题。

我所做的：

步骤1:我已经将来自xampp/mysql/data的所有文件复制到备份文件夹中(只需在桌面上创建一个文件夹并将文件放在那里)。

步骤2:然后卸载XAMPP，并再次安装(最新版本，我认为是很长一段时间以来的版本-)

步骤3:在此之后，我将名为xampp/mysql/data的文件从备份文件夹复制到ibdata1，并将具有数据库名的文件夹(从步骤1的备份文件夹)复制到xampp/mysql/data

另外，我读到了关于以下问题的第一篇文章：@Senthilnadhan Ramasamy的MySql意外停止，我在2-3年前就这样做过一次，然后它就不再起作用了，就像今天一样，所以我不得不重新安装并执行上述所有步骤。

Answer 2

我对这个问题不太清楚，可能是因为很多原因。但我建议你-

1. 单击MySQL旁边的Xammp控制面板上的配置。
2. 编辑my.ini文件
3. 您必须在mysqld之后写这行skip-grant-tables。
4. 将port=3306更改为port=3307
5. 打开Xammp文件夹-> PhpMyAdmin .You将在phpMyAdmin文件夹中看到phpMyAdmin文件。在此文件中，查找$cfg‘’Servers‘’host‘= '127.0.0.1';并将其更改为$cfg’‘Servers’host‘= 'localhost:3307';

保存这些更改。您可以找到端口号如下:打开Xammp >config->service port设置->mySql.

现在您将能够访问Phpmyadmin。