MySQL database woes

y2kwizard · Post by **y2kwizard** » Tue May 13, 2003 7:03 pm

Hello, all. Does anyone here know much about the MySQL database? I'm having a pretty awful problem setting up a phpbb2 forum using MySQL.

I've set up a forum using phpbb2 and MySQL before, and it shouldn't be very difficult to do. Yet I"m having trouble.

I've already installed Apache and PHP, and both work fine. I installed MySQL 4.0.12 just recently, and it seems to work fine.

When I go to the install.php file, I set up all the normal parameters...I say the database is version 4 SQL, I enter localhost as the Host Name, I provide teh username/pw for my database...all the run-of-the-mill stuff.

But I get an awful error message when I click send. I get the following message:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'y2kwizard@127.0.0.1' (Using password: YES) in C:\FTPRoot\WWW.RANDOMCREW.INFO\phpbb2\db\mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:\FTPRoot\WWW.RANDOMCREW.INFO\phpbb2\db\mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:\FTPRoot\WWW.RANDOMCREW.INFO\phpbb2\db\mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

It looks as if it's not CONNECTING to the database....how can this be if I see the .exe running in my Task Manager??

ANY ideas why I'm not getting any good results at all? Thanks a lot!

Org Profile · Post by **Phade** » Tue May 13, 2003 8:47 pm

Hey,

Did you enter the username and password correctly in your script? Did you reload MySQL after you entered the user information? Are you able to connect as that user from the command line?

If you pass all those, there is something massively wrong.

Phade.

y2kwizard · Post by **y2kwizard** » Tue May 13, 2003 8:59 pm

I'll look into all those, Phade.

I do know for sure that i did enter the username/pw correctly.

I also know that, when I open the MySQL Control Center application, the app won't gain any access to the MYSQL database.

The weird thing is that this worked a while ago. I'd just reinstalled MySQL to try to solve a perceived problem, and everything went to heck.

oh...and about reloading MySQL...do you mean that I should uninstall/reinstall, or am I missing something entirely? I've tried uninstalling and reinstalling, but using the Add/Remove programs function of Control Panel doesn't seem to entirely uninstall MySQL, for when I REinstall it, it doesn't give me an option to set another username and password...it simply uses the username and password that I entered the very first time I installed MySQL.

I nkow that I'm missing something...I just don't know what...

Org Profile · Post by **Phade** » Tue May 13, 2003 9:33 pm

Hey,

"Reload" refers to the reloading of the authentication information. Instead of making constant queries to the users and permissions tables, MySQL loads them into RAM memory for fastest access. If a change is made to the users/permissions tables, the copy in member must be "reloaded" to recognize the new permissions. This may be changed in MySQL 4 (I haven't checked yet).

Phade.