Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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,241 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
3 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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
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.
Suggested Courses

578 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