Web Development, Windows

EasyPHP – Import DB error

3 Comments

If you meet the following error when importing DB thru the EasyPHP phpMyAdmin.

  • #1100 – Table ‘pma_column_info’ was not locked with LOCK TABLES

Open the phpMyAdmin configuration file config.inc.php and the uncomment the following 2 lines.

$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'password';

 

Done =)

Reference: error while importing DB in mysql

Advertisement

3 thoughts on “EasyPHP – Import DB error”

  1. Pingback: WAMP Stacks | Eureka!

  2. This is what worked for me:

    $cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = '';

    I had to leave erase ‘password’ on the second line

    Like

    Reply

    1. i guess becoz your dun have a root password so you need to set an empty string there. anyway, good to know that it is working and thx for your comment. =)

      Like

      Reply

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.