Results 1 to 5 of 5
  1. #1

    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: [email protected]' (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

  2. #2
    Join Date
    Oct 2001
    Location
    Ohio
    Posts
    8,299
    [WinMySQLAdmin]
    Server=C:/WEB/MYSQL/bin/mysqld-opt.exe
    user=root
    password=******
    That's your username and password.

  3. #3
    That's what I'm using for phpBB.

    -T

  4. #4
    Join Date
    Oct 2001
    Location
    Ohio
    Posts
    8,299
    Are you able or have you tried to create the database through MySQL Admin?

  5. #5
    No there is no option for creating a database. The ones I created in phpmyadmin do show up, but I can't do anything with them.

    -T

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •