Can I use ALTER DATABASE to rename a mysql database?

Question

I am using PDO with PHP to create a new database and then a new user with privileges on that database. In case one of them fails, I want to rename the database and user so that they can be deleted later and the names are available.

Is it possible to rename a mysql database using the ALTER DATABASE?

Answer 1

Duplicate -- see How do I quickly rename a mysql database (change schema name)

In short, no. MySQL doesn't have a quick/simple way to rename databases. You have to use mysqladmin and mysqldump from the command line. See question above for all the details.