如何修改mysql的数据库名

CREATE DATABASE new_database_name;

mysqldump -u username -p old_database_name > old_database_name.sql

mysql -u username -p new_database_name < old_database_name.sql

USE new_database_name;
SHOW TABLES;
SELECT * FROM table_name;

DROP DATABASE old_database_name;

# 创建新数据库
mysql -u username -p -e "CREATE DATABASE new_database_name;"

# 备份原数据库
mysqldump -u username -p old_database_name > old_database_name.sql

# 导入备份到新数据库
mysql -u username -p new_database_name < old_database_name.sql

# 验证数据迁移
mysql -u username -p -e "USE new_database_name; SHOW TABLES; SELECT * FROM table_name;"

# 删除原数据库（可选）
mysql -u username -p -e "DROP DATABASE old_database_name;"