MyBB Community Forums

Full Version: Fixed!
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2 3
Oh wait, I see you are using localhost.

You should go to localhost/phpmyadmin (or wherever phpmyadmin is located on your WAMP server) and create a database there.

Your db details should be:
Host: localhost
Database User: root
Password: Leave Empty
Database: yourdatabasenamehere
SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci' at line 9
Query:
CREATE TABLE mybb_adminlog ( uid int unsigned NOT NULL default '0', ipaddress varchar(50) NOT NULL default '', dateline bigint(30) NOT NULL default '0', module varchar(50) NOT NULL default '', action varchar(50) NOT NULL default '', data text NOT NULL, KEY module (module, action) ) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
You are using MySQL 5.5, which the current MyBB version doesn't support. You need to get a localhost server install that uses an older version (until 1.6.2 is released which fixes the compatibility bug)
You can check this thread for more information and possible solution
http://community.mybb.com/thread-85251.html
I downgraded mySQL to 5.1, but now I get this error.

Quote:Error

MySQL said Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
root can't access the database but it's very strange that the root MySQL user can't access your databases.
(2011-01-11, 08:19 PM)The Gamer Union Wrote: [ -> ]I downgraded mySQL to 5.1, but now I get this error.

Quote:Error

MySQL said Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

I assume this is when you try to use phpmyadmin??

It is possible that its getting denied for security because you don't have a password set, setup a password for root first.
I set up a password in mySQL, is that what you mean?
And yes, I mean phpmyadmin.
How do I set it up and how do I access it?
Make sure the password is correct in the phpmyadmin config
How do I get there?
Pages: 1 2 3