mySQL database problems

Hi I'm trying to setup my website on my home computer. I have Apache, MySQL, php and phpmyadmin installed. The site is working fine, but I'm having trouble setting up a database for my phpBB board.

I've tried hundreds of configurations, searching dozens of sites. Documentation seems pretty vague. I'm prety close right, now so I'll just say what I'm currently at.

I can access phpmyadmin create a database, however they don't show up on the left side. Also I need the username and password to install for the database. Is this the same password I use for phpmyadmin?

Here is the phpmyadmin settings:

$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = FALSE;
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '******';
$cfg['Servers'][$i]['only_db'] = 'root';

My mySQL my.ini:

[WinMySQLAdmin]
Server=C:/WEB/MYSQL/bin/mysqld-opt.exe
user=root
password=******

[mysqld]
basedir=C:/WEB/MYSQL
#bind-address=24.245.24.244
datadir=C:/WEB/MYSQL/data
#language=C:/WEB/MYSQL/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M

This is the error I get when trying to install phpBB using the username and password I used for phpmyadmin:


Warning: mysql_connect(): Access denied for user: 'host@localhost' (Using password: YES) in c:\web\www\phpbb\db\mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in c:\web\www\phpbb\db\mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in c:\web\www\phpbb\db\mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

What am I doing wrong?

thanks,
-T

 

 

 

 

Top