Skip to main content
3 of 3
Updated to exact syntax used by the question author
Paul White
  • 90.3k
  • 30
  • 424
  • 663

Use a SQL commands like this:

mysql -u user -p -e 'Your SQL Query Here' database-name

to figure out what users are accessing your db.

In the results, did you only see localhost and 127.0.0.1 for the host? This would mean that only these two hosts are allowed for access. you can try:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'myIPaddress'

and don't forget to follow that with

FLUSH PRIVILEGES
codedawg82
  • 544
  • 3
  • 6