I've recently just installed XAMPP and I'm pretty new to all of this. I was trying to open a new DB in phpmyadmin, but it wrote me this error - #1146 - Table 'phpmyadmin.pma_column_info' doesn't exist
.
我最近刚刚安装了XAMPP,我对这一切都很陌生。我试图在phpmyadmin中打开一个新的DB,但是它给我写了一个错误- #1146 -表“phpmyadmin”。pma_column_info”根本不存在。
I looked it up on the web and it said that I need to run a query of create_tables.sql
on the DB "phpmyadmin", but everytime I click on that database it just errors me the same error as before - #1146 - Table 'phpmyadmin.pma_column_info' doesn't exist
.
我在网上查了一下,它说我需要运行create_tables查询。sqlon, DB“phpmyadmin”,但是每次我点击那个数据库,它都会出错,和以前一样的错误- #1146 -表的phpmyadmin。pma_column_info”根本不存在。
Can anyone help me with it?
有人能帮我吗?
Thanks, Dan
谢谢你,丹
4 个解决方案
#1
2
You will find create_tables.sql.gz
file in /usr/share/doc/phpmyadmin/examples/` dir
你会发现create_tables.sql。gz文件在/usr/share/doc/phpmyadmin/examples/ ' dir中
Extract it, sudo file-roller create_tables.sql.gz
and change pma_
prefix by pma__
or vice versa
提取它,sudo文件滚轮create_tables.sql。用pma__改变pma_前缀,反之亦然
Then import you new script SQL from phpmyadmin in your browser
然后在浏览器中从phpmyadmin导入新的脚本SQL
#2
2
sudo dpkg-reconfigure phpmyadmin
That's it.
就是这样。
#3
1
This is an optional feature that require to create tables from create_tables.sql
这是一个可选特性,需要从create_tables.sql创建表
You can disable it just edit the file config.inc.php and comment these lines:
可以禁用它,只需编辑config.inc文件。php和评论这些行:
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
#4
0
Windows If you're using xampp since php 5.6.19 or later on initial setup you need to drop the phpmyadmin database and recreate it using the scripts in X:\xampp\phpMyAdmin\sql
如果您正在使用xampp,从php 5.6.19开始,或者在初始设置之后,您需要删除phpmyadmin数据库并使用X:\xampp\ phpmyadmin \sql中的脚本重新创建它
#1
2
You will find create_tables.sql.gz
file in /usr/share/doc/phpmyadmin/examples/` dir
你会发现create_tables.sql。gz文件在/usr/share/doc/phpmyadmin/examples/ ' dir中
Extract it, sudo file-roller create_tables.sql.gz
and change pma_
prefix by pma__
or vice versa
提取它,sudo文件滚轮create_tables.sql。用pma__改变pma_前缀,反之亦然
Then import you new script SQL from phpmyadmin in your browser
然后在浏览器中从phpmyadmin导入新的脚本SQL
#2
2
sudo dpkg-reconfigure phpmyadmin
That's it.
就是这样。
#3
1
This is an optional feature that require to create tables from create_tables.sql
这是一个可选特性,需要从create_tables.sql创建表
You can disable it just edit the file config.inc.php and comment these lines:
可以禁用它,只需编辑config.inc文件。php和评论这些行:
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
#4
0
Windows If you're using xampp since php 5.6.19 or later on initial setup you need to drop the phpmyadmin database and recreate it using the scripts in X:\xampp\phpMyAdmin\sql
如果您正在使用xampp,从php 5.6.19开始,或者在初始设置之后,您需要删除phpmyadmin数据库并使用X:\xampp\ phpmyadmin \sql中的脚本重新创建它