To open the MySQL prompt, type the following command and enter the MySQL root user password when prompted: mysql -u root -p Create a new MySQL database # All commands will be executed as a root user. Before you begin #īefore you start with this tutorial, we are assuming that you already have MySQL or MariaDB server installed on your system. This tutorial explains how to use the command line to create and manage MySQL or MariaDB databases and users. MySQL server allows us to create numerous users and databases and grant appropriate privileges so that the users can access and manage databases. MySQL is the most popular open-source relational database management system.
0 Comments
Leave a Reply. |