// 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]> > 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]> > >> 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]><[EMAIL PROTECTED]> >> * wrote: >> >> From: Dodo <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> >> Subject: Re: [*openSUSE-ID*] Help Me...Xampp >> To: [EMAIL PROTECTED], "Mailing List Komunitas openSUSE Indonesia" >> <[email protected]> <[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]> <[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]> <[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]> <[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> >> <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 [EMAIL PROTECTED]://lists.opensuse-id.org/listinfo.cgi >> /milis-opensuse-id.org >> >> >> >> _______________________________________________ >> milis mailing [EMAIL >> PROTECTED]://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org >> >> #======================================================# >> _______________________________________________ >> milis mailing [EMAIL >> PROTECTED]://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org >> >> >> _______________________________________________ >> milis mailing [EMAIL >> PROTECTED]://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org >> >> >> Kalo setting dengan phpmyadmin-nya gimana ? >> ------------------------------ >> >> _______________________________________________ >> milis mailing [EMAIL >> PROTECTED]://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 [EMAIL > PROTECTED]://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 > >
_______________________________________________ milis mailing list [email protected] http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org
