PHPMyAdmin passwords

Discussion in 'Server Operation' started by happyhacker, Apr 9, 2009.

  1. happyhacker

    happyhacker New Member

    I have just installed and accessed phpmyadmin OK. But I need to configure the password and the tutorials I've tried to find do not seem to work! The default password is admin and NO pwd. The config file is shown at the end below. I would like to configure a new username and password but not sure how.

    Can any one assist?

    /**
    * Server(s) configuration
    */
    $i = 0;
    // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
    // You can disable a server config entry by setting host to ''.
    $i++;

    /* 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'] = 'mysql';
    /* Optional: User for advanced features */
    // $cfg['Servers'][$i]['controluser'] = 'pma';
    // $cfg['Servers'][$i]['controlpass'] = 'pmapass';
    /* Optional: Advanced phpMyAdmin features */
    // $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
    // $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
    // $cfg['Servers'][$i]['relation'] = 'pma_relation';
    // $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
    // $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
    // $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
    // $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
    // $cfg['Servers'][$i]['history'] = 'pma_history';
    // $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
    /* * End of servers configuration*/
    /* * Directories for saving/loading files from server*/
    $cfg['UploadDir'] = '';
    $cfg['SaveDir'] = '';
     
  2. falko

    falko Super Moderator Howtoforge Staff

    You can log in with all username/password combinations that are defined in the mysql.users table.
     

Share This Page