If you do not have permission to create MySQL database through PHPMyAdmin and its show - No privileges.

​If you want to import or restore MySQL database backup using phpMyAdmin just follow the below steps,

phpMyAdmin is an open source tool for managing database servers like MySQL, MariaDB and Drizzle.

Sometimes you get an error "drop database statements are disabled" on PHPMyAdmin tool,

We have already discussed about how to take a database backup and restore in MySQL using mysqldump command, do you feel it's very difficult can get backup using the PHPMyAdmin tool.

Once lampp package installed in system and trying to open phpmyadmin on browser shows below error:

When i tried to import the MySql database backup file on phpmyadmin error was showing on import got a packet bigger than 'max_allowed_packet' bytes in phpmyadmin.