I upgraded my local testlink mysql server to 5.5.20, and I was trying to import testlink DB to the new version, I was facing an error
error:
#1100 - Table 'pma_column_info' was not locked with LOCK TABLES
I tried to look for solution for it online, found some people suggesting commenting the following line in PhpMyAdmin config file
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
tried this, but the import process with giving this time different error
#1146 - Table 'testlink.pma_tracking' doesn't exist
I tried commenting all Advanced phpMyAdmin features, still the import wasn’t working, with different error this time
I read in some forums that I need to install DB create script for advanced features located in
C:\Program Files (x86)\EasyPHP-5.3.9\modules\phpmyadmin\scripts\create_tables.sql
still I was having errors while importing
I noticed in PhpMyConfig file that there are 2 lines for advanced features user name and password, and the lines were commented, I uncommented these 2 lines, uncommented the advanced features configuration, set the user name and password for the root user, saved the config file, then tried to import, worked perfect
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'password';
Thanks. It's awesome and helpful
ReplyDeleteHi
ReplyDeleteThat was very helpful
I change the user and pass and it solve this issue
tnx again
Thanks for help! Seems like very few people really know what's up with this error - glad you found a solution.
ReplyDeleteThank you. Had the same problem with import of the backup from hosting company to phpMyAdmin (I suspect that it was because it was using "Lock Tables").
ReplyDeleteAdding those two lines helped (actually I had to add those lines to config.inc manually, were not present as comments).
Documentation.txt in phpMyAdmin says more about the purpose of those lines:
This special account is used for 2 distinct purposes: to make possible all
relational features (see $cfg['Servers'][$i]['pmadb']) and, for a MySQL
server running with --skip-show-database, to enable a multi-user
installation (HTTP or cookie authentication mode).
When using HTTP or cookie authentication modes (or 'config' authentication
mode since phpMyAdmin 2.2.1), you need to supply the details of a MySQL
account that has SELECT privilege on the mysql.user (all columns except
"Password"), mysql.db (all columns) and mysql.tables_priv (all columns
except "Grantor" and "Timestamp") tables. This account is used to check
what databases the user will see at login.
Please see the install section on "Using authentication modes" for more
information.
Thank you so much! =)
ReplyDeleteIf you're using EasyPHP WAMP, the mentioned file is located in:
ReplyDelete\EasyPHP-12.1\modules\phpmyadmin123456789
Thank you!!
ReplyDeletewhat is the name file ? we need to edit in \EasyPHP-12.1\modules\phpmyadmin123456789
ReplyDeleteFile name is config.inc.php, located inside phpmyadmin folder
Deletein my easy php version, it is located in \EasyPHP-5.3.9\modules\phpmyadmin349x120325015958
Very helpful, thank you
ReplyDeleteThank you, awesome! it helped me out a lot!
ReplyDeletethanks, helps to me!
ReplyDeleteJust had this issue with Mediawiki. In my case, the default value for both of those fields was $dbuser and $dbpass (or something along those lines), which I did change to 'root' and 'mypasswordhere' respectively.
ReplyDeleteIt worked for me as well, thank you very much for sharing.
ReplyDeleteHello Thanks, It worked for me :
ReplyDelete$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = '';
Because in EasyPHP-DevServer-13.1VC9, root has no password.
thank you
Thank's for sharing information
ReplyDeleteThank you so much, very helpful!!!
ReplyDelete