SQL Error (1045) in statement #0: Access denied for user 'root'@'localhost' (using password: YES)

[expired user #8436]'s profile image [expired user #8436] posted 9 years ago in General Permalink
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!
[expired user #8436]'s profile image [expired user #8436] posted 9 years ago Permalink
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...)
[expired user #8436]'s profile image [expired user #8436] posted 9 years ago Permalink
I was able to correct this with the using the documentation below:

http://dev.mysql.com/doc/refman/5.6/en/resetting-permissions.html

Please login to leave a reply, or register at first.