Untuk penyelesaian masalah apabila sempat kelupaan password root pada MySQL server dengan sistem operasi Linux Ubuntu atau Debian bisa digunakan perintah berikut:
sudo /etc/init.d/mysql stop
sudo mysqld –skip-grant-tables
mysql -u root mysql
UPDATE user SET Password=PASSWORD(’Password_Baru’) WHERE User=’root’;
FLUSH PRIVILEGES;
exit;
Dewasa ini, browser seperti Opera 9, Firefox 1.5, IE 6 sudah mendukung pengiriman data terkompresi (compressed). Gunanya adalah untuk mempercepat pengiriman data dari web erver ke browser. Biasanya kompresi yang digunakan adalah gzip. Kompresi ini tidak disarankan untuk developer ketika membuka websitenya dari local area network, karena speed di dalam LAN itu sendiri sangat cepat, sehingga dengan di tambahkannya kompresi di server dan dekompresi di bagian client, akan membuat proses sedikit lebih lambat. Tetapi hal ini jika digunakan untuk transfer data antar internet (bahkan dengan koneksi fiber optic sekalipun) akan membuat koneksi lebih cepat sekitar 10 - 30 persen.
Before downloading Webmin, you must already have Perl 5 installed on your system. Perl is usually installed as /usr/local/bin/perl or /usr/bin/perl, and comes as part of most recent versions of Linux. If you don’t have Perl, you can download the source from http://www.perl.com/ and compile it for your system. Most operating systems come with Perl these days, so check your operating system CD or website for a package as well.
If you are using the DEB version of webmin, first download the file and then run the command :
dpkg –install webmin_1.390_all.deb
The install will be done automatically to /usr/share/webmin, the administration username set to root and the password to your current root password. You should now be able to login to Webmin at the URL http://localhost:10000/ .
Installing mysql database server is always necessary if you are running a database driven ecommerce site. Remember running mysql server to a fair extend requires atleast 256mb of RAM in your server. So unless you are running database driven sites you dont absolutely need mysql. The following commands will install mysql 5 server and mysql 5 client.
apt-get install mysql-server mysql-client php5-mysql
Note: If you have already installed php4, you should make a slight change like this.
apt-get install mysql-server mysql-client php4-mysql
The configuration file of mysql is located at: /etc/mysql/my.cnf
By default mysql creates user as root and runs with no passport. You might need to change the root password.
To change Root Password
mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD(’new-password’) WHERE user=’root’;
mysql> FLUSH PRIVILEGES;
To Create User
You must never use root password, so you might need to create a user to connect to mysql database for a PHP script. Alternatively you can add users to mysql database by using a control panel like webmin or phpMyAdmin to easily create or assign database permission to users.
Apache is one of the most famous web server which runs on most linux based servers. With just few commands you can configure apache to run with PHP 4 or PHP 5.
If you want to install PHP 4, just apt-get
apt-get install apache2 php4 libapache2-mod-php4
Description
To run multiple websites under Apache on a machine having single IP either loopback 127.0.0.1 or other
Tujuan perkuliahan:
Materi perkuliahan:
Penilaian:
Prasyarat:
Referensi:
Tujuan perkuliahan:
Materi perkuliahan:
Penilaian:
Prasyarat:
Referensi:
Tujuan perkuliahan:
Materi perkuliahan:
Penilaian:
Referensi:
Materi Kuliah dapat dilihat pada alamat http://ilearn.unand.ac.id/pemrograman.
