O My Gosh!! You are so my hero!!!
I made these changes and the problem was fixed. I was getting so frustrated for hours trying to figure this out!
TT Edit privileges
Privilege name Current status is set as on for all
x grant
x drop
x update
x create
x alter
x index
x select
x insert
x delete
Host is Hostexcellence.com [Linux]server.. not sure about panel.. I know it is not cpanel (wish it was)
I have changed the following
// You can have multiple installations in one database if you give each a unique prefix
$table_prefix = ‘wp2_’;
Thank you..
If anyone is hosting with Host Excellence I hope that they read this and it will help them out so much.
Charity