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,235 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
[X]
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
  • 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Creating and Managing Databases with phpMyAdmin in cPanel.
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
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…

687 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