1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Error: "Can't create database 'databasename'; database exists"
This message is due to you not having permission to create a new database using PhpMyAdmin. The database must be created via the control panel.
If you have a CREATE DATABASE command present, even if the database already exists, it will be rejected. Therefore, if your SQL dump contains this line, it should be removed using e.g. a text/code editor.