Muhamad Yamin wrote:
kalau konfigurasi di phpmyadminnya biasanya di file config.inc.php,
cek user sama password rootnya dah bener blum ? kalau tidak match
biasanya tidak mau masuk ke database.
kalau untuk sekedar adaministrasi atau mengelola MySql mendingan pakai
Navicat aja mas, lebih keren kok tampilannya juga GUI, tinggal
install MySql bawaan DVD.
http://myamin.net/index.php/linux/navicat-tool-administrasi-mysql-di-linux.html
ini linknya semoga bisa membantu.
2008/11/11 Dodo <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
Rindra Iin wrote:
setelah perintah :
grant all privileges on *.* to 'sysadmin'@'localhost' identified by
'password';
enter, lalu ketik ini :
flush privileges;
enter lagi. :)
--- On *Mon, 11/10/08, Dodo /<[EMAIL PROTECTED]>
<mailto:[EMAIL PROTECTED]>/* wrote:
From: Dodo <[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]>
Subject: Re: [*openSUSE-ID*] Help Me...Xampp
To: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>, "Mailing List Komunitas
openSUSE Indonesia" <[email protected]>
<mailto:[email protected]>
Date: Monday, November 10, 2008, 5:08 AM
tambah perintah flush privileges dimana ya
Muhamad Rizal Nurhakim wrote:
ikut nambahin jangan lupa kasih perintah flush
flush privileges;
terima kasih,
::rizal::
#======================================================#
On Monday 10 November 2008 16:31:09 Muhamad Yamin wrote:
update, identidied menjadi identified
grant all privileges on *.* to 'sysadmin'@'localhost' identified by
'password';
harusnya perintah diatas hanya untuk root
2008/11/10 Muhamad Yamin <[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]>
nama usernya sysadmin ? sudah di buat belum user sysadminnnya ? kalau
belum di buat dulu dan beri akses user
grant all privileges on *.* to 'sysadmin'@'localhost' identidied by
'password';
2008/11/10 Dodo <[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]>
kirman wrote:
Kalau tidak salah, user defaultnya adalah root and passwd : [kosong],
bukan sysadmin
Jika mau setting password, saya memiliki pengalaman tentang hal itu,
barangkali kalau berkenan bisa mampir kesini mas
http://kirmann.wordpress.com/2008/03/15/set-password-xampp-di-linux/
2008/11/10 Dodo <[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]>
*Dear All
*Saya mau migrasi database dari WIndows ke Linux deangan Xampp.
Setelah semua terinstall dan saya coba jalankan dengan memasukan
username "sysadmin" tapi tampil message error seperti dibawah ini :*
Warning*: mysql_connect()
[function.mysql-connect<http://192.168.1.3/cpm/function.mysql-connect>]
: Access denied for user 'sysadmin'@'localhost' (using password: YES) in
* /opt/lampp/htdocs/cpm/includes/ConnectDB_mysql.inc* on line *5*
The configuration in the file config.php for the database user name and
password do not provide the information required to connect to the
database server
Kira2 kenapa ya or salah dimana ? Mohon pencerahanya
Terima kasih atas response-nya.
Kalo untuk password itu saya sudah tau, tapi saat saya masuk ke database
user dianggap tidak ada dan tampil message error seperti di atas
------------------------------
_______________________________________________
milis mailing
[EMAIL PROTECTED]://lists.opensuse-id.org/listinfo.cgi <mailto:[EMAIL
PROTECTED]://lists.opensuse-id.org/listinfo.cgi>
/milis-opensuse-id.org <http://milis-opensuse-id.org>
_______________________________________________
milis mailing list
[email protected] <mailto:[email protected]>
http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org
#======================================================#
_______________________________________________
milis mailing list
[email protected] <mailto:[email protected]>
http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org
_______________________________________________
milis mailing list
[email protected] <mailto:[email protected]>
http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org
Kalo setting dengan phpmyadmin-nya gimana ?
------------------------------------------------------------------------
_______________________________________________ milis mailing
list [email protected]
<mailto:[email protected]>
http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org
_______________________________________________
milis mailing list
[email protected] <mailto:[email protected]>
http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org
------------------------------------------------------------------------
_______________________________________________
milis mailing list
[email protected]
http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org
ini saya kutip isi dari file config.php :
#
<?php
$DefaultLanguage ='en_GB';
$allow_demo_mode = false;
$Version = '3.071';
$host = 'localhost';
$dbType = 'mysql';
//$dbType = 'postgres' - DEPRECIATED;
//$dbType = 'mysql';
// sql user & password
$dbuser = 'sysadmin';
$dbpassword = 'sysadmin';
//It would probably be inappropraite to allow selection of the company
in a hosted envionment so this option can be turned off with this parameter
$AllowCompanySelectionBox = true;
//If $AllowCompanySelectionBox = false above then the $DefaultCompany
string is entered in the login screen as a default - otherwise the user
is expected to know the name of the company to log into.
$DefaultCompany = 'CPM';
//The maximum time that a login session can be idle before automatic logout
//time is in seconds 3600 seconds in an hour
$SessionLifeTime = 3600;
//The maximum time that a script can execute for before the web-server
should terminate it
$MaximumExecutionTime =120;
//The path to which session files should be stored in the server -
useful for some multi-host web servers
//this can be left commented out
//$SessionSavePath = '/tmp';
// which encryption function should be used
//$CryptFunction = "md5"; // MD5 Hash
$CryptFunction = "sha1"; // SHA1 Hash
//$CryptFunction = ""; // Plain Text
//Setting to 12 or 24 determines the format of the clock display at the
end of all screens
$DefaultClock = 12;
//$DefaultClock = 24;
// END OF USER CONFIGURABLE VARIABLES
$rootpath = dirname($_SERVER['PHP_SELF']);
if (isset($DirectoryLevelsDeep)){
for ($i=0;$i<$DirectoryLevelsDeep;$i++){
$rootpath = substr($rootpath,0, strrpos($rootpath,'/'));
}
}
if ($rootpath == "/" OR $rootpath == "\\") {
$rootpath = "";
}
//$rootpath = '/EdgeERP';
/* Report all errors except E_NOTICE
This is the default value set in php.ini for most installations but just
to be sure it is forced here
turning on NOTICES destroys things */
error_reporting (E_ALL & ~E_NOTICE);
/*Make sure there is nothing - not even spaces after this last ?> */
?>
#
kira2 salah dimana ya ?
_______________________________________________
milis mailing list
[email protected]
http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org
