Database Reference
In-Depth Information
Figure 12.2
Content of the user system table.
Creating a User
To create a new user then, and give them the greatest possible access, we would use:
GRANT ALL PRIVILEGES
ON *.* TO Mary@localhost
IDENTIFIED by “yeti”
That does not immediately produce any results, but if you select everything from the
USER table again you will see the results in Figure 12.3. Notice that we now have a Mary
entry in the table, with a scrambled password.
Figure 12.3
The new user in the user table.
Search WWH ::
Custom Search