I have just installed MY SQL 5
and MY SQL Administrator 1.1.7

how can i connect to MY SQL
I get a Server Instance connecting box
what must be written in Server Host ? (for MS SQL 2000 localhost works)

i cant find my SERVER HOST name nowhere

thank you

The name of the server is usually the name of the computer its running on. its usually set via the contorl panel | system - and soemwhere on there there will be a tab which will show the computer name.Failing that find your systems hosts file - usually in windows/system32/drivers/etc

localhost is an alternative name netwrok loopback and will work on virtually all PC based OS's. localhost will work if the process that is talking to the db is on the same physical PC as the db.

HTH

then i am using the rigth name = my computer name and i cannot connect
i dont know what to do

i get the error MySQL Err number 1130 Host 'quentin' is not allowed to connect to mySQL server

my computer name is quentin

the port 3306 is open and the connection exists, the installation was sussessfull

in mysql administrator

Stored connection = quentin
server host = quentin
username = quentin
password = quentin

and i get the error quentin is not allowed !!

what user privileges does user quentin have on your database

does the mysql manual provide any clues

when you installed MySQL did you follow the instructions completly

did you try search for what theat error code meant on this forum, or google it

hint its to do with the grants

quentin is administrator on my computer
no i have not look in google ... i have followed all the steps anf it doesnt work
MS SQL works at once and just fine .. MY SQL seems too complicated

I have administrator rights on that acount then the databeses server must let me login

No, like most database systems, MySQL has its own security & user privileges. you need to grant privileges to specified users before they can use MySQL.

If you search on this thread for the error message you quoted you will find the answers to what you want. The problem is going to be to ensure that you know the main system user account and password. Usually its all covered in the MySQL installation process. Assuming that you didn't follow all the steps on the installation your system user account will be root and the password wlll be empty.

the system tray monitor shows MYSQL server runing correctly
but impossible to connect with mysql administrator

Stored connection = quentin
server host = quentin
username = quentin
password = quentin

are 100% right, there is no error here, thats all what i have entered in my install step by step

so what user privileges have you GRANTed, and to what database(s)
what database(s) have you created, have you checked to ensure what privileges have been granted to user quentin, and form what computer / network

what tool are you using to GRANT privileges. I see that there is a copy of MySQLAdministraor available for windows.

this maybe of relevance
http://www.experts-exchange.com/Prog..._21531921.html
for info on MySQL Administrator
http://dev.mysql.com/doc/administrat...n-windows.html
for info on GRANT
http://dev.mysql.com/doc/refman/4.1/...ure-grant.html