EasyPHP – Import DB error

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

Advertisements

3 thoughts on “EasyPHP – Import DB error”

  1. 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

    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

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s