Schoenland, Wednesday, May 15, 2002, 2:33:47 AM, you wrote: Seoen> Well, I am new to the list.. so if i ask something stupid, just slap me Seoen> on the back of my head, k? =)
Seoen> I was playing a little with my phpmyadmin and deleted user root. Now I Seoen> don't get access anymore.. Seoen> Is there any command like mysqladmin add user root again -f -and -shut Seoen> up? Seoen> (root is not allowed to the sqlhost anymore) Seoen> I tried this Seoen> (http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html Seoen> #Resetting_permissions), but it didn't want to.. Do you think so? If you run mysqld with "--skip-grant-tables" option you can connect with any user from any host and you can create user 'root' with all privileges. Seoen> Please help! Seoen> Daniel -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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
