Setting up phpBB board using Apache Server {RESOLVED}

Interesting timing. I just fixed this problem on a new installation on my workstation here not more than a half hour ago.

You need to set mySQL to use Old_Passwords. This describes how and why:

http://webyog.com/faq/23_58_en.html

Official documentation here:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

If you are using root as the user, you will need to reset the password to OLD_PASSWORD using the command line tool that comes with MySQL. Same goes for any user you have already created.

Yeah - the links explain it pretty well. I'm making the assumption you know how to use the command line utility that comes with MySQL. If you don't let us know. I've had to do this with every installation I've done so far, so I have it in my install notes now to remember to do it.

It's pretty much like a dos prompt. If you are on Windows, you'll find it under start|programs|MySQL |MySQL Command Line Client

When it opens, type in the password for user: root (If you didn't create a password for root the default is blank) then hit enter

At the prompt type the SQL query

SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

You'll need to do this for any user you have already created.

(Making the substitutions for some_user, some_host, and newpwd - be sure to type it exactly as you see it including caps and apostophes.

Type exit or quit to exit the editor

You need to give your username the appropriate rights to the database you wish to connect to.

It looks like you're using "localhost" as the username?

I believe AXE has it exactly correct. SB, if you haven't already done so, download and install this administration utility. It will make your life easier
http://www.mysql.com/products/tools/administrator/

btw SB:



You most likely don't have a user named localhost.

I'm thinking in your config.php you have 'localhost' as your user, when it most likely is 'root'

If that's the case, I would recommend creating a new user other than root and give them access permissions to the database. That Admin utility will help you do that easily.

Using root to access a database via phpBB is a security risk.

Yup, go ahead and setup phpMyAdmin with the "root" account, and .htaccess protect its location so that it's not accesible via the net.

Once you've got phpMyAdmin setup (if you don't already), you can create new databases, new users (with password), and setup the appropriate access rights through that.

Basically, each user you create, you have to tell MySQL exactly which databases it has access to, and what level of access (add data, remove data, read-only access, etc) they're allowed to those databases.

This is basically due to the fact that it's designed for a multi-user environment, and on shared hosting, you don't want somebody else's username accessing your databases and playing with your data.

If your server is disconnected from the net, then you can safely use the "root" login for your scripts, as nobody else will be able to hit your server anyways.

P.S. SB -- I like you're new rank *lol
(*watches SB as he goes to run and hide under his bed *lol)