You can’t rename a database directly. It’s a four-step process.
- mysql -u username -p -e “CREATE DATABASE new_dbname“
- mysqldump -u username -p old_dbname > dbexport.sql
- mysql -u username -p new_dbname < dbexport.sql
- mysql -u username -p -e “DROP DATABASE old_dbname“
Reference: MySQL Rename Table & Database Guide