| Author |
Message |
imunk |
| Location: |
|
Post subject: Error Myql 5.0
 Posted: 21/Dec/2005 08:40
|
|
onUber-Skilled
Joined: 28-Mar-2005
Posts: 451
Status: Offline
|
|
dear pakar mysql.....
langsung aja, kmrn aku install mysql 5.0 secara default pengintsallan, aku gak ngerubah sedikitpun pilihan yg ada, pokoke default abis deh.....
o iya password root aku isi (kalo gak kosong tombol next nya gak mau idup sih... )
sukses dan siap dicoba.....
aku pake mysqlfront 2.4 utk mencoba koneksi
walhasil.........
muncul error kayak gini:
kira2 arti dan solusinya gimana ya??
atas solusi dan penjelasnnya makasih banyak2 deh.... |
|
|
| |
|
|
|
 |
|
LuriDarmawan |
| Location: here |
|
|
Post subject:
Posted: 21/Dec/2005 10:16
|
|
onApaAdanya
Joined: 15-Mar-2005
Posts: 1617
Location: here
|
|
|
|
|
|
|
imunk |
| Location: |
|
|
Post subject:
Posted: 21/Dec/2005 10:22
|
|
onUber-Skilled
Joined: 28-Mar-2005
Posts: 451
Status: Offline
|
|
masa sih mas luri gak liat tuh mysql-error.......
tak tulis wae lah....
mysql-error:
Quote:
connection filed:
1251 - client does not support authentication protocol requested by
server; consider upgrading mysql client.
|
|
|
| |
|
|
|
|
|
deLogic |
| Location: Jakarta |
|
|
Post subject:
Posted: 21/Dec/2005 10:24
|
|
onMage
Joined: 04-Jul-2005
Posts: 2282
Location: Jakarta
|
|
| mungkin maksudnya bung luri, error yg dialami bung imunk gak dialami oleh bung luri, alias lancar2 aja.... |
_________________
.:: Lagi gak pengen pasang signature ::.
|
| |
|
|
|
|
|
LuriDarmawan |
| Location: here |
|
|
Post subject:
Posted: 21/Dec/2005 10:47
|
|
onApaAdanya
Joined: 15-Mar-2005
Posts: 1617
Location: here
|
|
|
|
|
|
|
masdi2t |
| Location: |
|
|
Post subject:
Posted: 21/Dec/2005 11:01
|
|
onKnowledgeable
Joined: 13-Dec-2005
Posts: 133
Status: Offline
|
|
pro mas imunk:
hal tersebut terjadi karena perbedaan metode hashing yang dipake dalam enkripsi password mas.
solusi:
buka console trus pada console mysql tulis berikut:
Quote:
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
misal
Quote:
mysql> SET PASSWORD FOR
-> 'root'@'localhost' = OLD_PASSWORD('passwdroot');
untuk lebih jelasnya kunjungi situs ini (ngk pake tiket masuk kok)
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
semoga membantu[/quote] |
|
|
| |
|
|
|
|
|
LuriDarmawan |
| Location: here |
|
|
Post subject:
Posted: 21/Dec/2005 11:02
|
|
onApaAdanya
Joined: 15-Mar-2005
Posts: 1617
Location: here
|
|
|
|
|
|
|
cyber_hecker |
| Location: Ponti Hot City |
|
|
Post subject:
Posted: 21/Dec/2005 11:02
|
|
onProfessional
Joined: 19-May-2005
Posts: 981
Location: Ponti Hot City
Status: Offline
|
|
tutorial part 1 - mySQL 5.0 error
hemm.... coba pake command prompt untuk koneksi ke mySQL-nya, bisa enggak ?
1. dari menu START > PROGRAMS > MYSQL > MYSQL SERVER 5.0 > MySQL Command Line Client
2. muncul window command, dengan tulisan enter password :
3. isikan password ada, lalu tekan [ENTER]
4. bila password benar, maka akan tampil sql prompt.
5. bila langkah tersebut berhasil, kita akan lanjutkan lagi part 2. tapi kalo enggak - berarti ada kesalahan pada waktu menginstall mySQL nya 
to be continued ... |
_________________
|
| |
|
|
|
|
|
deLogic |
| Location: Jakarta |
|
|
Post subject:
Posted: 21/Dec/2005 11:10
|
|
onMage
Joined: 04-Jul-2005
Posts: 2282
Location: Jakarta
|
|
| kemungkinan besar sih karena inkompatibilitas hashing seperti yg udah dipost oleh bung masdi2t, dulu saya pernah mengalaminya dengan front-end phpmyadmin. |
_________________
.:: Lagi gak pengen pasang signature ::.
|
| |
|
|
|
|
|
kaka-delphi |
| Location: Taziex |
|
|
Post subject:
Posted: 21/Dec/2005 11:52
|
|
onElite
Joined: 12-Oct-2005
Posts: 1050
Location: Taziex
|
|
Numpang lewat ..... 
Quote:
1251 - client does not support authentication protocol requested by
server; consider upgrading mysql client.
Setelah baca di help MySQL, kemungkinan error tersebut berasal dari client nya alias kemungkinan besarnya dari tool MySQL Front. Saya pake phpmyadmin, Zeos nyantai aja tuch !
Coba pake tool yang laen gimana, apakah masih sama ?
CMIIW |
|
|
| |
|
|
|
|
|
imunk |
| Location: |
|
|
Post subject:
Posted: 21/Dec/2005 12:23
|
|
onUber-Skilled
Joined: 28-Mar-2005
Posts: 451
Status: Offline
|
|
@semua
thanks bangt sekarang dah bisa, usernya cuma atu ya.... |
|
|
| |
|
|
|
|
|
kaka-delphi |
| Location: Taziex |
|
|
Post subject:
Posted: 21/Dec/2005 12:47
|
|
onElite
Joined: 12-Oct-2005
Posts: 1050
Location: Taziex
|
|
| Waaaahhhhh.............. Syukur dech |
|
|
| |
|
|
|
|
|
imunk |
| Location: |
|
|
Post subject:
Posted: 21/Dec/2005 13:10
|
|
onUber-Skilled
Joined: 28-Mar-2005
Posts: 451
Status: Offline
|
|
tapi.........
ada error nih mas saat aku tambah user baru dgn host '%'. nih errornya:
terus kucoba isi ssl_type-nya dgn 'Y' eh malah error lagi :
aku coba ganti yg laennya eh error juga:
jd pusing aku, kok beda banget sih dgn versi sblmnya.......
ada yg bisa bantu gak tuk selesain masalahku ini, please deh....
atau caraku salah, kalo gitu yg benar gimanaaaa....... |
|
|
| |
|
|
|
|
|
grounders |
| Location: |
|
|
Post subject:
Posted: 21/Dec/2005 15:04
|
|
onKnowledgeable
Joined: 11-Jul-2005
Posts: 159
Status: Offline
|
|
| Saranku coba pake EMS, tapi situsnya lupa ik... coba pake om google.... ada yang versi freenya and mempunyai fungsi yg bagus... And kalo mo tambah user lewat fungsi add user aja ato kalo gak pake query aja, soalnya di mysql v4.1 keatas terdapat perbedaan dengan versi sebelumnya... |
|
|
| |
|
|
|
|
|
imunk |
| Location: |
|
|
Post subject:
Posted: 21/Dec/2005 15:41
|
|
onUber-Skilled
Joined: 28-Mar-2005
Posts: 451
Status: Offline
|
|
thanks informasinya, pake query sdh kucoba tapi tetep gak mau juga, error yg muncul mirip error yg ketiga, katanya : ssl_chipper gak boleh nul.
emang harus diisi apa yah..... |
|
|
| |
|
|
|
|
|
|
