How to create server?

[m77]

I am using MySQL 3.23.43 under WinNT.

 

[Broccoli2]

Normally the server is run as a service. The easiest way to get going on WinNT is to use the '

winmysqladmin.exe

' in the

bin

directory where you unpacked the mysql zipfile.

-Rob

 

[m77]

I have started up winmysqladmin. Now how to get dbName to connect to db from localhost to create tables?

 

[Broccoli2]

Do you see a green or red traffic light in your system tray? I'll assume it's green (post here if it's not there, or it's red).

Open up a command prompt, and

cd

to your

mysql\bin

directory. Then type

mysql

. This should start the mysql console and connect to your MySQL server (which at the moment has no username/password restriction). You can now execute whatever SQL statements you wish, including

CREATE DATABASE

commands. However, I would recommend that one of the first things you should do is to change the records in the

mysql

database (which you will find already exists on your server) to restrict access. See

http://www.mysql.com/doc

and look for the pages on the privilege system for more details.

 

[m77]

Thanx. That is what I get:

mysql> SELECT DATABSE yo
-> create table t (a BLOB, index(a(10)));
ERROR 1064: You have an error in your SQL syntax near 'create table t (a BLOB, index(a(10)))' at line 2

 

[m77]

I often got a message "No database selected"
How to select one?

 

[Broccoli2]

You can see what databases are available using

SHOW DATABASES;

To investigate a database further, the syntax is

USE databasename;

To show all the tables in the current database, use

SHOW TABLES;

Once you've got the hang of the console, you can try connecting using other clients, depending on what you're using the database for. If it's for a database-driven website, I recommend PHP. Alternatively, if you want a nice 'front end' to your database you can use Microsoft Access (and MyODBC - downloadable from the mysql site).

Hope it goes well,
-Rob

 

[m77]

Thank you!

Well, done.

Now i need dbName to connect it from JAVA application.
For example for Oracle DB i use, dbName is "jdbcracle:thincastro.telekom.lv:1525:z81".
Is it possible to connect from application on my PC to MySQL DB on my pc without using net?

 

[Broccoli2]

Sorry, I don't know much about Java. However, once you've tested your user/password combination using the mysql console, it seems that you can use JDBC to connect - see

http://www.mysql.com/doc/J/a/Java.html

This should all work without having to be connected to the internet.

-Rob

 

[m77]

How u know what is dbName of your just created Database to work with one from PHP, for example?

 

[m77]

RobEyre, THANK YOU VERY MUCH.

I have solved the problem. Are u creator of this site? Just interesting

 

[Broccoli2]

No problem. Hope your Java goes well.

-Rob