Advertisement:

Author Topic: How to fix :/?  (Read 2886 times)

Offline ProShooter.

  • Newbie
  • *
  • Posts: 2
How to fix :/?
« on: March 23, 2017, 02:36:28 AM »
How to fix this
Code: [Select]
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'

Offline Linkjay

  • Jr. Member
  • **
  • Posts: 206
  • Gender: Male
  • eh
    • My Homepage.
Re: How to fix :/?
« Reply #1 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.
I play games in my free time and volunteer my knowledge and support to the gaming communities of the internet.

You can contact me by these methods:
Use my Contact Script • PM me here • Add me on Steam

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,072

Offline bdubzer

  • Newbie
  • *
  • Posts: 1
Re: How to fix :/?
« Reply #3 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