Ketika mencoba cms berbasis joomla tidak bisa buka koneksi mysql ternyata terjadi kesalahan terhadap password root maka untuk menghapus password root menjadi kosong yaitu:
When i try cms base on joomla , after i had installed . its appear statement like this "Could not connect to the database server" so i reset mysql password became empty , its work:
#select * from mysql.user
#update mysql.user set host='localhost', User='root' ,Password='root' ,Password=Password('')
where Host='localhost' and User='root'
#update mysql.db set host='localhost' ,User='root' where host='localhost' and User='root';
#update mysql.tables_priv set host='localhost', User='root' where host='localhost' and
User='root';
#update mysql.columns_priv set host='localhost' ,User='root' where host='localhost' and
User='root';
#flush privileges
Selain itu dari sisi Joomlanya kita harus mencheck apakah koneksi antara mysql dengan joomla berjalan lancar buat file testjoomla.php yang di simpan dalam direktory joomla ....
Beside giving attention for database, we must have check that connection between mysql and joomla work together so make file that detect connection then save a file testjoomla.php:
include_once('configuration.php');
$link = @mysql_connect($mosConfig_host, $mosConfig_user,$mosConfig_password);
if (!$link)
{
print('Could not connect'.mysql_error());
}
else
{
print 'Connected successfully'
}
?>
Subscribe to:
Post Comments (Atom)
4 comments:
salam kenal juga mas bimo... id yahoo sy dyudho@yahoo.com
salam kenal juga pak. wah, postingannya berat neh :D
Tutorial yang bagus bim...
ayoo di tambah koleksinya!
www.starboard.web.id
salam kenal mas bimo, wah bisa belajar nih aku tentang bahasa "gini"an he..he..
http://www.naritha.blogspot.com/
Post a Comment