Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, tutorials, and more.

Using --skip-grant-tables

In this method, you stop the server and start it by specifying --skip-grant-tables, which will not load the grant tables. You can connect to the server as root without a password and set the password. Since the server runs without grants, it is possible for users from other networks to connect to the server. So as of MySQL 8.0.3, --skip-grant-tables automatically enables --skip-networking, which does not allow remote connections: