You don't need tightvnc to use ubuntu: just putty:
- you are telling that you can conect to the ubuntu server via putty so that's ok.
- You can use mysql with comand line
- apache is also used with comand line
To have in mid: know that you can control apache and mysql to work this way (remember as root:
service <apache2ormysql> stop/start/restart/status
first install mysql as root.
apt-get install mysql
In the middle of the instalation a password for the root of mysql will be ask to you.
the you just login to your mysql:
:~$ mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 34
Server version: 5.1.58-1ubuntu1 (Ubuntu)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
if you do sudo -i you whon't need to use the -u root part
the to use mysql just read the manual:
To a web application use apache, and php
apt-get install apache2
apt-get install php5
for now I will tell those two maybe you will need more things (like a conector to php-apache2 or stuff like these).
the configuration of php you will need to edit like root (
:~# vi /etc/php5/apache2/php.ini
and all the apache2 config is in
/etc/apache2/, and your site will be deplayed here
read the respective manual to do what you need.
also make firend of vi or nano... they are usefull
this lecture could be more helpful: https://help.ubuntu.com/community/ApacheMySQLPHP
note: if you need more help or how to set it up... just