Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Posts
    2

    Post Unanswered: Questions regarding "my.ini" in Windows platform. Pls Advise. Thanks.

    Hi.

    I am new to MySQL. There are some configuration which I still not quite understand.

    I understand that MySQL uses my.ini to store certain configurations.

    Under my.ini, there is this field:
    [WinMySQLadmin]

    Under it, it contains user and password.

    I wish to know what does the user and the password refers to? It does
    not refers to root access to the db server i supposed? What is it for?

    Under [mysqld], there is this port field which is commented out. What does it refers to? Does it refers to the listening port of the DB server?

    Using MySQL on a windows 2000 enviroment.

    Any input appreciated. Thank you.

  2. #2
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697

    Re: Questions regarding "my.ini" in Windows platform. Pls Advise. Thanks.

    Originally posted by newuser
    Hi.

    I am new to MySQL. There are some configuration which I still not quite understand.

    I understand that MySQL uses my.ini to store certain configurations.

    Under my.ini, there is this field:
    [WinMySQLadmin]

    Under it, it contains user and password.

    I wish to know what does the user and the password refers to? It does
    not refers to root access to the db server i supposed? What is it for?

    Under [mysqld], there is this port field which is commented out. What does it refers to? Does it refers to the listening port of the DB server?

    Using MySQL on a windows 2000 enviroment.

    Any input appreciated. Thank you.
    Sorry, MySQL is dead. Especially on Windows 2000. It looks grand on the face of it, but inside none of the configuration variables actually do anything.

  3. #3
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Re: Questions regarding "my.ini" in Windows platform. Pls Advise. Thanks.

    Originally posted by newuser
    Hi.

    I am new to MySQL. There are some configuration which I still not quite understand.

    I understand that MySQL uses my.ini to store certain configurations.

    Under my.ini, there is this field:
    [WinMySQLadmin]

    Under it, it contains user and password.

    I wish to know what does the user and the password refers to? It does
    not refers to root access to the db server i supposed? What is it for?

    Under [mysqld], there is this port field which is commented out. What does it refers to? Does it refers to the listening port of the DB server?

    Using MySQL on a windows 2000 enviroment.

    Any input appreciated. Thank you.
    A valid user name and a valid password (see table user in database mysql)... Basically it is used to know under which user you're going to be logged to MySQL when accessing it with the WinMySQLadmin client.

    For the port, by default MySQL server listens to port 3306 but you can change that if you like to.

    I use MySQL on 4 different platforms and it works great on Windows 2000... I have a few tables of more than 50 million records and +- 70 fields and the server never choked... I am usually using InnoDb table handler and it works great.

    BTW, contrary to what is being said in another post on this thread, MySQL if very alive and well on Windows... More features are being added day after day and more people than ever are using it... especially on Windows...

    Hope this helps

  4. #4
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697

    Re: Questions regarding "my.ini" in Windows platform. Pls Advise. Thanks.

    Originally posted by bstjean
    BTW, contrary to what is being said in another post on this thread, MySQL if very alive and well on Windows... More features are being added day after day and more people than ever are using it... especially on Windows...

    Hope this helps
    My comments were satirical... check this.

  5. #5
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188
    bravo...

    both replied posts are correct. mysql is great
    qha_vn

Posting Permissions

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