General help

 
 
Capt. Moodle
Windows server: MySQL Administrator and XAMPP on Windows?
Group DevelopersGroup Moodle HQGroup Particularly helpful MoodlersGroup Testers
I was trying to help someone by suggesting that they install MySQL Administrator on a Windows based Moodle server to do backups. They inherited an installation which used XAMPP for the Moodle install. It seems, from what I can tell, that MySQL Administrator is not finding the correct my.cnf file because the user reports being able to login to the database; however, they are not able to control the service despite running on localhost. I was curious if others working with Windows based machines have had a similar experience and what is needed to help MySQL Administrator figure out where things are. The Moodle site seems to work fine, as does phpMyAdmin. Any help or suggestions would be appreciated. Peace - Anthony
 
Average of ratings: -
You either love it or you hate it
Re: Windows server: MySQL Administrator and XAMPP on Windows?
Group Particularly helpful Moodlers
Hi

What where the errors then?

I had problems with MySql administrator and found out that it was McAfee virus scan

Cheers
 
Average of ratings: -
Capt. Moodle
Re: Windows server: MySQL Administrator and XAMPP on Windows?
Group DevelopersGroup Moodle HQGroup Particularly helpful MoodlersGroup Testers
Paul - Thanks for the reply. Exploring McAfee as a possible source of the problem would be interesting. It seemed to me that it was simply not finding or using an incorrect my.cnf file yet it seemed to be attaching to the database. Of course I am going off of what was reported. Perhaps Larry can provide further details. Peace - Anthony
 
Average of ratings: -
Picture of Larry Renfroe
Re: Windows server: MySQL Administrator and XAMPP on Windows?
 

Many thanks to Anthony for his help.  Here is the current problem:

When I start MySQL Administrator-connection user@localhost:3306 I get the following error message:

"Either the server service or the configuration file could not be found. Startup variables and service section are therefore disabled."

Note: MySQL Service shows that it is started when I go under computer management on a Win2003 server (standard edition).

Once I click OK, I get the the administrator panel and the server information is correct. However, the Service Control and Startup Variables are "grayed" out and not available.

Under Catalog I see the Database entries.

Thanks,

Larry

 
Average of ratings: -
Picture of Mark Tailor
Re: Windows server: MySQL Administrator and XAMPP on Windows?
 

My first experience in MySQL administration was really XAMPP. All I needed was imporing and exporting MySQL database (it was sites' creating). Then the number of functions I needed increased and XAMPP couldn't satisfy all ny demands any more. And I found the great software for MySQL management - dbforge Studio for MySQL. It has ALL the functions you ever will need and intuitive and user friendly interface! Free trial available! Try it!

 
Average of ratings: -
Gmads
Re: Windows server: MySQL Administrator and XAMPP on Windows?
Group Particularly helpful MoodlersGroup Testers

Hi Anthony,

In Windows, that file is usually named my.ini.

The admin should use the Windows search box (accesible via the Start menu, or by pressing F3 at the Windows Explorer window --which can be opened with Win-E).

To access the service window, which lists all services installed, press Win-R (this opens the Run dialog box) and then enter: services.msc

The Xampp control panel is usually accessible at the System tray (where the Windows clock is --right, lower corner).

 
Average of ratings: -