It is common practice, for example, for each unique MySQL database on a server to have its own unique user associated with it, such that only one single user has authentication access to one single database and vice-versa. In most cases, you’ll be granting privileges to MySQL users based on the particular database that account should have access to. There are a wide range of flags and options available to the command, so you may wish to familiarize yourself with what GRANT can actually do by browsing through the official documentation. You will eventually want to create a new user in a MySQL database so you don’t need to use the root account anymore.Whether you’re running MySQL locally or u. The GRANT command is capable of applying a wide variety of privileges, everything from the ability to CREATE tables and databases, read or write FILES, and even SHUTDOWN the server. For more information on choosing a package, see Section 2.3.2, Choosing an Installation Package. Now that you are at the mysqlcli prompt, you need only issue the GRANT command with the necessary options to apply the appropriate permissions. MySQL Installer automatically installs MySQL Server and additional MySQL products, creates an options file, starts the server, and enables you to create default user accounts.

Windows mysql create user