hello sata, thanks. it worked. thanks a lot. Nilambar
On Wed, Sep 23, 2009 at 12:07 AM, SATA <[email protected]> wrote: > > > 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 > सुरज सापकोटा > > > > -- Nilambar Sharma Koteshwor, Kathmandu-35 --~--~---------~--~----~------------~-------~--~----~ 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/ -~----------~----~----~----~------~----~------~--~---
