Skip to main content
Mod Moved Comments To Chat
Updated to exact syntax used by the question author
Source Link
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'@'%'TO 'root'@'myIPaddress'

and don't forget to follow that with

FLUSH PRIVILEGES

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'@'%' 

and don't forget to follow that with

FLUSH PRIVILEGES

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
Formatting
Source Link
Paul White
  • 90.3k
  • 30
  • 424
  • 663

Use a sqlSQL commands like this mysql -u user -p -e 'Your SQL Query Here' database-name:

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? thisThis would mean that only these two hosts are allowed for access. you can try `GRANT ALL PRIVILEGES ON . to 'root'@'%':

GRANT ALL PRIVILEGES ON . to 'root'@'%' 

and don't forget to follow that with FLUSH PRIVILEGES

FLUSH PRIVILEGES

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'@'%'

and don't forget to follow that with FLUSH PRIVILEGES

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'@'%' 

and don't forget to follow that with

FLUSH PRIVILEGES
Source Link
codedawg82
  • 544
  • 3
  • 6

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'@'%'

and don't forget to follow that with FLUSH PRIVILEGES