*ini message errornya :
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
padahal di windows bisa jalan, kenapa di Linux ga ya ?
Rindra Iin wrote:
bisa paste error nya mas dodo ?
--- On *Tue, 11/11/08, Dodo /<[EMAIL PROTECTED]>/* wrote:
From: Dodo <[EMAIL PROTECTED]>
Subject: Re: [*openSUSE-ID*] Help Me...Xampp
To: "Mailing List Komunitas openSUSE Indonesia"
<[email protected]>
Date: Tuesday, November 11, 2008, 3:03 AM
sama ga bisa juga kenapa ya ?
Muhamad Yamin wrote:
// sql user & password
$dbuser = 'sysadmin';
$dbpassword = 'sysadmin';
coba ganti pake user root dulu sama passwordnya, jangan lupa
disimpan sama di restart XAMMPnya
2008/11/11 Dodo <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>
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]
<mailto:[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] <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
_______________________________________________
milis mailing list
[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
_______________________________________________
milis mailing list
[email protected]
http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org
