How to change table prefixes in phpMyAdmin?

Question

So I have a host which provides me with phpMyAdmin. I run phpBB and would like to change some of the table prefixes.

How can I do this without phpMyAdmin?

I messaged my host and they said I couldn't do it in there. Is there a sql client I can do it with and, if so, how?

Solution

You can do this with phpMyAdmin.

Go to Structure page of the database that contains these tables.
Check the checkboxes in front of each of the tables you want to rename. From With selected dropdown chose Replace table prefix.
Enter current prefix in From field and new prefix in To field and press submit.