Hi All,
I am New in MySQL. I Want to Create a Database in MySQL. I am Using MySQL5.0 & Write This Sentex for Creating Database :- CREATE DATABASE db_name;
But When I Use This Sentex Create Database With Single db.opt File. & I run this Database on Server Message Desplaye "Database Not Found"
How Can I Do Create Database in MySQL to Run on My FTP Server. Plz Anyone Help Me.

Your question is somewhat lacking in some crucial information that is needed to help you.

For example, what OS are you running this on?

Are you sure the MySQL server is running? How do you know?

Have you created a user besides 'root', and logged in as that user?

Can you connect to the MySQL from the command line?

Have you read the documentation at www.mysql.com?

For example, what OS are you running this on?
WIN XP SP2.

Are you sure the MySQL server is running? How do you know?
I Don't Know. How I Can Check This.

Have you created a user besides 'root', and logged in as that user?
I Have already Create user 'root'. And i Dont Know How Can I Logged.

Can you connect to the MySQL from the command line?
I Dont Know How Can I Connect to MySQL from Command Line.

Have you read the documentation at www.mysql.com?[/quote]
Yes. I am Read Document But dont Understand anything.

Yes. I am Read Document But dont Understand anything.[/quote]

First you must understand there are 2 'parts' to MySQL - the server and the client.

The server is the part that does all the database work, and the client is how to send SQL commands to the server to get executed. MySQL ships with both.

When you installed MySQL you were given a choice to install the server as either a 'service' or a stand-alone application. Which did you choose?

As a service, the MySQL server runs in the background and is started each time the computer starts. As a stand-alone, it runs when you execute a command to start the server, and stops when you execute the command to stop the server. If it is installed as a 'service' you can check this from the Control Panel under 'Administrative Toos -> Services'. If you see 'MySQL' in the list, and the status is 'Started' then you have installed it as a service. Please post the results of this finding.

How did you create a user 'root'? How do you know there is a user called 'root'?

First you have to determine whether the server is running before doing anything else.

Yes I am Found MySQL in Service under Adminstartion Tool & I Found it this Place. It's States are 'Started'. Plz Suggest me What Can I Do Next.

OK. Now you should create a user - it's not a good idea to use 'root' except when absolutely necessary.

When you are in a DOS shell window, you should be able to run the client and log in as 'root' with no password, unless you added a password during installation.

Change to the /bin directory of MySQL.

Enter: mysql --user root -h localhost

You should see a new prompt like this:
mysql>
This is the client prompt. You can now enter SQL commands, such as
mysql> show databases;

If this works then quit by entering 'exit'.

I don't know what version of MySQL you installed, but the mysql.com web site has documentation for creating a user. Then you must GRANT that user whatever rights you want them to have (create, select, delete, etc.).

Once you have a user (with password) created, then try this:

If MySQL is in your PATH you should be able to do something like this:
mysql --user=xxxxx --password=yyyyy -h localhost
and then you should see a new prompt like this:
mysql>

Again enter 'show databases;'

If this works, you have successfully created a user besides 'root', which is a good thing.
Enter 'exit' to quit the shell.

Now you can either use the existing client or install a different one like phpMyAdmin, or HeidiSQL. I suggest using the existing shell until you are very comfortable with the different SQL commands and what their results are.

To create databases use the mysqladmin command. But first you should get a user properly configured.

it First i am Using MySQL 5.0 Downloading From http://dev.mysql.com and I am Install this on My System. This run On DOS Screen. and When I Start This is Ask For Password. When I Enter Password. It's Redirect to me On mysql> Command Line Pompt and after this i am using CREATE DATABASE db_name; syntex for Creating Database. But When I Using This Syntex I am Successfully Created Database but This not Work on My FTP Server. This Syntex Only One File Create db.opt.

What Can u meet me on Chating in Yahoo. I am Online on my e-Mail:- hemgoyal_1990@yahoo.co.in . I am Online Everyday 3.00 to 4.30 PM.

Plz Send me Better Sugession so I can Develope my City Telephone Number Searching Project.

Thank You.

First I do not choose to use any form of Chat to help you solve your problem. Others may benefit from our thread so if you want my help keep your postings public.

Second, what do you plan to do with your database once it is created? Is it for personal use only, on your home computer, or will it be for public access via the web? This makes a lot of difference in how your questions are answered.

I don't know what your ftp server has to do with setting up MySQL.

I am Using my Database for Public Access on Web. I am Developed a Site www.kuchamancity.com . this is my Home town Website. & I am Provide Search Facility in This Website. my FTP Server is Linux. So I want to Create database in MySQL. Plz Suggest me.

Then you must find out from your host whether MySQL is installed, and whether you have access to it. Then using either phpMyAdmin or Heidi or some other client program, create your database and tables etc.

To find out more about MySQL go to mysql.com or find yourself a good book. You cannot learn enough about it from a few forum postings.

If you own your own server and are maintaining it for public access then you have quite a lot on your plate to learn.

So first answer whether your web domain is hosted by another company or by yourself.

Either way you will have to take some time and learn about relational databases in general and MySQL in particular on your own.

You will also need a programming language to access the web-based database such as Perl or PHP or Java or Python, etc.

Your ftp server has nothing to do with MySQL or this thread.