Server 10.4 - where is mysql .ini file?

[bunner bob]

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

[Emerrill]

You need to create /etc/my.cnf

-eric

[bunner bob]

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.

[Emerrill]

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

[bunner bob]

Hey, that locate command is cool!

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

[Emerrill]

Yup. Just edit it and restart mysql

-eric

[philaweb]

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?

[Emerrill]

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