I keep getting this error-
LainaaSorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.
The error MySQL gave was: SELECT command denied to user 'vpparad_smf1'@'localhost' for table 'phpbb_users'
How can I fix this?
Please help me!
are you sure that the database where the phpbb forum is correct?
are the username/password correct
does your phpbb forum use a prefix?
Lainaus käyttäjältä: karlbenson - lokakuu 14, 2007, 10:24:24 IP
are you sure that the database where the phpbb forum is correct?
are the username/password correct
does your phpbb forum use a prefix?
Im pretty sure its all correct,but I am no sure.
@geo32101, make sure SMF has access to the database of the phpbb forum or at least grant the smf mysql user full access and permissions to the phpbb forum's database.
Lainaus käyttäjältä: babjusi - lokakuu 14, 2007, 10:38:40 IP
@geo32101, make sure SMF has access to the database of the phpbb forum or at least grant the smf mysql user full access and permissions to the phpbb forum's database.
How?
Lainaus käyttäjältä: geo32101 - lokakuu 14, 2007, 10:40:07 IP
Lainaus käyttäjältä: babjusi - lokakuu 14, 2007, 10:38:40 IP
@geo32101, make sure SMF has access to the database of the phpbb forum or at least grant the smf mysql user full access and permissions to the phpbb forum's database.
How?
Install smf on the same database like phpbb forum. Or at the ''mysql databases'' area in the cp of your host you must have the option to grant the mysql users full access and permissions to the databases you have. Choose the smf mysql user and grant him full access and permissions to the phpbb forum's database.
If you don''t have such a option, then run the following query
GRANT ALL
ON ......... .*
TO........... ''%''
IDENTIFIED BY ''............'' ;You replace the .......... with the database name of your phpbb ofrum and the usename of the smf mysql user.
The * stands for that that user must have all access and permissions on all the tables of that database.
Whereas % replaces a list of all known hosts in the whole world.
Hope all this helped
Does your host have phpMyAdmin or cPanel? If so then add the user to that database with a permission set of "all" and call it good. (When you're done, for security sake, remove him from that permission set.)