help using phpadmin
in [General]
|
From: Isaac Lee on 19 Jul 2010 00:34 this is the second time that i have made an account and set the password. then when i try to reaccess phpadmin, it shows this message: Error MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: NO) What am supposed to do so that my regain access to phpadmin? edit the php.ini file? isaac
From: "Carlos Sura" on 19 Jul 2010 01:29 Hello Isaac Lee. Are you running on Linux or Windows? You might try: mysql> SET PASSWORD FOR root@'localhost = PASSWORD(yourpassword); Then restart your service -if needed- If not... Try to edit config.inc.php file. Regards, Carlos Sura -----Original Message----- From: Isaac Lee [mailto:rhinecanthus(a)gmail.com] Sent: domingo, 18 de julio de 2010 10:34 p.m. Cc: php-general(a)lists.php.net Subject: [PHP] help using phpadmin this is the second time that i have made an account and set the password. then when i try to reaccess phpadmin, it shows this message: Error MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: NO) What am supposed to do so that my regain access to phpadmin? edit the php.ini file? isaac -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
From: Isaac Lee on 19 Jul 2010 12:23 thanks carlos, but where would i enter that command? and i tried editing the php.ini file but that didn't accomplish anything. isaac On Mon, Jul 19, 2010 at 1:29 AM, Carlos Sura <carlos_sura(a)hotmail.com> wrote: > Hello Isaac Lee. > > Are you running on Linux or Windows? > > You might try: > mysql> SET PASSWORD FOR root@'localhost = PASSWORD(yourpassword); > > Then restart your service -if needed- > > If not... Try to edit config.inc.php file. > > Regards, > > Carlos Sura > > -----Original Message----- > From: Isaac Lee [mailto:rhinecanthus(a)gmail.com] > Sent: domingo, 18 de julio de 2010 10:34 p.m. > Cc: php-general(a)lists.php.net > Subject: [PHP] help using phpadmin > > this is the second time that i have made an account and set the > password. then when i try to reaccess phpadmin, it shows this message: > > Error > > MySQL said: > > #1045 - Access denied for user 'root'@'localhost' (using password: NO) > > > What am supposed to do so that my regain access to phpadmin? edit the > php.ini file? > > isaac > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > >
From: Isaac Lee on 19 Jul 2010 12:24 im using windows. On Mon, Jul 19, 2010 at 12:23 PM, Isaac Lee <rhinecanthus(a)gmail.com> wrote: > thanks carlos, > > but where would i enter that command? > > and i tried editing the php.ini file but that didn't accomplish anything. > > isaac > > On Mon, Jul 19, 2010 at 1:29 AM, Carlos Sura <carlos_sura(a)hotmail.com> wrote: >> Hello Isaac Lee. >> >> Are you running on Linux or Windows? >> >> You might try: >> mysql> SET PASSWORD FOR root@'localhost = PASSWORD(yourpassword); >> >> Then restart your service -if needed- >> >> If not... Try to edit config.inc.php file. >> >> Regards, >> >> Carlos Sura >> >> -----Original Message----- >> From: Isaac Lee [mailto:rhinecanthus(a)gmail.com] >> Sent: domingo, 18 de julio de 2010 10:34 p.m. >> Cc: php-general(a)lists.php.net >> Subject: [PHP] help using phpadmin >> >> this is the second time that i have made an account and set the >> password. then when i try to reaccess phpadmin, it shows this message: >> >> Error >> >> MySQL said: >> >> #1045 - Access denied for user 'root'@'localhost' (using password: NO) >> >> >> What am supposed to do so that my regain access to phpadmin? edit the >> php.ini file? >> >> isaac >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> >> >
From: Carlos Sura on 19 Jul 2010 13:30 Hello Isaac Lee, I don't remember well, but I think this is the way to do it in Windows. You can try this: Start ------> Run ----> cmd // Write it and press enter key. It will show you a MS-DOS window, Write there: mysql now: mysql> cd c:\location\mysql\bin Then you might try: mysqladmin -u root password new_password Now type: mysql -u root -p Write your new password now :) If none of this work... Please show me your ini* file. If you can't show me your ini* file please reffer to: http://search.mysql.com/search?q=Resetting_permissions.html&lr=lang_en Regards, Carlos Sura. > Date: Mon, 19 Jul 2010 12:24:26 -0400 > From: rhinecanthus(a)gmail.com > To: carlos_sura(a)hotmail.com > CC: php-general(a)lists.php.net > Subject: Re: [PHP] help using phpadmin > > im using windows. > > On Mon, Jul 19, 2010 at 12:23 PM, Isaac Lee <rhinecanthus(a)gmail.com> wrote: > > thanks carlos, > > > > but where would i enter that command? > > > > and i tried editing the php.ini file but that didn't accomplish anything. > > > > isaac > > > > On Mon, Jul 19, 2010 at 1:29 AM, Carlos Sura <carlos_sura(a)hotmail..com> wrote: > >> Hello Isaac Lee. > >> > >> Are you running on Linux or Windows? > >> > >> You might try: > >> mysql> SET PASSWORD FOR root@'localhost = PASSWORD(yourpassword); > >> > >> Then restart your service -if needed- > >> > >> If not... Try to edit config.inc.php file. > >> > >> Regards, > >> > >> Carlos Sura > >> > >> -----Original Message----- > >> From: Isaac Lee [mailto:rhinecanthus(a)gmail.com] > >> Sent: domingo, 18 de julio de 2010 10:34 p.m. > >> Cc: php-general(a)lists.php.net > >> Subject: [PHP] help using phpadmin > >> > >> this is the second time that i have made an account and set the > >> password. then when i try to reaccess phpadmin, it shows this message: > >> > >> Error > >> > >> MySQL said: > >> > >> #1045 - Access denied for user 'root'@'localhost' (using password: NO) > >> > >> > >> What am supposed to do so that my regain access to phpadmin? edit the > >> php.ini file? > >> > >> isaac > >> > >> -- > >> PHP General Mailing List (http://www.php.net/) > >> To unsubscribe, visit: http://www.php.net/unsub.php > >> > >> > >> > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > _________________________________________________________________ We want to hear all your funny, exciting and crazy Hotmail stories. Tell us now http://clk.atdmt.com/UKM/go/195013117/direct/01/
|
Pages: 1 Prev: MySQL Query Puzzle Next: How to set socket_read time out |