August 18th, 2005, 11:27 PM #1
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?
August 21st, 2005, 04:02 PM #2
You need to create /etc/my.cnf
August 21st, 2005, 04:51 PM #3
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
- 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.
August 21st, 2005, 05:38 PM #4
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:
#Use old password encryption method (needed for 4.0 and older clients).
August 21st, 2005, 06:16 PM #5
Hey, that locate command is cool!
So, does MySql just know to look in /etc/ for a file called my.cfg?
August 21st, 2005, 06:32 PM #6
Yup. Just edit it and restart mysql
September 14th, 2005, 02:37 PM #7
I am having the exact same problem.
Originally Posted by Emerrill
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 02:43 PM.
September 14th, 2005, 03:17 PM #8
Originally Posted by philaweb
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'