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,230 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
Comment Utility
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
Comment Utility
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
Comment Utility
main concern was IPs - thanks!!
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

728 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now