Hi,
I login to my members area and go to Manage database. I then select the ManageDB dropdown. Sometimes this takes me to a phpmyadmin page and sometimes to the phpmyadmin login. Unfortunately I have forgotten the phpmyadmin login.
When I do manage to get to the phpmyadmin page I have attempted to import the DB from a backup. The first time it failed saying tables already exist. So I deleted the DB recreated it and tried again. Now I get the following error:
Error
SQL query:
CREATE TABLE mybb_adminlog
(
uid
int(10) unsigned NOT NULL DEFAULT ‘0’,
ipaddress
varbinary(16) NOT NULL DEFAULT ‘’,
dateline
int(10) unsigned NOT NULL DEFAULT ‘0’,
module
varchar(50) NOT NULL DEFAULT ‘’,
action
varchar(50) NOT NULL DEFAULT ‘’,
data
text NOT NULL,
KEY module
(module
,action
),
KEY uid
(uid
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
MySQL said:
#1044 - Access denied for user ‘id848145_mybbadmin’@’%’ to database 'information_schema’
Can you please assist?
Many thanks