Follow us on...
Follow us on Twitter Follow us on Facebook
Register
Page 1 of 2 12 LastLast
Results 1 to 8 of 13
  1. #1
    bunner bob is offline Registered User
    Join Date
    Nov 2003
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Server 10.4 - where is mysql .ini file?

    I can't seem to find the mysql .ini file in Tiger server. I believe it's called something like my.ini.

    Any idea what the path is?

    - Bob

  2. #2
    Emerrill is offline Registered User
    Join Date
    Sep 2001
    Location
    Houghton, MI
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You need to create /etc/my.cnf

    -eric

  3. #3
    bunner bob is offline Registered User
    Join Date
    Nov 2003
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Really - so it doesn't exist from the get-go? I find that hard to believe - there must be quite a few initialization parameters already set up in a config file somewhere.

    I say this after reading this
    http://www.openwin.org/mike/faq/faq....col-requested/
    - according to the information on this site, I ned to add a line in the [mysqld] section of my configuration file. Meaning this section (and thus the file) should already exist.

  4. #4
    Emerrill is offline Registered User
    Join Date
    Sep 2001
    Location
    Houghton, MI
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I created the file, and the locate (locate .ini, locate .cnf) command indicates the file doesn't exist by default. Here is mine for example:

    [mysqld]
    socket=/tmp/mysql.sock

    #Use old password encryption method (needed for 4.0 and older clients).
    old_passwords

  5. #5
    bunner bob is offline Registered User
    Join Date
    Nov 2003
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hey, that locate command is cool!

    So, does MySql just know to look in /etc/ for a file called my.cfg?

  6. #6
    Emerrill is offline Registered User
    Join Date
    Sep 2001
    Location
    Houghton, MI
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yup. Just edit it and restart mysql

    -eric

  7. #7
    philaweb is offline Registered User
    Join Date
    Sep 2005
    Location
    Copenhagen, Denmark, Europe
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Emerrill
    Yup. Just edit it and restart mysql
    I am having the exact same problem.

    But... On top of that I am also having problems editing a "my.cfg" file.

    What should this file contain?

    How do I save it within the /etc/ system folder?

    I have tried to save it with JEdit, which is denied access to that folder.

    Anyone with a solution on how I can get MySQL up and running with some sort of interface so I can import databases?
    Last edited by philaweb; September 14th, 2005 at 01:43 PM.

  8. #8
    Emerrill is offline Registered User
    Join Date
    Sep 2001
    Location
    Houghton, MI
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by philaweb
    I am having the exact same problem.

    But... On top of that I am also having problems editing a "my.cfg" file.

    What should this file contain?

    How do I save it within the /etc/ system folder?

    I have tried to save it with JEdit, which is denied access to that folder.

    Anyone with a solution on how I can get MySQL up and running with some sort of interface so I can import databases?

    You want phpMyAdmin for the interface. Just download it, unpack it, and put it in /Lib/WebServer/Docs/.

    To edit the ini file, you need to use the terminal, or some gui that can run as root. From the terminal you can use 'sudo pico /etc/my.ini'

    -eric

 

 
Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

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