Results 1 to 4 of 4

Thread: phpmyadmin configuration problem

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2006
    Location
    Pakistan
    Posts
    262

    phpmyadmin configuration problem

    Hay to every one!!!

    i m working with WAMP, when we run it first time, phpmyadmin starts with NO PASSWORD, what i had done in my previouse practise? i just made changes in congfig.inc.php for the following variables to set the password:

    $cfg['Servers'][$i]['password'] = 'abc123';// it waz empty, i set its value.

    $cfg['SQLValidator']['username'] = 'root'; // it waz empty, i set its value

    $cfg['SQLValidator']['password'] = abc123; // it waz empty, i set its value

    these changes were working sucessfully, but now after making these changes i get following error:
    #1045 - Access denied for user 'root'@'localhost' (using password: YES)

    kindly some one do the favor and guide me that how can i set password, i ve also set password by phpmyadmin interface by applying MD5 function, but it also had no effect. i had also change these varible's values in phpmyadmin\...\libraries\config.defult.php, i had change the value of $cfg['Servers'][$i]['nopassword'] = FALSE; but

    so kindly tell me the solution except these ones.

    Best Regards,

    Sadia Tabasum

  2. #2

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2006
    Location
    Pakistan
    Posts
    262

    Re: phpmyadmin configuration problem

    i m using 5.0.45 version of the MySQL

  3. #3
    Addicted Member
    Join Date
    Feb 2006
    Location
    Hyderabad, India
    Posts
    233

    Re: phpmyadmin configuration problem

    Code:
    $cfg['SQLValidator']['password'] = abc123;
    shouldn't that be
    Code:
    $cfg['SQLValidator']['password'] = "abc123";

  4. #4
    Frenzied Member I_Love_My_Vans's Avatar
    Join Date
    Jan 2005
    Location
    In the PHP compiler
    Posts
    1,275

    Re: phpmyadmin configuration problem

    If you leave it without a username and password and enable cookies it will let you type your password in everytime you try to access phpMA, this may seems like a pain in the arse however it is the most secure method.

    HEre is my phpMA config.inc.php

    Code:
    <?php
    
    /* $Id: config.sample.inc.php 9689 2006-11-10 20:05:49Z nijel $ */
    // vim: expandtab sw=4 ts=4 sts=4:
    
    /**
     * phpMyAdmin sample configuration, you can use it as base for
     * manual configuration. For easier setup you can use scripts/setup.php
     *
     * All directives are explained in Documentation.html and on phpMyAdmin
     * wiki <http://wiki.cihar.com>.
     */
    
    /*
     * This is needed for cookie based authentication to encrypt password in
     * cookie
     */
    $cfg['blowfish_secret'] = 'yt42trwe1f4346513'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
    
    /*
     * Servers configuration
     */
    $i = 0;
    
    /*
     * First server
     */
    $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';
    /* User for advanced features */
    //$cfg['Servers'][$i]['controluser'] = '';
    //$cfg['Servers'][$i]['controlpass'] = '';
    /* 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'] = '';
    
    ?>

Posting Permissions

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



Click Here to Expand Forum to Full Width