. # mkdir /downloads/
. cd /downloads/
. # ftp 192.168.20.151
. ftp> bin
. ftp> get MySQL-server-4.1.11-0.i386.rpm
. ftp> get MySQL-client-4.1.11-0.i386.rpm
. ftp> get MySQL-devel-4.1.11-0.i386.rpm
. ftp> get MySQL-shared-compat-4.1.22-0.rhel3.i386.rpm
. ftp> bye
. # rpm -qa | grep mysql
. # rpm -e –nodeps mysql-3.23.58-1
. # rpm -ivh MySQL-server-4.1.11-0.i386.rpm
. # rpm -ivh MySQL-client-4.1.11-0.i386.rpm
. # rpm -ivh MySQL-devel-4.1.11-0.i386.rpm
. # rpm -ivh MySQL-shared-compat-4.1.22-0.rhel3.i386.rpm
. # mysql -u root
. mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root’@'localhost’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
. mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root’@'%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
. mysql> SET PASSWORD FOR ‘root’@'localhost’ = OLD_PASSWORD(’password’);
. mysql> SET PASSWORD FOR ‘root’@'%’ = OLD_PASSWORD(’password’);
. mysql> \q
. # /sbin/service mysql restart
. # /sbin/service httpd restart
. cek phpinfo(); cek apakah modul mysql masih terload
. # vi /var/www/html/konek.php
< ?php
$link = mysql_connect("localhost", "root", "password") or die("Could not connect: " . mysql_error());
mysql_select_db("mysql", $link);
$result = mysql_query("select host,user from user");
while($row = mysql_fetch_array($result,MYSQL_NUM)){
print $row[0]."---".$row[1];
}
mysql_free_result($result);
mysql_close($link);
?>
. http://localhost/konek.php –> cek bisa nggak
. restart server
