title: How do I rename a MySQL schema?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/490515/how-does-one-rename-a-schema-in-mysql">how does one rename a schema in MySQL</a>  </p>
  </blockquote>
  
  
  
  <p>Is there a MySQL statement for renaming a schema? I know about <code>RENAME {DATABASE | SCHEMA} db_name TO new_db_name;</code>, but that statement "was found to be dangerous and was removed in MySQL 5.1.23" (as they mention in <a href="http://dev.mysql.com/doc/refman/5.1/en/rename-database.html" rel="noreferrer">here</a>).</p>
  
  <p>I was also trying to do it using MySQL Workbench. I tried right clicking on the schema, and then alter schema. But they don't let you change its name in there.</p>
  
  <p>So how do people rename databases?</p>