Jumping the First Hurdle

New to MySql:
I can't seem to get a grab on what is a schema and what is a database
So I have seen! the 'Mysql' Database and the Test Database
I'm runninng the database Administrator and thinking
"What I what to do now is create a new one of these to create my own tables
in."
The HELP seems rather opaque on this! So I'm thinking that perhaps I've got
hold of the wrong end of the proverbial stick!
[what's the difference between a database and a Schema in the MySql
context!]
[and how do I create new ones!]


--
Jim Bunton

Jim Bunton wrote:
 > New to MySql:
 > I can't seem to get a grab on what is a schema and what is a database
 > So I have seen! the 'Mysql' Database and the Test Database
 > I'm runninng the database Administrator and thinking
 > "What I what to do now is create a new one of these to create my own tables
 > in."

Strangely, I have found no way in the graphical front-end applications
provided by MySQL (MySQL Administrator, MySQL Query Browser), to create
a database.

As far as I know, only the command-line mysql utilities can do this.
Run 'mysql' at the command line. In the mysql shell, you can issue a
'CREATE DATABASE' command.

See:
<a rel="nofollow" style='text-decoration: none;' href="http://dev.mysql.com/doc/mysql/en/mysql.html" target="_blank">http://dev.mysql.com/doc/mysql/en/mysql.html</a>
<a rel="nofollow" style='text-decoration: none;' href="http://dev.mysql.com/doc/mysql/en/create-database.html" target="_blank">http://dev.mysql.com/doc/mysql/en/create-database.html</a>

After the database is created, you can use the same command-line
interface or else the MySQL Query Browser GUI application to do
virtually everything else you need to do.

Other GUI applications, such as phpMyAdmin, include a database creation
feature, but these are not interfaces provided by MySQL AB.

Regards,
Bill K.