Cannonfodder Posted October 14, 2002 Report Share Posted October 14, 2002 I've run into a roadblock installing phpbb on my machine. I'm running Mandrake 9 and have webmin, apache, mysql v3, php installed. While I know linux a bit, I'm a newbie when it comes to messing with servers. 1. I downlaoded PHPBB and installed it into /var/www/html/phpbb. 2. I created a database mub with mysql and granted my user mryan all access rights to *.*. 3. I go to https://localhost/phpbb/install.php (note the https) and fill out the form, clicking Install 4. I get the following message... phpBB : Critical Error Could not connect to the database The values I used to fill out the form are: Default board language: EnglishDatabase Type: MySql 3.x Choose your installation method: Install Database Server Hostname / DSN: localhost Your Database Name: mub Database Username: mryan Database Password: password Prefix for tables in database: phpbb_ Admin Email Address: highnoon@rochester.rr.com Domain Name: spookhouse.com Server Port: 443 Script path: /phpbb/ Administrator Username: cannonfodder Administrator Password: password Administrator Password [ Confirm ]: password Any clues? Want to get going on learning PHP, but need it working first.. Quote Link to comment Share on other sites More sharing options...
bradcarter Posted October 14, 2002 Report Share Posted October 14, 2002 out of curiosity try running this: (save as whatever.php) <?php $link = mysql_connect('localhost','mryan','password') OR die(mysql_error()); $mysql_select_db('mub',$link) OR die(mysql_error()); ?> I dont know how descriptice phpBB errors are, that should tell you more if your user can actually connect, or if it is the db not being selected Quote Link to comment Share on other sites More sharing options...
Cannonfodder Posted October 14, 2002 Author Report Share Posted October 14, 2002 While logged in as root, I tried this.. and got the following: Warning: Access denied for user: 'mryan@localhost' (Using password: YES) in /var/www/html/phpbb/whatever.php on line 2 Warning: MySQL Connection Failed: Access denied for user: 'mryan@localhost' (Using password: YES) in /var/www/html/phpbb/whatever.php on line 2 Access denied for user: 'mryan@localhost' (Using password: YES) I just tried adding mryan to groups apache and mysql, but get the same result.. Last of all, I tried messing around with the grant all command but still no change.. Quote Link to comment Share on other sites More sharing options...
bradcarter Posted October 14, 2002 Report Share Posted October 14, 2002 I dont think it matters what you are logged in when you run the script as the script probably runs as nobody when accessed through the browser. Instead of using grant and grant all, you can also try inserting it with mySQL insert syntax. which you can find examples of here: http://www.mysql.com/doc/en/Adding_users.html I should add the users for mysql are separate from the regular users so it should not matter what group etc it belongs, you actually do not have to create the user in that way. All this user is a user for mysql that is it. Should also probably add I have only added users in this way twice so I am not super experianced in it, I normally do it online with things like C-Panel Quote Link to comment Share on other sites More sharing options...
Cannonfodder Posted October 14, 2002 Author Report Share Posted October 14, 2002 That did it! :P I pulled up the mysql user database with webmin and took a peek. I had a few records there for mryan. I deleted these and then went into mysql and did a full grant using the sample from the web page you gave me. This time my install worked. Thank you very much, big help! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.