Finally I found out that Webmin has a section where you can install the software packages. I tried it and force it to over-write all existing software old version when upgrading. Seems like all the php, php-mysql, mysql-server, mysql-develop, mysql-shared, etc have successfully installed.
Now I am only facing with one last problem. That is getting mysql to work with my existing database. I can't seem to get it to work with username [mysql].
I had tried all these commands to change the password, given all the permissions [user, table] and yet still unable to work.
These are the commands I had tried:
mysql_safe --skip-grant-tables & [this is ok]
mysqladmin -u root password 'newpassword' [can't work]
killall mysqld [this is ok]
mysql-permission -u root [can't work]
mysql -u root -p [this is ok]
I have already created a user [mysql] and using the Webmin, I have created this user [mysql] to have all the permissions and rights for the database. How can I add this user to be the one accessing the database with a password instead of the root currently accessing without any password. I have tried the module config in Webmin using mysql as the username, it can login without password. But my php still can't work. I have checked with phpinfo.php, everything is displayed and seems to work for php.
Please advice if you can help. I am greatly appreciated!