On Tue, Sep 22, 2009 at 9:33 PM, Nilambar <[email protected]> wrote:
> > Hello, > I am using Ubuntu. While installing Xampp in phpmyadmin i changed the > password for root. But now phpmyadmin is not opening. It says > -------------------------------- > Error > > MySQL said: Documentation > Cannot connect: invalid settings. > phpMyAdmin tried to connect to the MySQL server, and the server > rejected the connection. You should check the host, username and > password in your configuration and make sure that they correspond to > the information given by the administrator of the MySQL server. > ------------------------------- > Please help me in restoring original setting. > thanks > I will assume that you have installed the xampp to */opt/lampp* directory: Fire up a terminal and edit the config file of phpmyadmin... $ sudo gedit /opt/lampp/phpmyadmin/config.inc.php Edit the following line: $cfg['Servers'][$i]['auth_type'] = '*config*'; to look like: $cfg['Servers'][$i]['auth_type'] = '*cookie*'; Then refresh the phpmyadmin page: You will be prompted with dialog box to login. Hope you got this. In this case while using xampp, I suggest the following command to secure your lampp installation: $ sudo /opt/lampp/lampp security *<this will allow you to change the mysql root password as well>* > Nilambar Sharma > > > -- With Regards, Suraj Sapkota सुरज सापकोटा --~--~---------~--~----~------------~-------~--~----~ FOSS Nepal mailing list: [email protected] http://groups.google.com/group/foss-nepal To unsubscribe, e-mail: [email protected] Mailing List Guidelines: http://wiki.fossnepal.org/index.php?title=Mailing_List_Guidelines Community website: http://www.fossnepal.org/ -~----------~----~----~----~------~----~------~--~---
