Press "Enter" to skip to content

MySQL v8 allow remote access.

bist 0

In version 8 the grant option to allow remote access no longer works and you will get syntax errors if you try to execute that command.

This is what you can do:

  • Create the root user (yes, a new user because what exists is ‘root@localhost’ which is local access only):CREATE USER 'root'@'%' IDENTIFIED BY '123';
  • Give the privileges:GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.