[Solved] Phpmyadmin Import Problem

[mgnmhrt]

Hello, I've been trying to import a mysql database (.sql) from my local wamp server via heliohost's phpMyAdmin (http://stevie.heliohost.org:2082/3rdparty/phpMyAdmin/index.php)

But it returned an error 1146: table doesn't exist, and it causes phpMyAdmin display these in plain text after reloading the page:

Error

SQL query: Edit

SET CHARACTER SET 'utf8';

MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

 

I tried to recreate the database by deleting and creating another one but this happened twice.

Now, on my 3rd attempt, the error message in the phpMyAdmin is still there.

 

Hope you can help. Thanks in advance.

[mgnmhrt]

please help me with this, anyone? i can't use phpmyadmin properly.

 

ok, i tried to use incognito in my browser and managed to logged in on a newly created mysql account and database. how would i properly import a sql file that would not return the error message in OP?

[mgnmhrt]

UPDATE: ok, i realized that stevie server has some issues with InnoDB tables. so i converted all of my tables to MyISAM and now it's working fine.

[wolstech]

Not sure why your topic got skipped over...yeah Stevie does not support innodb. Strange errors like this result when you try to use innodb on Stevie. Glad you figured it out though