Hi,<br /><br />I'm trying to install the new RC3 version of phpBB3-Olympus so I can upgrade existing board. I had installed an RC1 test board sucessfully a couple months ago but can't seem to get the SQL database/user info correct now that I'm trying to install to go live. These are the settings I'm trying to use - can anyone help me out?<br /><br /><br />Database Type: MySQL<br />Database server hostname or DSN: have tried localhost and blank<br />Database server port: (blank)<br />Database name: <i>tchusername_databasename</i> (current database name is phpbb1)<br />Database username: <i>tchusername_databaseusername</i><br />Database password: Tried both <i>tchuserpassword</i> here and blank<br />Prefix for tables in database: phpbb3_<br /><br />I have 2 SQL users set up and can't remember which is attached to the database, but I tried both with and without password and I keep getting:<br /><br />Access denied for user '<i>user</i>_phpbb1'@'localhost'<br /><br />or<br /><br />Access denied for user '<i>user</i>_<i>user</i>'@'localhost'<br /><br /><br />Would appreciate any help given!<br /><br />Peace,<br /><br />Caryn<br /><br /><!--content-->
To connect to the database in a script use:<br /><br />host: localhost<br />database: <b>yourCpanelName_databaseName</b><br />user: <b>yourCpanelName_databaseUser</b><br />password: <b>myDataBasePassword</b><br /><br />* Note password is just as the password, <br />do not add the CpanelName to it.<br /><br />---------------------------<br /><br />If the database already exist and you do not know the database user and database password for that user<br />then create a new user and password<br /><br />Be sure that in MySql you <br /><br /> - created a user with password<br /> -added the user to the database (go back to MySql and find the Add user<br />select the user and database, and then <b>Add user to database</b>)<br /><!--content-->
<!--quoteo(post=209657:date=Jul 21 2007, 05:11 PM:name=TCH-Don)--><div class='quotetop'>QUOTE(TCH-Don @ Jul 21 2007, 05:11 PM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=209657"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->If the database already exist and you do not know the database user and database password for that user<br />then create a new user and password<br /><br />Be sure that in MySql you <br /><br /> - created a user with password<br /> -added the user to the database (go back to MySql and find the Add user<br />select the user and database, and then <b>Add user to database</b>)<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br /><br />Hi Don - thanks for the quick response!<br /><br />Database is already there for existing 2.0.x board. I figured out the correct dbuser but don't remember password. Is there any way to just change the password? Would it cause problems with my existing board if I delete the dbuser and recreate it with same name but new password?<br /><br />- C<!--content-->
The password and user should be in a config file in the old PhpBB folder. I'm not sure what they name the file but generally it is config.php or some such file. It could also be in the includes folder. [From running a Google search it does look like the file is config.php. You can use the File Manager in cPanel to view the file and get the password.]<!--content-->
<!--quoteo(post=209659:date=Jul 21 2007, 05:29 PM:name=GvilleRick)--><div class='quotetop'>QUOTE(GvilleRick @ Jul 21 2007, 05:29 PM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=209659"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->The password and user should be in a config file in the old PhpBB folder. I'm not sure what they name the file but generally it is config.php or some such file. It could also be in the includes folder.<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />Thanks a lot - that did the trick!<!--content-->
To connect to the database in a script use:<br /><br />host: localhost<br />database: <b>yourCpanelName_databaseName</b><br />user: <b>yourCpanelName_databaseUser</b><br />password: <b>myDataBasePassword</b><br /><br />* Note password is just as the password, <br />do not add the CpanelName to it.<br /><br />---------------------------<br /><br />If the database already exist and you do not know the database user and database password for that user<br />then create a new user and password<br /><br />Be sure that in MySql you <br /><br /> - created a user with password<br /> -added the user to the database (go back to MySql and find the Add user<br />select the user and database, and then <b>Add user to database</b>)<br /><!--content-->
<!--quoteo(post=209657:date=Jul 21 2007, 05:11 PM:name=TCH-Don)--><div class='quotetop'>QUOTE(TCH-Don @ Jul 21 2007, 05:11 PM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=209657"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->If the database already exist and you do not know the database user and database password for that user<br />then create a new user and password<br /><br />Be sure that in MySql you <br /><br /> - created a user with password<br /> -added the user to the database (go back to MySql and find the Add user<br />select the user and database, and then <b>Add user to database</b>)<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br /><br />Hi Don - thanks for the quick response!<br /><br />Database is already there for existing 2.0.x board. I figured out the correct dbuser but don't remember password. Is there any way to just change the password? Would it cause problems with my existing board if I delete the dbuser and recreate it with same name but new password?<br /><br />- C<!--content-->
The password and user should be in a config file in the old PhpBB folder. I'm not sure what they name the file but generally it is config.php or some such file. It could also be in the includes folder. [From running a Google search it does look like the file is config.php. You can use the File Manager in cPanel to view the file and get the password.]<!--content-->
<!--quoteo(post=209659:date=Jul 21 2007, 05:29 PM:name=GvilleRick)--><div class='quotetop'>QUOTE(GvilleRick @ Jul 21 2007, 05:29 PM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=209659"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->The password and user should be in a config file in the old PhpBB folder. I'm not sure what they name the file but generally it is config.php or some such file. It could also be in the includes folder.<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />Thanks a lot - that did the trick!<!--content-->