Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How can we create a new database by using mysqladmin?
We would need special privileges to create or to delete a MySQL database. Following is the syntax for creating a new database using mysqladmin binary −
Syntax
[root@host]# mysqladmin -u root -p create db_name Enter password:******
Here, db_name is the name of the database we want to create.
Example
Following is a simple example to create a database called TUTORIALS −
[root@host]# mysqladmin -u root -p create TUTORIALS Enter password:******
The above query will create a MySQL database called TUTORIALS.
Updated on: 20-Jun-2020
117 Views
Advertisements