MySql new installation: choosing conf file.

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
hairyjim
Forum Contributor
Posts: 219
Joined: Wed Nov 13, 2002 9:04 am
Location: Warwickshire, UK

MySql new installation: choosing conf file.

Post by hairyjim »

Hi gys,

I am trying to get MySql running. There seems to be a fair bit of config work on Windows.

My Q is regarding the 4 different conf files they have suggested to use and place one in the c:\ directory called my.conf

Has anyone got any particular suggestions which I should consider in choosing the right conf file to use? I'm very new to MySQL and PHP so some advice would be great.

Cheers
Jim
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Have you put MySQL in a folder other than it's default? If you haven't you don't have to worry about the cnf file.

Mac
hairyjim
Forum Contributor
Posts: 219
Joined: Wed Nov 13, 2002 9:04 am
Location: Warwickshire, UK

Post by hairyjim »

No I have not.

This is all too confusing.

Do you know of any tutorials on installing/configuring + creating my first db plus accessing through PHP?

*I think my brain peaked yesterday*

Cheers
Jim
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

IIRC, if you have put the installation somewhere different all you need is a my.cnf (put in your root drive - c:\) or a my.ini (in the WINNT/WINDOWS folder) containing the following:

Code: Select all

# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = C:/mysql-location/
datadir = C:/mysql-location/data/
Mac
Post Reply