Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved How do I Change the Default Table Prefix?
#1
Not Solved
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
Reply
#2
Not Solved
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
Reply
#3
Not Solved
(01-14-2017, 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.
Reply
#4
Not Solved
^ 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_';
Reply
#5
Not Solved
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.
MyReactions - All Plugins

Can you still feel the butterflies?

Free never tasted like pudding.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)