Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2005
    Posts
    115

    Unanswered: only connecting !!!

    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

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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

  3. #3
    Join Date
    Jun 2005
    Posts
    115
    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 !!
    Last edited by quentin; 01-18-06 at 04:20.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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

  5. #5
    Join Date
    Jun 2005
    Posts
    115
    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

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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.

  7. #7
    Join Date
    Jun 2005
    Posts
    115
    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

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •