1. Mysql Mac Tutorial
2. Mysql Mac Starting
3. Mysql Run Mac Terminal
4. Mysql Mac Startup
5. Mysql Mac Os X
6. Start Mysql Mac Brew

Connect to MySQL Server 4.x/ 5.x/ 8.x located on Linux, Solaris, Mac OS X, Windows machines Amazon RDS MySQL DB Instance support Views conversion from MySQL to MS SQL and Oracle and back support. For me it was 'mysql-installer-community-8.0.20.0' Then remove/uninstall the SQL Server and remove all configurations; Manually delete the SQL Server folder from 'C: Program Files MySQL MySQL Server 8.0.' Start your mysql installer again and install the SQL Server again; You can check from the window's services that the MySqL Server has started. MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts. MySQL Cluster Community Edition is available as a separate download.

Summary: in this tutorial, you will learn how to use the MySQL CREATE USER statement to create a new user in the database server.

MySQL CREATE USER syntax

The CREATE USER statement creates a new user in the database server.

Here is the basic syntax of the CREATE USER statement:

In this syntax:

First, specify the account name after the CREATE USER keywords. The account name has two parts: username and hostname, separated by the @ sign:

The username is the name of the user. And hostname is the name of the host from which the user connects to the MySQL Server.

The hostname part of the account name is optional. If you omit it, the user can connect from any host.

An account name without a hostname is equivalent to:

If the username and hostname contains special characters such as space or -, you need to quote the username and hostname separately as follows:

Besides the single quote ('), you can use backticks ( `) or double quotation mark ( ').

Second, specify the password for the user after the IDENTIFIED BY keywords.

The IF NOT EXISTS option conditionally create a new user only if it does not exist.

Note that the CREATE USER statement creates a new user without any privileges. To grant privileges to the user, you use the GRANT statement.

MySQL CREATE USER example

First, connect to the MySQL Server using the mysql client tool:

Enter the password for the root account and press Enter:

Second, show users from the current MySQL Server:

Here is the output:

Third, create a new user called bob:

Fourth, show all users again:

Mysql Mac Tutorial

The output will be:

The user bob has been created successfully.

Fifth, open a second session and log in to the MySQL as bob:

Input the password for bob and press Enter:

Sixth, show the databases that bob has access:

Here is the list of databases that bob can access:

Seventh, go to the session of the user root and create a new database called bobdb:

Mysql Mac Starting

Eight, select the databasebobdb:

Ninth, create a new table called lists:

Notice that when you press Enter, instead of showing the mysql> command, the mysql tool shows the -> that accepts new clause of the statement.

Tenth, grant all privileges on the bobdb to bob:

Note that you will learn how to grant privileges to a user in the GRANT tutorial.

Eleventh, go to the bob’s session and show databases:

Now, bob can see the bobdb:

Twelfth, select the database bobdb:

Thirteenth, show the tables from the bobdb database:

The user bob can see the lists table:

Fourteenth, insert a row into the lists table:

Mysql Run Mac Terminal

Fifteenth, query data from the lists table:

This is the output:

So the user bob can do everything in the bobdb database.

Finally, disconnect from the MySQL Server from both sessions:

In this tutorial, you have learned how to use the MySQL CREATE USER to create a new user in the database server.

Mysql Mac Startup

• Was this tutorial helpful?

MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts.

MySQL Cluster Community Edition is available as a separate download. The reason for this change is so that MySQL Cluster can provide more frequent updates and support using the latest sources of MySQL Cluster Carrier Grade Edition.

MySQL 8.0 is the most current GA release. Download MySQL 8.0 »

Mysql Mac Os X

Learn What's New in MySQL 8.0 and view the Performance Benchmarks.

Start Mysql Mac Brew

Please report any bugs or inconsistencies you observe to our Bugs Database.
Thank you for your support!