![]() | testdb | CREATE DATABASE `testdb` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */ |ġ row in set (0.01 sec) Code language: JavaScript ( javascript )įinally, select the newly created database to work with by using the USE statement: USE testdb Code language: SQL (Structured Query Language) ( sql ) MySQL returns the database name and the character set and collation of the database: +-+-+ 02 sec) Code language: CSS ( css )Īfter that, use the SHOW CREATE DATABASE command to review the created database: SHOW CREATE DATABASE testdb Code language: SQL (Structured Query Language) ( sql ) It’ll return the following: Query OK, 1 row affected (0. Then, issue the CREATE DATABASE command with a database name e.g., testdb and press Enter: CREATE DATABASE testdb SHOW DATABASES ĥ rows in set (0.00 sec) Code language: JavaScript ( javascript ) Next, display the databases available on the server using the SHOW DATABASES statement. To authenticate, you need to type the password for the root user account and press the Enter key: Enter password: ******** To create a new database via the mysql client tool, you follow these steps:įirst, log in to the MySQL Server using a user account that has the CREATE DATABASE privilege: mysql -u root -p Code language: SQL (Structured Query Language) ( sql ) If you skip the CHARACTER SET and COLLATE clauses, MySQL will use the default character set and collation for the new database.Ĭreating a new database using the mysql client tool Third, specify the character set and collation for the new database.Second, use the IF NOT EXISTS option to conditionally create a database if it doesn’t exist.If you attempt to create a database with a name that already exists, MySQL will issue an error. The database name must be unique within a MySQL server instance. First, specify the name of the database after the CREATE DATABASE keywords.Code language: SQL (Structured Query Language) ( sql ) The following illustrates the basic syntax of the CREATE DATABASE statement: CREATE DATABASE database_name ![]() To create a new database in MySQL, you use the CREATE DATABASE statement. Introduction to the MySQL CREATE DATABASE statement ![]() That’s it! You have now created a MySQL database user in XAMPP and granted the appropriate privileges.Summary: in this tutorial, you will learn how to use the MySQL CREATE DATABASE statement to create a new database on a MySQL database server. To do this:ġ.Click on the “Edit privileges” link next to the username in the “User accounts” tab.Ģ. Select the database(s) you want to grant access to in the “Database” section.ģ. Select the privileges you want to grant to the user in the “Privileges” section.Ĥ. Click the “Go” button at the bottom of the page to save the changes. ![]() Once you have created the user, you can grant permissions to the user by selecting the database(s) and the privileges you want to grant to the user. Enter a password for the new user in the “Password” field.Ĩ. Retype the password in the “Re-type” field.ĩ. Leave the “Authentication Plugin” field set to “Use Legacy Authentication Method (Retain MySQL 5.x Compatibility)”.ġ0. Click the “Go” button at the bottom of the page to create the new user. You can create a MySQL database user in XAMPP by following these steps:ġ. Open XAMPP Control Panel and start the MySQL server.Ģ. Open your web browser and navigate to 3. Click on the “User accounts” tab in the top navigation menu.ĥ. Enter a username for the new user in the “Username” field.Ħ. Select “Local” as the host from the drop-down menu.ħ. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |