Transferring from phpbb to SMF

[geo32101]

I keep getting this error-

Sorry, 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?

[geo32101]

Please help me!

[karlbenson]

are you sure that the database where the phpbb forum is correct?
are the username/password correct
does your phpbb forum use a prefix?

[geo32101]

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.

[babjusi]

@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.

[geo32101]

@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?

[babjusi]

@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

Koodi [Valitse] Laajenna

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

[KGIII]

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.)