Hi All,
I just found one thread on this forum on this subject here:
Forgot MYSQL password root | Unix Linux Forums | Web Development
but unfortunately the issue was not resolved.
I have the same problem with the same error message.
The background is that I built a Solaris 11 x86 server (using Solaris 11 Live DVD hard drive install option) for using as a test web server on my local LAN. I was amazed at how simple this was to "throw on" MySQL, Apache, PHP, and other prerequisites. I then installed Wordpress and it just worked. Unfortunately, in the rush to get it running I didn't note the MySQL root password that I used.
NOTE TO MODERATOR: If this would get a better response on a forum other than Solaris please do move it.
I haven't looked for or tried solutions found on Google yet. I just thought I'd put it on this great forum first.
I have modified the role of the root user to "normal". Obviously, I have physical hardware access, console root login access, etc.
Anybody know how to get back into MySQL in these circumstances?
Thanks in advance