MySQL database name

 
Post new topic   Reply to topic    Aprelium Forum Index -> Databases
View previous topic :: View next topic  
Author Message
Pookie
-


Joined: 05 Jan 2005
Posts: 60
Location: Citrus Heights, CA

PostPosted: Sat Feb 25, 2006 10:22 am    Post subject: MySQL database name Reply with quote

im using windows xp pro with MySQL 5.0

This program told me that i need to setup a database using MySQL. I go to the command line of mysql, type in the command to show the status and the database name is blank, shows the user and password tho. how can i create a new database and name it. it didnt give me an option to setup a database, only thing it asked me to put in is a root password for security.
_________________
~TRU~
Back to top View user's profile Send private message Send e-mail
olly86
-


Joined: 25 Apr 2003
Posts: 993
Location: Wiltshire, UK

PostPosted: Sat Feb 25, 2006 4:07 pm    Post subject: Reply with quote

You can use the consol method, but I prefer to use two utilities provided by MySQL to this instead.

MySQL Administrator: http://www.mysql.com/products/tools/administrator/
MySQL Query Browser: http://www.mysql.com/products/tools/query-browser/

The first will alow you to setup new database, and manage permishions/user accouts. The second allows you to create, alter, and delete tables. As well as adding content.
_________________
Olly
Back to top View user's profile Send private message
aprelium
-


Joined: 22 Mar 2002
Posts: 6800

PostPosted: Sat Feb 25, 2006 4:14 pm    Post subject: Re: MySQL database name Reply with quote

Pookie,

Install PhpMyAdmin to have full control on MySQL and to be able to create/delete/update/browse databases.

Otherwise, you can use the MsYQL command line tool and issue commands to do what you want. To create a database, use CREATE DATABASE: http://dev.mysql.com/doc/refman/5.0/en/create-database.html .
_________________
Support Team
Aprelium - http://www.aprelium.com
Back to top View user's profile Send private message Send e-mail
phirez
-


Joined: 22 Apr 2006
Posts: 57

PostPosted: Tue Apr 25, 2006 4:37 am    Post subject: Reply with quote

My sql when installed is not a single database. My sql is a server that creates the databases. You create the databases using adminstrative gui. I recommend flashmyadmin go to: http://flashmyadmin.org/english/flashmyadmin.org.php
Back to top View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Databases All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group