Hello, after reviewing other threads here and elsewhere in regards to the subject error, I have still not been able to resolve this issue.
Basically on client running Windows 7 Professional, I can connect using Heidi to a local SQL DB only if I am running mysqld under my own windows user account in the cmd line:
C:\mariadb-10.0.13-win32\mariadb-10.0.13-win32\bin\mysqld --console --init-file=C:\\mysqpl-init.txt
However when I run mysql as a service under the default Network Services account or the System account, I can not connect.
Initially I thought this was an issue with the root users password, but I have since changed it and confirmed I can log in when running mysqld via the cmd line under my users account.
Any suggestions? I can provide more info if needed.
Thanks!
SQL Error (1045) in statement #0: Access denied for user 'root'@'localhost' (using password: YES)
After further review, even through I was able to "connect" when I ran under my users, the database and tables I was expecting to see where not present. I have now added skip-grant-tables=1 to the my.ini file and this did load the the database and tables when I was running as a service, just need to understand what this means now (what may be wrong with root ect...)
I was able to correct this with the using the documentation below:
http://dev.mysql.com/doc/refman/5.6/en/resetting-permissions.html
http://dev.mysql.com/doc/refman/5.6/en/resetting-permissions.html
Please login to leave a reply, or register at first.