Newbie Question: Finding mySQL Default DB on Server

[mtorbin]

Hey all,

I'm VERY new to mySQL. How can I find the default DB on the server (RH Linux)? I need to find the right information to plug into the admin tool.

Thanks,

- MT

 

[Kozusnik]

I'm not sure what a default db would be. Usually the databases are stored in /var/lib/mysql/{database name}. as far as a default, maybe someone else might know.

Mark

SELECT * FROM management WHERE clue > 1
> 0 rows returned

--ThinkGeek T-Shrit

 

[lgarner]

There isn't a default. MySQL has two databases that are created at installation: mysql and test. Specifying either of those, or any other database, will probably satisfy the admin program.

 

[mtorbin]

OK, so I've found my setup, created a db and backed it up to a .sql document. That document, does it matter where on my web site I put it (as in the cgi docs have to be in the cgi-bin folder)? Please advise. The next step, I believe, would be to get my connection strings set up and then test it out.

- MT