up vote 0 down vote favorite
share [g+] share [fb]

i have written a web-framework which extensively uses PHP and MySQL and i would like to install it on my webserver, which i got actually from the university. However, there is an Apache installed but no MySQL server and i am allowed to install one as long as this is done without use of admin priviledges. Can anyone describe, how to install the server (with phpmyadmin), set up the passwords and how to start/stop it via putty?

Thanks in advance. Chris

link|improve this question
I will try it there. Thanks ;) – Christian Ivicevic Apr 5 '11 at 19:40
feedback

migrated from stackoverflow.com Apr 6 '11 at 0:29

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

1 Answer

up vote 1 down vote

Technically you only need root permissions to start items that use a port < 1024. So, the answer is yes.

Now, if you dont have root permissions you can only put it in your home directory which will mean you will find it a big challenge to use a pre made solution so it would be simpler to compile it yourself - download sources from mysql, configure, etc.

phpmyadmin download put in your website off you go

How to start it. Should the server ever restart, as non root you wont be able to put it in the server startup scripts, so could possible do some addition checks in your index.html or such to call a check to process list, if its not in there, start it etc. Again, a bit of a hassle, but there you go.

In the sources is a rc.mysql file (I think its called) it start/stops mysql you may need to tailor it to your given location

link|improve this answer
I have no root access and it should be done everything in my own home dir. Downloading the sources should be no problem, however the configuration is new to me as i have always used xampp on my Windows. Any specific things i need to take "special" care of? – Christian Ivicevic Apr 5 '11 at 19:43
"configure" is actually a command that goes off and checks what it can find.. and generates your make fileIt will tell you if there is something it cant find. – BugFinder Apr 5 '11 at 19:45
Unpack, ./configure, make and then it should work calling mysqld or something like that? – Christian Ivicevic Apr 5 '11 at 19:47
you could probably start it off crontab if you need to start it on boot. – Journeyman Geek Apr 6 '11 at 2:11
feedback

Your Answer

 
or
required, but never shown
discard