Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

How to work MySQL Install on XP Pro from XAMPP and with no admin rights - move my.ini?

Posted on 2008-06-09
4
1,233 Views
Last Modified: 2013-12-13
Hi all - trying to get mediawiki running on xp pro, non-admin account, using xampp 1.6.6a.  

install seemed to go fine to c:\xampp\apache etc, and apache & php seem to be working great, but for mysql, only see mysqld.exe in processes, and can't net start or reach mysql.  oh and because i'm not admin on this box, no my.ini installed in c:\windows.  

Is there a way to set up mysql to run without admin rights?  worst case that's fine if it only runs while i'm logged in.  Been trying to read on creating my.ini, but always seems to locate in windows or progfiles dir, and can't write to either of those.

thanks for any direction!

wes
0
Comment
Question by:new_wes
  • 3
4 Comments
 

Author Comment

by:new_wes
ID: 21746396
also, XAMPP control panel shows MySQL service running, but WinMySQLadminv1.4 shows no MyODBC driver or other info (so StartCheck shows no my.ini file)
0
 

Accepted Solution

by:
new_wes earned 0 total points
ID: 21762227
okay got this worked out and seems to be pretty stable:

INSTALLING MEDIAWIKI (XAMPP PKG) ONTO XP PRO SP2 WITH NO ADMIN RIGHTS

not appropriate for internet, but fine for lan or standalone.

starting and stopping are only manual, but as long as logged in, works great for all users.

INSTALL:
1. XAMPP 1.6.6a http://www.apachefriends.org/en/xampp-windows.html 
2. Method A install to c:\xampp
3. Start apache and mysql services from XAMPP control panel
4. Security
4a XAMPP: Run http://localhost/security/index.php (pwds)
4ai. MySQL: u: root p: sandwich
4aii. XAMPP: u: admin p: sandwich
4b. Apache:
4bi. open diskw\usr\local\Apache2\conf\httpd.conf
4bii. search for "Listen 80"
4biii. change it to "Listen 127.0.0.1:80"
4biv. search for "Controls who can get stuff from this server"
4bv set to restrict IP as necessary:
4bv1 Allow from all
4bv2 Allow from 127.0.0.1
4bv3 Allow from 123.255.124.19
4bv4 Allow from 123.255.124.12
4bv5 Allow from 123.255  (allows all thru 123.255.255.255)
4bvi. change err response by adding
4bvi1. ServerSignature Off
4bvi2. ServerTokens Prod
4c. MySQL:
4ci. open diskw\usr\local\mysql\bin\my.cnf
4cii. search for "[mysqld]"
4ciii. insert "[mysqld]" and type this text onto that line: bind-address=127.0.0.1
5. Open http://localhost/wiki/config/index.php
5a. Name uhu: UhUbaby
5b. Admin: AdminName
5c. P: adminpass
5d. disable all email options
5e. db: uhudb
5f. dbu: username
5g. dbp: password
5h. put in root user p for perms
5i. run
5i1. success should give "move localsettings.php" etc.
5i2. fail: delete htdocs\uhui\config\localsettings.php and try again.
6. nav to http://localhost/uhu/index.php
7. game on
0
 

Author Comment

by:new_wes
ID: 21771926
main concern was IPs - thanks!!
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This article discusses how to create an extensible mechanism for linked drop downs.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question