mysql> DROP DATABASE IF EXISTS 'Example';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Example'' at line 1
mysql>
Have I done something wrong / got the wrong end of the stick?
Wouldn't all the things you've used SET for be reset back to the default config on a restart? I know that "SET NAMES" and "SET CHARACTERSET" are both per connection. I imagine most things would be.
onion2k wrote:Wouldn't all the things you've used SET for be reset back to the default config on a restart? I know that "SET NAMES" and "SET CHARACTERSET" are both per connection. I imagine most things would be.
This is correct. You need to edit the mysql config file before restarting.