Re: Can't login mysql with root account!
Hi! [EMAIL PROTECTED] wrote: I have just installed MySQL server v3.23.49-8.5 (downloaded from Debian Packages Site) into my Debian v3.0r2 box! After finished installing, i had followed the instruction here to change root's password but right after --8 Try to do a login without using passwords: mysql -u root --- do not provide a password REASON: by default the root user is allowed to login without password from localhost, even though you provide password. this action, i can't login to mysql any more! I had also try to change ownership of /var/lib/mysql and all files and subfolders within this directory to mysql but still login fail! -8 Providing a error message would be a nice thing to have when trying to figure out what's wrong Best Regards! -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ||Cel: +58-412-8859934 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't login mysql with root account!
I have just installed MySQL server v3.23.49-8.5 (downloaded from Debian Packages Site) into my Debian v3.0r2 box! After finished installing, i had followed the instruction here to change root's password but right after this action, i can't login to mysql any more! I had also try to change ownership of /var/lib/mysql and all files and subfolders within this directory to mysql but still login fail! Any suggestion? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't login mysql with root account!
I have just installed MySQL server v3.23.49-8.5 (downloaded from Debian Packages Site) into my Debian v3.0r2 box! After finished installing, i had followed the instruction here to change root's password but right after this action, i can't login to mysql any more! I had also try to change ownership of /var/lib/mysql and all files and subfolders within this directory to mysql but still login fail! Any suggestion? Thanks! if you can't get in with the root password at all...then you'll need to try this-http://www.mysql.com/doc/en/Resetting_permissions.html What error is showing up? How are you logging in, are you supplying the password now? mysql -u root -pyournewpass (or omit the password and let it prompt you) if you are, make sure it worked correctly by tryng to login without the password mysql -u root hth Jeff __ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]