mysql root access err 1045... beware of this
Just want to share an experience I had with MySQL losing the root access er 1045... After granting new priviledges I discovered that when I installed MySQL I (because faulty keyboard) type a password with one different character. I discovered wheb trying to access with:
mysql -u root -ppassword instead of mysql -u root (this one requires you to type and you don't 'see' what works and what don't)...
that way I 'saw' the password that was working (1 in 10 tries), This was driving me nuts...
Just ... to share...
MySQL is a tool not everybody use on a 'daily' basis, Once you have it working you can easily IMO forget about it. More if you use a tool to manage your db's... Thats one reason when it breaks it breaks heavilty.. at least newbiews
Last edited by latino; 03-15-2004 at 10:11 PM.