由于所有解决方案都不适合我，我做了以下操作:

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

1. 以 root 权限打开 Nautilus(Linux 的文件浏览器):sudo nautlius.
2. 导航到 mysql 目录:/opt/lampp/var/mysql.
3. 删除 phpmyadmin 文件夹.这是phpMyAdmin中的phpmyadmin数据库
4. 将create_tables.sql(位于/opt/lampp/phpmyadmin/sql)文件的内容复制到桌面上另一个名为sql 的文件中.sql
5. 打开MySQL命令行界面:/opt/lampp/bin/mysql -uroot -p
6. 然后在 mysql 提示中，我运行脚本以使用 source/home/user/Desktop/sql.sql
创建数据库 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

这为我解决了问题.