Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I need to install MySQL on Windows XP. But looks like both .msi and and .zip versions require Windows admin rights to get database working. Is there any way possible to install MySQL without windows admin rights? If not, is there any database that doesn't require installation(NOT an in memory database)?

share|improve this question

migrated from stackoverflow.com Mar 15 '11 at 10:44

This question came from our site for professional and enthusiast programmers.

    
EasyPHP comes with it all. –  Steven Hammons Mar 15 '11 at 8:02
    
personally i'd install WAMP as i like an easy life although you will need admin rights for this too - wampserver.com/en –  f00 Mar 15 '11 at 9:15
    
@f00, I had never heard of WAMPServer; when I saw your comment, I automatically thought you said XAMPP, until I saw the page. >.< –  Synetech Mar 17 '11 at 19:15

3 Answers 3

up vote 1 down vote accepted

Zip does not require any administrative rights, if you do not run database as a service. you can run it from the command line, , e.g with

bin\mysqld --console

after unpacking the zip.

share|improve this answer
    
Agreed. Only installing requires admin rights because it gets installed and run as a service. You can still run the daemon like any other background program without admin rights. (Though whether it can act as a server, open and listen on a port, and receive data without admin rights is another matter. It may work, but I for one haven’t tried it… though I’d be interested in hearing if it does.) –  Synetech Mar 17 '11 at 19:09
    
It can act as server, and open and listen to port, even if user running it is not administrator. Whether or not one can connect to this port from another machine, is subject of firewall rules (and also mysql's own authentication rules) –  Vladislav Vaintroub Mar 18 '11 at 18:59
  • MySQL is installed to run as Windows Service so you need Admin rights or rights to install services on your computer.
  • You can try SQLite is a file based Database.
share|improve this answer

I don't think you can get away with installing MySQL without admin rights, because it's a service.

If you can't get around that, give SQLite a try. It's file-based, can be just unzipped to any directory and drivers exist for most languages.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.