且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

phpMyAdmin错误:引擎中不存在表

更新时间:2022-06-16 02:23:57

由于没有一种解决方案适合我,因此我执行了以下操作:

Since none of the solutions worked for me I did the following:

  1. 以root特权:sudo nautlius打开Nautilus(Linux的文件浏览器).
  2. 导航到mysql目录:/opt/lampp/var/mysql.
  3. 删除phpmyadmin文件夹.这是phpMyAdmin中的phpmyadmin数据库
  4. create_tables.sql(位于/opt/lampp/phpmyadmin/sql中找到)文件的内容复制到桌面上名为sql.sql
  5. 的另一个文件中
  6. 打开MySQL命令行界面:/opt/lampp/bin/mysql -uroot -p
  7. 然后在mysql提示符中运行脚本以使用source /home/user/Desktop/sql.sql
  8. 创建数据库phpmyadmin
  1. Open Nautilus (Linux's file explorer) with root privileges: sudo nautlius.
  2. Navigate to the mysql directory: /opt/lampp/var/mysql.
  3. Delete the phpmyadmin folder. This is the phpmyadmin database in phpMyAdmin
  4. Copy the content of the create_tables.sql (found at /opt/lampp/phpmyadmin/sql) file to another one on the desktop called sql.sql
  5. Open the MySQL command line interface: /opt/lampp/bin/mysql -uroot -p
  6. Then in the mysql promp I ran the script to create the database phpmyadmin with source /home/user/Desktop/sql.sql

那为我解决了这个问题.

That solved the problem for me.