Hey, long story short, I swapped database names over to get the old database back and not the new one, everytime I try to access my forums I get, "Access denied for user 'southcen_phpb577'@'localhost' (using password: YES) [1045]", This happens to anyone trying to access it.
"southcen_phpb577" is the database name.
Not sure why it says localhost, and not sure why it's saying it's using a password, any ideas?
Ok, apologises, I'm new to PHPBB, I've went of what I know from another program of scripting that uses mysql and deleted the dbname dbhost etc, now I'm getting;
"Access denied for user ''@'localhost' (using password: NO) [1045]"
These forums are public so people can get on them, I'm not sure why it's saying localhost when they're public and not just for local usage, unless I'm thinking the wrong way of that.
Localhost is typically the name that hosting companies give to their own servers (but not always - you should check with the hosts).
Deleting the information from the config.php file was not the right thing to do.
That file 'connects' your phpBB files to the database where all of the users and posts are. The information in that file must be exactly right for the connection to be made. Also the username that you are telling it has access to that database must have permission to access it on your hosting account.
So either, as David said, the information was wrong, or the info was right but the account did not have the right permission on the hosting package.
When it is all correct, the forum will show up.
-:|:- Support Request Template -:|:- "Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
All right, so I think I've got this right, what do I put for the password? Just leave it blank and closed like '' or with a space? ' ' cause each time I just get using password: NO
it is not referring to your localhost as in your computer. it is referring to the hosting company server. most all hosting companies use that. the few that don't will require you to actually input the database IP or server name in to that spot in your config.php file.
everything you put in that config file has to be exactly right. you can't guess or assume.
check the email that you got when you signed up for the hosting account. there is usually the settings you need to use to setup those things.
or, just go to the control panel of your hosting account or the support site for them and it will tell you what to use if localhost is not correct for their servers.
once you get that part correct, you have to put the database name for the database your phpbb is using, the database username and password have to be correct for that specific database.
everything on the internet is case sensitive ( except windows/microsoft stuff but we won't go there ) so make sure it is all correct that way.
when you created the database in question, make sure you applied the database username to that database. if your control panel at the host is cpanel, that is in the database setup section right after you create the database.
make sure you gave that database user all permissions. that is also part of the setup wizard.
Yes, everything was correct, but I've decided to restart fresh so I know what I'm doing, during the installation of phpBB, I set the Table Prefix to the old database's one, with the database name and now I'm getting this error on accessing the forums
Well, it was far more complex for me as a newbie to phpBB to describe the issues I was having, knowing how to do this and that, what next, and so forth. It was time wasting for me and others and so I felt just re-doing it all was the better option, and I went and fixed "this" problem but on came another problem, and then another, and so I was at the peak of losing motivation.