shared hosting ?? shared hostingnya itu VPS atau cpanel?
dari pesan errornya sudah dijelaskan bahwa access denied, artinya
usernya tidak diperbolehkan akses.. apa user root sudah di set untuk
boleh login lewat IP publicnya koneksi anda?
next for the sake of security, bukannya lebih baik buat 1 user lain
selain root yg digrant access lewat IP public anda saja?
Ronald "kriwelz" Simanjuntak
Blog : http://blog.kriwelz.web.id
YM : curlyjoe_bug / imkriwelz
FB : [email protected]
Skype,Gtalk: kriwelz
triyanto anto wrote:
saya coba di shared hosting dengan cpanel muncul pesan dibawah :
[Mysql][ODBC 3.51 Driver Acces denied for
user'root'@'202.93.37.84'(using password: YES)
tapi kalo peke script aslinya bisa apa ya yang kurang...?
script contoh bisa dicoba :
remote mysql :
'================================
Private Sub Form_Load()
Dim sql As String
sql = "select * from Users ORDER BY id"
With Adodc1
.ConnectionString = "Driver={MySQL ODBC 3.51
Driver};Server=www.freesql.org;Port=3306;Database=dbobri;User=obri;
Password=emondyhen;Option=3;"
.RecordSource = sql
.Refresh
End With
End Sub
'===================================='
--- On *Tue, 6/8/10, [email protected] /<[email protected]>/* wrote:
From: [email protected] <[email protected]>
Subject: Re: [programmer-vb] cara/coding vb 6 konek dengan
database mysql online...?
To: [email protected]
Date: Tuesday, June 8, 2010, 11:57 PM
tidak bisanya kenapa? ada error message tidak? kalau ada silahkan
disharing.Hostingny a dedicated atau shared ? hostingnya pakai
cpanel atau non-server management ?
kalau dedicated hosting (punya ip public sendiri dan memang
service mysqlnya dibuka untuk public access seharusnya tidak jadi
masalah. Kalau pun jadi masalah kebanyakan karena manajemen hak
user di Mysql (yg bisa terhubung boleh dari IP mana saja bukan
hanya localhost), manajemen firewall dari server tersebut atau
bottleneck di firewall server tersebut.
Lain hal bila hostingnya di cpanel lalu mau konek ke server
tersebut. Kalau ada IP dedicated lebih baik langsung pakai IP
daripada domain name. lalu harus setting lagi remote database
access dll.
mohon CMIIW :)
Ronald "kriwelz" Simanjuntak
Blog : http://blog. kriwelz.web. id
YM : curlyjoe_bug / imkriwelz
FB : kriw...@gmail. com
Skype,Gtalk: kriwelz
triyanto anto wrote:
ku pernah coba coding ini bisa :
Dim sql As String
sql = "select * from Users ORDER BY id"
With ADO
.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};Server=
www.freesql. org;Port= 3306;Database= dbobri;User= obri;
Password=emondyhen; Option=3; "
.RecordSource = sql
.Refresh
Set DataGrid1.DataSourc e = ADO
DataGrid1.Columns( 0).Width = 0
End With
tapi kalo mysql di hosting saya sendiri blum bisa kenapa ya...!
--- On *Tue, 6/8/10, adi.satya.ms@ gmail.com /<adi.satya.ms@
gmail.com>/* wrote:
From: adi.satya.ms@ gmail.com <adi.satya.ms@ gmail.com>
Subject: Re: [programmer- vb] cara/coding vb 6 konek dengan
database mysql online...?
To: programmer-vb@ yahoogroups. com
Date: Tuesday, June 8, 2010, 3:35 AM
Begini, untuk koneksi database ke online pake mysql, trus di
odbc ntar diconverter spy vb6 bs baca. Coba digoogling dl
trus diinstall.
Powered by Telkomsel BlackBerry®
------------------------------------------------------------------------
*From: * Awan Darmawan <c_zabr...@rocketmai l.com>
*Sender: * programmer-vb@ yahoogroups. com
*Date: *Tue, 8 Jun 2010 01:26:03 -0700 (PDT)
*To: *<programmer-vb@ yahoogroups. com>
*ReplyTo: * programmer-vb@ yahoogroups. com
*Subject: *Re: [programmer- vb] cara/coding vb 6 konek dengan
database mysql online...?
Punteun Juragan, Ikutan,
Maksud master adi setya (pake converter ODBC mysql gimana ya)
bisa di perjelas gak juragan..
hatur nuhun lah
____________ _________ _________ _________ _________
_________ _________ _________ _______
Awan Darmawan
Chalosa System Computer (chess.com)
Jl Beringin IV No. 8 Perumnas I Parungpanjang
Bogor - Jawa Barat
Indonesia
Phone : 62-95520485
Mobile: 62-85716437319
------------------------------------------------------------------------
*From:* "adi.satya.ms@ gmail.com" <adi.satya.ms@ gmail.com>
*To:* programmer-vb@ yahoogroups. com
*Sent:* Tue, June 8, 2010 3:17:20 PM
*Subject:* Re: [programmer- vb] cara/coding vb 6 konek dengan
database mysql online...?
Pake odbc converter ke mysql.
Powered by Telkomsel BlackBerry®
------------------------------------------------------------------------
*From: * "Erza" <ri_za...@yahoo. com>
*Sender: * programmer-vb@ yahoogroups. com
*Date: *Tue, 08 Jun 2010 07:59:38 -0000
*To: *<programmer-vb@ yahoogroups. com>
*ReplyTo: * programmer-vb@ yahoogroups. com
*Subject: *[programmer- vb] cara/coding vb 6 konek dengan
database mysql online...?
To : Para Master VB 6
Mohon Pencerahanya Para master vb semuanya...!
Cara koneksi vb ke database mysql online,
maksutnya aplikasi dekstop tapi database onlline bisa dibuka
dimana2...!
