Re: mysql all messedup ... :'( .....
hi iikka pal im really gratefull ... n egor to u too ... now i CAN get into mysql thru mysql -u root so root s workin n one of my other two users too i ve made 2 databases ... n they r connected 2 but ... its rather weired 1 with password n the other without i gave them both passwords grant all privileges on *.* to zyyn identified by '*' with grant option; grant all privileges on *.* to sir identified by '*' with grant option; n now sir s connected WITH a password n zyyn without ... :s n secondly guyz cud someone pleez hlp me with phpmyadmin i ve to fill in the data base with a dump from my site . n i cant get into myadmin thinggy ... with or without da password ... :S Error MySQL said: Access denied for user: 'zyyn@localhost' (Using password: YES) thnx a million guyz . a billion rather toby _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql all messedup ... :'( .....
>From: Iikka Meriläinen <[EMAIL PROTECTED]> >To: toby - <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: mysql all messedup ... :'( . >Date: Thu, 26 Sep 2002 17:26:10 +0300 (EEST) > >Did you check Egor's last message to you on the list? After starting mysqld >with --skip-grant-tables you should be able to connect with this: >mysql -u root >on the server, otherwise use mysql -u root -h your.server.ip.address > >It won't be of much help if you can't get 'root' working. Please try to get >that right first and then check your own account. > >Best regards, >Iikka hay i aint gettin no messeges except fo urs n anothr NUN ... nobodys not even the regular mails ... i even mailed gor a day or two bak but got no response ... what on earth is goin on is hotmail screwin me too :S :| anyway ive just done this : c:\mysqld --skip-grant-tables ENTER n its been 5 minutes and the cursor s till stuck at the next line blinkin n doin nuthin jeeez this is really sumthin ... shall i format my hard disk all over again ... im really fedup guys thnx a zillion . givin up toby ... :( _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql all messedup ... :'( .....
Did you check Egor's last message to you on the list? After starting mysqld with --skip-grant-tables you should be able to connect with this: mysql -u root on the server, otherwise use mysql -u root -h your.server.ip.address It won't be of much help if you can't get 'root' working. Please try to get that right first and then check your own account. Best regards, Iikka On Thu, 26 Sep 2002, toby - wrote: > u think that d make much of a difference > :( ... > i cant work with the thing any more yaar > rather cant make it work . > the thing that i waz actually playin with last week ... :S > and i jst cannot recall how i handled it last time i installed it on n all > ... > > though i had my myadmin's config files saved on my disk and i ve copied them > bak but still nuthin > > this is the error i keep gettin now > > > Error > MySQL said: > Access denied for user: 'sir@localhost' (Using password: YES) > > nomatter where i try to acess it from ... > from cmd i can do this : > > mysql --user sir@localhost > n it letts me in but not > > mysql --user sir --pass > password * > > i get the same error: > > Access denied for user: 'zaban@localhost' (Using password: YES) > > n im lost and ve a demo tomorrow aftrnoon n im doomed :'( > > thnx a million anyway fo ur time n concern > > i really appriciate it > > toby . > > > > > > >From: Iikka Merilinen <[EMAIL PROTECTED]> > >To: toby - <[EMAIL PROTECTED]> > >CC: [EMAIL PROTECTED] > >Subject: Re: mysql all messedup ... :'( . > >Date: Thu, 26 Sep 2002 16:59:11 +0300 (EEST) > > > >Hi again, > > > >Sorry, you _did_ mention your MySQL version... wrote the reply in quite a > >hurry. Why aren't you using the latest version (3.23.52)? > > > >Iikka > > > >On Thu, 26 Sep 2002, toby - wrote: > > > > > ok guys > > > > > > i ve actually done it fo myslf ... :'( > > > mysql s all screwedup ... > > > i reinstalled it last night and myadmin too ... now ... > > > ive created two users and databases n ... > > > wolla > > > i cnt even login ... :'( > > > > > > i feel like banging my head against da walls > > > > > > vat in earth is with this thing workin prefect last week n ever > >since i > > > had my hard disk formatted its all out > > > > > > i made the users at cmd mode o i ve win 2k pro, apache 1.3.24 , php > >4.2.2 > > > mysql 3.23.39 (now) and phpmyadmin 2.2.6 (installed from binary) > > > > > > and plz ... id b eternally gratefull if any one of u guys cud come > >online on > > > msn n hlp me plz . > > > > > > > > > all screwedup . > > > > > > toby > > > > > > > > > _ > > > MSN Photos is the easiest way to share and print your photos: > > > http://photos.msn.com/support/worldwide.aspx > > > > > > >** > >* Iikka Merilinen * > >* E-mail: [EMAIL PROTECTED] * > >* Vaala, Finland * > >** > > > > > _ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql all messedup ... :'( .....
u think that d make much of a difference :( ... i cant work with the thing any more yaar rather cant make it work . the thing that i waz actually playin with last week ... :S and i jst cannot recall how i handled it last time i installed it on n all ... though i had my myadmin's config files saved on my disk and i ve copied them bak but still nuthin this is the error i keep gettin now Error MySQL said: Access denied for user: 'sir@localhost' (Using password: YES) nomatter where i try to acess it from ... from cmd i can do this : mysql --user sir@localhost n it letts me in but not mysql --user sir --pass password * i get the same error: Access denied for user: 'zaban@localhost' (Using password: YES) n im lost and ve a demo tomorrow aftrnoon n im doomed :'( thnx a million anyway fo ur time n concern i really appriciate it toby . >From: Iikka Merilinen <[EMAIL PROTECTED]> >To: toby - <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: mysql all messedup ... :'( . >Date: Thu, 26 Sep 2002 16:59:11 +0300 (EEST) > >Hi again, > >Sorry, you _did_ mention your MySQL version... wrote the reply in quite a >hurry. Why aren't you using the latest version (3.23.52)? > >Iikka > >On Thu, 26 Sep 2002, toby - wrote: > > > ok guys > > > > i ve actually done it fo myslf ... :'( > > mysql s all screwedup ... > > i reinstalled it last night and myadmin too ... now ... > > ive created two users and databases n ... > > wolla > > i cnt even login ... :'( > > > > i feel like banging my head against da walls > > > > vat in earth is with this thing workin prefect last week n ever >since i > > had my hard disk formatted its all out > > > > i made the users at cmd mode o i ve win 2k pro, apache 1.3.24 , php >4.2.2 > > mysql 3.23.39 (now) and phpmyadmin 2.2.6 (installed from binary) > > > > and plz ... id b eternally gratefull if any one of u guys cud come >online on > > msn n hlp me plz . > > > > > > all screwedup . > > > > toby > > > > > > _ > > MSN Photos is the easiest way to share and print your photos: > > http://photos.msn.com/support/worldwide.aspx > > > >** >* Iikka Merilinen * >* E-mail: [EMAIL PROTECTED] * >* Vaala, Finland * >** _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql all messedup ... :'( .....
Hi again, Sorry, you _did_ mention your MySQL version... wrote the reply in quite a hurry. Why aren't you using the latest version (3.23.52)? Iikka On Thu, 26 Sep 2002, toby - wrote: > ok guys > > i ve actually done it fo myslf ... :'( > mysql s all screwedup ... > i reinstalled it last night and myadmin too ... now ... > ive created two users and databases n ... > wolla > i cnt even login ... :'( > > i feel like banging my head against da walls > > vat in earth is with this thing workin prefect last week n ever since i > had my hard disk formatted its all out > > i made the users at cmd mode o i ve win 2k pro, apache 1.3.24 , php 4.2.2 > mysql 3.23.39 (now) and phpmyadmin 2.2.6 (installed from binary) > > and plz ... id b eternally gratefull if any one of u guys cud come online on > msn n hlp me plz . > > > all screwedup . > > toby > > > _ > MSN Photos is the easiest way to share and print your photos: > http://photos.msn.com/support/worldwide.aspx > ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql all messedup ... :'( .....
Hi, Er, I don't want to be rude, but those dots drive me crazy. Could you include more details? What version of MySQL running now? Running as a service r from the command line? You can't even log in? What does MySQL client say? I suggest using the command line client for early troubleshooting, just to make sure the problem isn't elsewhere. Did you do a proper uninstall? I mean, if you had your previous mysqld installed as a service, did you uninstall that service first? Are you using your old grant tables or the clean, new ones that ship with the setup package? Or are you logging in as 'root'? Or as a different user? Double check your passwords and try an empty password for 'root', too. Also, please see http://www.mysql.com/doc/en/Access_denied.html for some common causes of Access Denied errors. Regards, Iikka On Thu, 26 Sep 2002, toby - wrote: > ok guys > > i ve actually done it fo myslf ... :'( > mysql s all screwedup ... > i reinstalled it last night and myadmin too ... now ... > ive created two users and databases n ... > wolla > i cnt even login ... :'( > > i feel like banging my head against da walls > > vat in earth is with this thing workin prefect last week n ever since i > had my hard disk formatted its all out > > i made the users at cmd mode o i ve win 2k pro, apache 1.3.24 , php 4.2.2 > mysql 3.23.39 (now) and phpmyadmin 2.2.6 (installed from binary) > > and plz ... id b eternally gratefull if any one of u guys cud come online on > msn n hlp me plz . > > > all screwedup . > > toby > > > _ > MSN Photos is the easiest way to share and print your photos: > http://photos.msn.com/support/worldwide.aspx > ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: mysql all messedup ... :'( .....
toby, Thursday, September 26, 2002, 2:53:08 PM, you wrote: t> i ve actually done it fo myslf ... :'( t> mysql s all screwedup ... t> i reinstalled it last night and myadmin too ... now ... t> ive created two users and databases n ... t> wolla t> i cnt even login ... :'( Start MySQL server with --skip-grant-tables and check user privileges: http://www.mysql.com/doc/en/Resetting_permissions.html t> i feel like banging my head against da walls Toby, as Miguel already said you "Error on rename of '.\zabandb\ctnt_inf.MYI' to '.\zabandb\#sql2-5b0-7e.MYI' (Errcode: 13)" is a rename table bug and it already fixed. t> vat in earth is with this thing workin prefect last week n ever since i t> had my hard disk formatted its all out t> i made the users at cmd mode o i ve win 2k pro, apache 1.3.24 , php 4.2.2 t> mysql 3.23.39 (now) and phpmyadmin 2.2.6 (installed from binary) t> and plz ... id b eternally gratefull if any one of u guys cud come online on t> msn n hlp me plz . -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php