conect to the server

[castali]

my First point is to connect to the server with MySQL Adminisrator

I have created a new connection = MyConn
username = any
password = any
Hostname ?? Localost doesn't work then I have tried the name of my Computer it doesn't work too


where can I find the way to connect to the server to create a database ?

thank you

 

[TonyGroves]

You could try "localhost" or "127.0.0.1" (without quotes).

 

[castali]

localhost does not work .. ok I try 127.0.0.1

thank you

 

[castali]

nothing works
what is the method I on windows 2000 pro

I create a new connection MySQL Administrator

Username = ? no idea ! shall I put anything ?
Password = ? no idea ! shall I put anything ?
HostName = Localhost or localhost (is it case sensitive ?) or 127.0.0.1
Port = 3306

thank you

 

[TonyGroves]

The user name and password must be a valid user name and password for the particular server you are trying to access. You must find out what to use from whoever is administering the server. For a newly-set-up server, the user "root", with a blank password, is created by default. The port is 3306 by default, but it could have been changed to something else.

For the host name, "localhost" (not case-sensitive) or "127.0.0.1" will work if the server is located on the machine you are using. If it is located elsewhere, you must use the IP address or computer name of the computer where it is located.

 

[castali]

but am i supposed to do ?

I create a new connection with "root" as user name on localhost ?, I am administrator

because there is nowhere a default connection ....if I don't create one it is empty

thank you

 

[TonyGroves]

Are you sure the server is running?
If you are running it as a Win2k service, it should run under an administrator's account.

 

[castali]

there is the green light in the menu bar beside the clock
but when I want to create a database with it I cannot find any command .. there is no command on right button

I really wonder why you need 3 or 4 different exe to run mySQL !!

thanks for helping

 

[castali]

in WinMySqlAdmin 1.4
in the box MyOdbc >>
Not Found
Driver 3.51 Not Found

and there is no server infos

 

[rab54]

You need the mysql ODBC drivers - get them here

http://www.mysql.com/downloads/api-myodbc.html

Try logging in at msql\bin dir with

mysql -u root -p

then press enter (no password by default) -

If you are ok then go to

http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Installing

and work through the docs .....

hope this helps .....

Rab

 

[castali]

I have download the ODBC and MySql Administrator 1.0.2b alpha for MySql 5.0

the green light is on

in the top bar of mySQL ADmin : >>> myLogin@localhost:3306

now how can I create a database ?

when I try User Administration I get an error message >> could not fetch UserNamrs Acces DEnied for User "@localhost" to database mysql


when I try Server Connections >>> Could not fetch Process list .. you need PROCESS privileges for it

I am logged in MY computer as Administrator !!!

what have I to do ??

on the Icon Catalog I have on database test >>> how can I create tables and colomns ??


is there any help on line ??

thank you

 

[rab54]

What OS are you on - I am on windows so you need to go to a cmd prompt (dos box) - then do as above - eg

cd\mysql\bin

mysql -u root

You should then get a 'Welcome to the mysql Monitor' -

go to the link above on mysql.com to find out about setting user accounts,security etc..

I recommend a good book (mysql by Paul Dubois is THE one !)

hope this helps ....

Rab

 

[castali]

but you don't need a book to create a database ! ?? .. I know access since many years ... then I have used MS SQL and it was also not a problem .. you just create your databases with contents normally .. with SQL queries or with ms SQL tools

is there any way to start mySQL server without dos ???
I use win 2k and I think the server is running when the green light is on ?

thks !

 

[rab54]

OK if you do not want to use the cmd line you will have to download a front-end GUI -

There are many out there , have a look at

http://www.mysql.com/portal/software/graphing/index-2.html

and choose whichever appeals to you -

Personally I use mysqlman.

cheers

Rab

 

[castali]

thank you !