How can you set mysql variables in my.ini

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How can you set mysql variables in my.ini

Postby mydarkpassenger » 04. November 2009 03:34

I'm looking to change the minimum stop words for mysql. This is supposed to be done in my.ini however I change the setting, reset the service and mysql is still reporting the value as 4. Is there some other location I'm supposed to change this other than in the my.ini file in the mysql/bin directory?
mydarkpassenger
 
Posts: 3
Joined: 04. November 2009 03:29

Re: How can you set mysql variables in my.ini

Postby Izzy » 04. November 2009 03:56

mydarkpassenger wrote:...I change the setting, reset the service and mysql is still reporting the value as 4...
Try Stopping then Starting MySQL again as I have no idea what you mean by reset the service.
Last edited by Izzy on 04. November 2009 04:08, edited 1 time in total.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: How can you set mysql variables in my.ini

Postby mydarkpassenger » 04. November 2009 04:07

I've actually restarted my machine since then and no go.
mydarkpassenger
 
Posts: 3
Joined: 04. November 2009 03:29

Re: How can you set mysql variables in my.ini

Postby Izzy » 04. November 2009 04:31

Do you have more my.ini files on your PC other than in the mysql\bin folder, perhaps in the Windows folder?

If so then your XAMPP MySQL instance may be reading the wrong my.ini file.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: How can you set mysql variables in my.ini

Postby mydarkpassenger » 04. November 2009 13:16

Check my Windows directory and nothing. Is there a way to find out what file xampp is trying to use?
mydarkpassenger
 
Posts: 3
Joined: 04. November 2009 03:29

Re: How can you set mysql variables in my.ini

Postby Izzy » 04. November 2009 21:09

mydarkpassenger wrote:...Is there a way to find out what file xampp is trying to use?
Assuming you are using XAMPP 1.7.2 (you have not supplied that detail) in your XAMPP Control Panel (XCP) check if MySQL is running as a Windows NT Service by the tick in the Svc box and the green running indication.

Click on the SCM (Service Control Manager) button.

Look in the list for MySQL.

Right click on the MySQL entry and select Properties

Look for Path to executable, you should see something like this:
"C:\xampp\mysql\bin\mysqld.exe" --defaults-file="C:\xampp\mysql\bin\my.ini" MySQL
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: How can you set mysql variables in my.ini

Postby Wiedmann » 05. November 2009 08:21

This is supposed to be done in my.ini however I change the setting, reset the service and mysql is still reporting the value as 4.

What exactly have you added to the my.ini. And more important: where in the my.ini have you added this?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 47 guests