SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Nov 2007
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    PHPmyadmin Problems

    Hi

    I have installed MySQL and PHP and I am now trying to install PHPMyadmin 2.11.4 on Windows 2003.

    When I browse to phpmyadmin/index.php

    I receive the following error

    Error
    #2005 - Unknown MySQL server host 'http' (11004)

    Any ideas on how to get around this ? I have created the config.inc.php file

  2. #2
    SitePoint Wizard angilina's Avatar
    Join Date
    Jan 2008
    Posts
    1,011
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have yo set these to correct values in config.inc.php file?

    $cfg['Servers'][$i]['host']
    $cfg['Servers'][$i]['password']
    $cfg['Servers'][$i]['user']

  3. #3
    SitePoint Member
    Join Date
    Nov 2007
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    In the config.inc.php file I have set the host, username and password

    /* Authentication type */
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    /* Server parameters */
    $cfg['Servers'][$i]['host'] = 'localhost';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['compress'] = false;
    /* Select mysqli if your server has it */
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    /* User for advanced features */
    // $cfg['Servers'][$i]['controluser'] = 'pma';
    // $cfg['Servers'][$i]['controlpass'] = 'password';

    as you suggested and I now get

    Error
    #1045 - Access denied for user 'pma'@'localhost' (using password: YES)

    when trying to log in using 'pma' for the username field and 'password' for the password field as I set in the config.inc.php file above.

    Or does this have to match the root account set up in the mysql database? which I have also tried but with no success

  4. #4
    SitePoint Wizard angilina's Avatar
    Join Date
    Jan 2008
    Posts
    1,011
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by idv View Post
    In the config.inc.php file I have set the host, username and password

    /* Authentication type */
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    /* Server parameters */
    $cfg['Servers'][$i]['host'] = 'localhost';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['compress'] = false;
    /* Select mysqli if your server has it */
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    /* User for advanced features */
    // $cfg['Servers'][$i]['controluser'] = 'pma';
    // $cfg['Servers'][$i]['controlpass'] = 'password';

    as you suggested and I now get

    Error
    #1045 - Access denied for user 'pma'@'localhost' (using password: YES)

    when trying to log in using 'pma' for the username field and 'password' for the password field as I set in the config.inc.php file above.

    Or does this have to match the root account set up in the mysql database? which I have also tried but with no success
    Yes, you need to enter the user and password that you have set for MYSQL.

    in user field set it to "root"

    and enter the root password in password field.

    if this does not work, it will mean that ur root password is not correct,

    to change password, run MYSQL setup again, in setup, u will see a option to set root password


Bookmarks

Posting Permissions

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