Home / server / Questions / 257058
Accepted
JM4
Asked: 2011-04-08 13:10:33 +0800 CST

Migrating mysql 'users' to new machine gives off errors

  • 772

I have looked at the settings a great number of times but run into the same issue. When connected to my Linux box with the 'exact' same settings, no fault. When run on a fresh machine with xampp for testing:

SQLSTATE[28000] [1045] Access denied for user 'user'@'localhost' (using password: YES)

I'm positive the user name, privileges and password are the same so anything else I could be missing?

mysql permissions user-management navicat

1 Answers

  1. Best Answer

    Probably you have skip-name-resolve option turned on.

    • 1