Re: admin privilege problems
System, Friday, February 15, 2002, 5:38:51 AM, you wrote: jr i made the mistake of changing my root password manually in the mysql jr database. after doing so, i 'flushed privileges'. jr now i'm unable to log on using the root. i've tried to log on using the new jr password a number of times, but i'm always denied access. strangely enough, jr other users (that have passwords) can log on successfully without providing jr a password. does anybody have any recommendations for logging on as the root jr user ... and fixing this privileges problem? Look at: http://www.mysql.com/doc/R/e/Resetting_permissions.html It will help you. SAakaTRotP What if you run into: SAakaTRotP Script started on Thu Feb 14 20:35:44 2002 SAakaTRotP doctor.nl2k.ab.ca//var$ mysqladmin -h localhost -u root password 'Nathan84' SAakaTRotP mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' SAakaTRotP doctor.nl2k.ab.ca//var$ exuit it SAakaTRotP exit Did you run mysql at first time? The recomended way to change password and privileges is to use GRANT statement. SAakaTRotP Script done on Thu Feb 14 20:35:56 2002 -- For technical support contracts, goto https://order.mysql.com/ 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
Re: admin privilege problems
On Fri, Feb 15, 2002 at 12:16:01PM +0200, Egor Egorov wrote: System, Friday, February 15, 2002, 5:38:51 AM, you wrote: jr i made the mistake of changing my root password manually in the mysql jr database. after doing so, i 'flushed privileges'. jr now i'm unable to log on using the root. i've tried to log on using the new jr password a number of times, but i'm always denied access. strangely enough, jr other users (that have passwords) can log on successfully without providing jr a password. does anybody have any recommendations for logging on as the root jr user ... and fixing this privileges problem? Look at: http://www.mysql.com/doc/R/e/Resetting_permissions.html It will help you. SAakaTRotP What if you run into: SAakaTRotP Script started on Thu Feb 14 20:35:44 2002 SAakaTRotP doctor.nl2k.ab.ca//var$ mysqladmin -h localhost -u root password 'Nathan84' SAakaTRotP mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' SAakaTRotP doctor.nl2k.ab.ca//var$ exuit it SAakaTRotP exit Did you run mysql at first time? The recomended way to change password and privileges is to use GRANT statement. SAakaTRotP Script done on Thu Feb 14 20:35:56 2002 Further I try: Script started on Fri Feb 15 08:48:41 2002 doctor.nl2k.ab.ca//var$ exitmysql -u root mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'columns_priv' Didn't find any fields in table 'db' Didn't find any fields in table 'func' Didn't find any fields in table 'host' Didn't find any fields in table 'tables_priv' Didn't find any fields in table 'user' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 to server version: 3.23.48-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql exit Bye doctor.nl2k.ab.ca//var$ quit sh: quit: command not found doctor.nl2k.ab.ca//var$ exit exit Script done on Fri Feb 15 08:48:49 2002 -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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: admin privilege problems
On Tue, Feb 05, 2002 at 07:10:01PM +0200, Victoria Reznichenko wrote: jeremy, Tuesday, February 05, 2002, 6:40:29 PM, you wrote: jr hello, jr i made the mistake of changing my root password manually in the mysql jr database. after doing so, i 'flushed privileges'. jr now i'm unable to log on using the root. i've tried to log on using the new jr password a number of times, but i'm always denied access. strangely enough, jr other users (that have passwords) can log on successfully without providing jr a password. does anybody have any recommendations for logging on as the root jr user ... and fixing this privileges problem? Look at: http://www.mysql.com/doc/R/e/Resetting_permissions.html It will help you. jr thx jr jeremy -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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 - 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 What if you run into: Script started on Thu Feb 14 20:35:44 2002 doctor.nl2k.ab.ca//var$ mysqladmin -h localhost -u root password 'Nathan84' mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' doctor.nl2k.ab.ca//var$ exuit it exit Script done on Thu Feb 14 20:35:56 2002 -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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
admin privilege problems
jeremy, Tuesday, February 05, 2002, 6:40:29 PM, you wrote: jr hello, jr i made the mistake of changing my root password manually in the mysql jr database. after doing so, i 'flushed privileges'. jr now i'm unable to log on using the root. i've tried to log on using the new jr password a number of times, but i'm always denied access. strangely enough, jr other users (that have passwords) can log on successfully without providing jr a password. does anybody have any recommendations for logging on as the root jr user ... and fixing this privileges problem? Look at: http://www.mysql.com/doc/R/e/Resetting_permissions.html It will help you. jr thx jr jeremy -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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 - 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
admin privilege problems
hello, i made the mistake of changing my root password manually in the mysql database. after doing so, i 'flushed privileges'. now i'm unable to log on using the root. i've tried to log on using the new password a number of times, but i'm always denied access. strangely enough, other users (that have passwords) can log on successfully without providing a password. does anybody have any recommendations for logging on as the root user ... and fixing this privileges problem? version 3.23.46 thx jeremy - 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
admin privilege problems
jeremy, Tuesday, February 05, 2002, 6:40:29 PM, you wrote: jr hello, jr i made the mistake of changing my root password manually in the mysql jr database. after doing so, i 'flushed privileges'. jr now i'm unable to log on using the root. i've tried to log on using the new jr password a number of times, but i'm always denied access. strangely enough, jr other users (that have passwords) can log on successfully without providing jr a password. does anybody have any recommendations for logging on as the root jr user ... and fixing this privileges problem? Look at: http://www.mysql.com/doc/R/e/Resetting_permissions.html It will help you. jr thx jr jeremy -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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