# MySQL noob question: Where can I find the database when I create one?

**URL:** <https://www.ruby-forum.com/t/mysql-noob-question-where-can-i-find-the-database-when-i-create-one/173226>\
**Category:** Rails\
**Created:** [August 5, 2009, 9:22am UTC](https://www.ruby-forum.com/t/mysql-noob-question-where-can-i-find-the-database-when-i-create-one/173226 "2009-08-05T09:22:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jkadarusman](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/d9b06d/32.png) [@jkadarusman](https://www.ruby-forum.com/u/jkadarusman)\
**Post date:** [August 5, 2009, 9:22am UTC](https://www.ruby-forum.com/t/mysql-noob-question-where-can-i-find-the-database-when-i-create-one/173226/1 "2009-08-05T09:22:57Z")

</div>

See my screenshot of the command here.  
[http://a.imagehost.org/0843/mysqladmin.png](http://a.imagehost.org/0843/mysqladmin.png)

When I type the following:  
mysqladmin create \<database\_name\> --user=root --password=xxxxxxxx

Is my command executed simply by pressing “Enter” after the command?  
Am I missing some syntax?  
If the command has been executed , what directory can I find this  
database?

How does this relate to MySQL Administrator?  
[http://a.imagehost.org/0476/mysql\_administrator.png](http://a.imagehost.org/0476/mysql_administrator.png)

Sorry for such a stupid question.

- Sinclair

---

<div class="post-metadata">

**Author:** ![jkadarusman](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/d9b06d/32.png) [@jkadarusman](https://www.ruby-forum.com/u/jkadarusman)\
**Post date:** [August 5, 2009, 9:25am UTC](https://www.ruby-forum.com/t/mysql-noob-question-where-can-i-find-the-database-when-i-create-one/173226/2 "2009-08-05T09:25:53Z")

</div>

On Aug 5, 4:32 am, Sinclair [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> See my screenshot of the command here.[http://a.imagehost.org/0843/mysqladmin.png](http://a.imagehost.org/0843/mysqladmin.png)
> 
> When I type the following:  
> mysqladmin create \<database\_name\> --user=root --password=xxxxxxxx
> 
> Is my command executed simply by pressing “Enter” after the command?  
> Am I missing some syntax?

Sort of. mysqladmin is a command line utility, so you run it from your  
shell / dos prompt, not from the mysql console (although you can  
create databases from there too).

> If the command has been executed , what directory can I find this  
> database?

don’t remember where databases go in windows. Probably somewhere  
inside c:\program files\mysql or whatever the default installation  
folder is.

> How does this relate to MySQL Administrator?[http://a.imagehost.org/0476/mysql\_administrator.png](http://a.imagehost.org/0476/mysql_administrator.png)

That’s a graphical tool for performing various tasks

Fred

---

<div class="post-metadata">

**Author:** ![jkadarusman](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/d9b06d/32.png) [@jkadarusman](https://www.ruby-forum.com/u/jkadarusman)\
**Post date:** [August 5, 2009, 10:40am UTC](https://www.ruby-forum.com/t/mysql-noob-question-where-can-i-find-the-database-when-i-create-one/173226/3 "2009-08-05T10:40:20Z")

</div>

Hi  
If you installed in c drive then the location will be  
C:\mysql\data\

```
And one more thing to create/drop your development,test,production 

```

dbs need not go to mysql console There are rake tasks for that From your  
project directory do

rake db:create #creates developmentdb you specified in database.yml  
rake db:create RAILS\_ENV=test creates testdb

or  
rake db:create:all this creates all your dbs for 3 environments

similarly  
rake db:drop and rake db:drop:all  
Note: be careful while using There wont be anywarning

Sijo