To change a table name in MySQL you can use the ALTER TABLE command with the parameter RENAME TO. Here is an example of a query that will rename the table "atable" to "newtable".
ALTER TABLE atable RENAME TO newtable;
You could also use the RENAME TABLE command with the same effect.
RENAME TABLE atable TO newtable;
This is also useful for renaming all of the tables in the database, just separate each table rename command with a comma.
RENAME TABLE atable TO newtable, anothertable TO anothername;
This should enable you to rename all tables in the database, perhaps with a new prefix.