Simple Machines Community Forum

SMF Support => Converting to SMF => MyBB => Topic started by: ProShooter. on March 23, 2017, 02:36:28 AM

Title: How to fix :/?
Post by: ProShooter. on March 23, 2017, 02:36:28 AM
How to fix this
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.6. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: SELECT command denied to user 'id1155286_havoc'@'2a02:4780:bad:c0de::13' for table 'mybb_users'
Title: Re: How to fix :/?
Post by: Linkjay on March 23, 2017, 04:33:48 AM
Your MySQL info that you provided is either incorrect or the permissions are not properly setup for that user.

From the looks of it, the user entered does not have the "SELECT" ability/permission.
Title: Re: How to fix :/?
Post by: Illori on March 23, 2017, 05:01:57 AM
http://wiki.simplemachines.org/smf/Converting#Database_Access
Title: Re: How to fix :/?
Post by: bdubzer on September 19, 2017, 08:04:19 PM
 This question was asked a while ago buuut....since there aren't any really answers to solve it..or a good explanation..

I ran into the same issue, only my error reason didn't show up or I would have figured it out sooner. If you go to your websites control panel where you can access your MySQL database and MySQL users in there you can set the permissions for the user.

Now, if you're like me you have no idea how to do that yeah? If you look in the settings.php of the smf you installed or through your website control panel it will tell you what the MySQL user name is. It is also pretty obvious in your MySQL user list since it will have something_smf. I had to add the SMF MySQL user to MyBB's database and give it all access.

However, the password I created through my website's control panel for that MySQL user didn't work, the password from the settings.php (db_password = whatever it says.) Did work.

I was searching high and low trying to figure this out until it dawned on me what it was. Not everyone knows about these things, and I noticed in a lot of the threads people give very brief answers assuming the person knows what you're talking about. Some of us are learning as we go, so a bit more descriptiveness would be more helpful. I hope this helps someone else who runs into the issue and has no idea what they were supposed to do. :D