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... Later p.d. 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 |
All times are GMT -5. The time now is 03:11 AM. |