MyBB Community Forums

Full Version: database not recognized by mybb
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I am getting this error when i try to insert the database i created
http://imgur.com/a/3fv5E

and here the commands given to create the database within mysql
mysql> CREATE DATABASE IF NOT EXISTS `mybb`;
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> CREATE DATABASE IF NOT EXISTS `mybb2`;
Query OK, 1 row affected (0.00 sec)

mysql> CREATE USER 'mybbuser'@'localhost' IDENTIFIED BY 'bbpass';
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT USAGE ON * . * TO 'mybbuser'@'localhost' IDENTIFIED BY 'bbpass' WITH MAX_QUERIES_PER_HOUR 0 
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT USAGE ON * . * TO 'mybbuser'@'localhost' IDENTIFIED BY 'bbpass' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON `mybb` . * TO 'mybbuser'@'localhost';
Query OK, 0 rows affected (0.00 sec)

oh im stupid. I copied over the commands which had a the database name as mybb, but i have two mybb forums and one is already using that so i had to rename it...just a typo..
delete the whole database and recreate it
this should help