What command can I use in linux to create a new mysql database.

[ghurty]

What command can I use in linux to create a new mysql database.

 

Lets assume I want to create database name: nudatabase

Server is localhost, username is root, password is test.

 

 

Thanks

[Maq]

You would use:

 

mysql -uroot -p

 

then it will prompt you for a password.

 

To create a database, it's simply:

 

create database database_name;

[Maq]

You can 'man' almost any command to acquire detailed information:

 

man mysql

 

 

 

 

 

 

 

 

[roopurt18]

If you want to access the database as someone other than root, don't forget to use GRANT afterwards!