+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: How do I Change the Default Table Prefix? (/thread-207408.html)
How do I Change the Default Table Prefix? - Bigredclaygeorgia - 2017-01-14
I am confused I looked here below:
“Changing your table prefix can prove to be helpful in certain cases. If a hacker manages to run an SQL query, he can easily destroy your forum completely. But if they don’t know what your table prefix is (and therefore don’t have a table name to query) it would slow them down.”
Still confused. How would I do this via cpannel?
thx
RE: How do I Change the Default Table Prefix? - ConnerKid - 2017-01-14
It's during the initial Mybb installation when it sets up the tables. You choose a table prefix. I think the default is mybb_. However this isn't a real security measure and I wouldn't worry to much about it. Changing the prefix to something obscure wouldn't stop an attacker from accessing the information schema
RE: How do I Change the Default Table Prefix? - Bigredclaygeorgia - 2017-01-14
(2017-01-14, 06:58 AM)ConnerKid Wrote: It's during the initial Mybb installation when it sets up the tables. You choose a table prefix. I think the default is mybb_. However this isn't a real security measure and I wouldn't worry to much about it. Changing the prefix to something obscure wouldn't stop an attacker from accessing the information schema
is there still a way to change because i bought webhosting that had mybb already included with softaculus so i was not able to make the change beforehand.
would there be a way to do it now?
thx.
RE: How do I Change the Default Table Prefix? - .m. - 2017-01-14
^ yes, table prefix can be changed through database manager - eg. phpMyAdmin (see search results)
put forum offline before changing the prefix and then prefix should be also changed in config.php file
$config['database']['table_prefix'] = 'mybb_';RE: How do I Change the Default Table Prefix? - Matt - 2017-01-14
Is worth noting the primary use of the table prefix is to allow you to install multiple PHP applications into one database while avoiding table name collisions - it's not really a security feature.