reset mysql password dari shell | reset mysql password from shel - Bimo Septyo Prabowo lahir di Jakarta besar di Jakarta

Monday, September 17, 2007

reset mysql password dari shell | reset mysql password from shel

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'
}
?>

4 comments:

Unknown said...

salam kenal juga mas bimo... id yahoo sy dyudho@yahoo.com

Eghy Dot Net said...

salam kenal juga pak. wah, postingannya berat neh :D

Kiyat said...

Tutorial yang bagus bim...

ayoo di tambah koleksinya!

www.starboard.web.id

Gerai Attaqi said...

salam kenal mas bimo, wah bisa belajar nih aku tentang bahasa "gini"an he..he..

http://www.naritha.blogspot.com/