Page 1 of 1
Installing a complete web server
Posted: Fri Oct 05, 2007 1:58 pm
by legend986
I have access to a Unix machine. But the access is not a root access. I was wondering if I could install apache, php, mysql and others to install on this machine without root access and if yes, how should I got about doing it?
Choose the Right Board
Posted: Fri Oct 05, 2007 2:01 pm
by s.dot
Re: Installing a complete web server
Posted: Fri Oct 05, 2007 7:12 pm
by jeffery
legend986 wrote:I have access to a Unix machine. But the access is not a root access. I was wondering if I could install apache, php, mysql and others to install on this machine without root access and if yes, how should I got about doing it?
I reckon its as simple as asking the system administrator to install them for you.
Posted: Fri Oct 05, 2007 8:42 pm
by legend986
Well I wanted to learn how to do it. Anyways, if anybody knows it please guide me.
Actually I did ask the root to do it and he was kind enough to do it. However I have one small question. I now have mysql installed. How would I install phpMyAdmin? And how would I connect to the databases?
Posted: Fri Oct 05, 2007 8:47 pm
by feyd
I can't suggest installing phpMyAdmin on a production server. I can barely say "it's okay" on a development server. Why? Because it allows you to be lazy and not learn SQL, properly. On a production server it's just another potential security hole you don't really need.
Posted: Fri Oct 05, 2007 10:48 pm
by legend986
Ok I understand you say that for my own good. I will stop using phpmyadmin... Thanks for the suggestion

Posted: Sun Oct 07, 2007 8:12 pm
by Doug G
Hmm, I use phpMyAdmin all the time to administer mysql databases. I don't see any problem with using mysql, unless there are some security holes I'm not aware of. You need some method to administer a mysql db and in a hosted environment that doesn't allow direct mysql connections over the Internet, and you don't have shell access, there aren't that many choices that allow you to administer your db.
Posted: Sun Oct 07, 2007 8:17 pm
by superdezign
Doug G wrote:You need some method to administer a mysql db and in a hosted environment that doesn't allow direct mysql connections over the Internet, and you don't have shell access, there aren't that many choices that allow you to administer your db.
That's the only reason they give you phpMyAdmin. But, when you have the option, it's useless to have. Like feyd says, it makes you lazy and when you really do need to make complex queries, you'll likely be stumped. Secondly, the fact that you have phpMyAdmin means that it can be logged into and the database's contents can be altered, all through a browser.
Posted: Mon Oct 08, 2007 12:49 am
by jmut
So I guess you are suggesting using console instead of phpmyadmin. Problem with console is it is not like unix console, there is no autocomplete and power of it. So most of time I think it is kind of slower than phpmyadmin - although phpmyadm makes tons of useless queries.
Posted: Mon Oct 08, 2007 2:13 am
by CoderGoblin
Can't say I use phpmyadmin as I tend to mainly use postgres. I find using the console far quicker normally than any other "interface". Are you sure there are no options to enable you to use autocomplete on a console. ?
Posted: Mon Oct 08, 2007 7:11 pm
by feyd
jmut wrote:So I guess you are suggesting using console instead of phpmyadmin. Problem with console is it is not like unix console, there is no autocomplete and power of it. So most of time I think it is kind of slower than phpmyadmin - although phpmyadm makes tons of useless queries.
Actually there is autocomplete in at least the newest client provided by the basic install of mysql.
Posted: Mon Oct 08, 2007 8:01 pm
by Doug G
That's the only reason they give you phpMyAdmin. But, when you have the option, it's useless to have. Like feyd says, it makes you lazy and when you really do need to make complex queries, you'll likely be stumped.
Well, I don't agree, but each to their own
