Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
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
Medium Priority
?
1,238 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

610 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