 |
How To Get My Mysql Database's Ip Address Or Hostname? |
 |
Member Login
Welcome
Welcome to the Zymic webmaster forums. Our forums are here to provide people the free ability to discuss a range of websites related topics such as design, development coding and marketing.
In order to post you will need to register for a zymic account or if you already have one simply login by using the form on the left.
 |
Zymic Webmaster Forums Zymic Free Web HostingDatabases & MySQL |
 |
  |
 Apr 19 2012, 06:49 AM
Post
#1
|
|
|
Newbie  Group: Members Posts: 1 Joined: 17-April 12 Member No.: 238,236  |
Now I had setup a PHP forum. I need to transfer an old forum which is driven by ASP + Access database.
There is no tool for me to transfer data from the two different database. So I want use Navicat (a MySQL database management tool) to import the old data to the new database on zymic. But as we know, I can only know my MySQL address is "Localhost", the Navicat need a true hostname or IP address to link the database. How could I know my zymic MySQL database's IP address? 
|
 |
 
|
|
Apr 19 2012, 03:24 PM
Post
#2
|
|
 THE SILENT FORUM NINJA Group: Administrators Posts: 3,706 Joined: 23-January 10 From: on your screen Member No.: 127,507 |
we dont allow remote connections to our database so Navicat wont be able to connect to our server at all
|
|
|
|
|
Jul 23 2012, 07:19 PM
Post
#3
|
|
|
Newbie Group: Members Posts: 1 Joined: 23-July 12 Member No.: 250,173 |
QUOTE(ssfdre38 @ Apr 19 2012, 03:24 PM)  we dont allow remote connections to our database so Navicat wont be able to connect to our server at all Hello I am using vb.net 2005 with reference MySQL Connector Net 6.1.6 I am making application to select or insert data to my database. I have a connection problem, when I try to open connection to my database I get following error: "Unable to connect to any of the specified MySQL hosts." Connection string I am using look like this: "Data Source=MyServerName;Database=MyDatabaseName;Uid=MyUserName;Pwd=MyPassword" Part of thr code looks like this: Dim query As String = "SELECT * FROM Table" Dim connection As New MySqlConnection("Data Source=MyServerName;Database=MyDatabaseName;Uid=MyUserName;Pwd=MyPassword") If Not connection.State = ConnectionState.Open Then connection.Open() End If Is there even possible to connect to zymic mysql database with vb.net application? Thanks. |
|
|
|
|
Jul 23 2012, 07:36 PM
Post
#4
|
|
|
THE SILENT FORUM NINJA Group: Administrators Posts: 3,706 Joined: 23-January 10 From: on your screen Member No.: 127,507 |
we are not a vb host and again we do not allow remote connections to our database
|
|
|
|
|
Aug 9 2012, 09:36 AM
Post
#5
|
|
|
Newbie Group: Members Posts: 9 Joined: 17-July 12 Member No.: 249,426 |
QUOTE(Manuel0803 @ Jul 23 2012, 07:19 PM) Hello I am using vb.net 2005 with reference MySQL Connector Net 6.1.6 I am making application to select or insert data to my database. I have a connection problem, when I try to open connection to my database I get following error: "Unable to connect to any of the specified MySQL hosts." Connection string I am using look like this: "Data Source=MyServerName;Database=MyDatabaseName;Uid=MyUserName;Pwd=MyPassword" Part of thr code looks like this: Dim query As String = "SELECT * FROM Table" Dim connection As New MySqlConnection("Data Source=MyServerName;Database=MyDatabaseName;Uid=MyUserName;Pwd=MyPassword") If Not connection.State = ConnectionState.Open Then connection.Open() End If Is there even possible to connect to zymic mysql database with vb.net application? Thanks. How could we solve with out knowing the host name? and not using localhost! |
|
|
|
|
Aug 9 2012, 04:48 PM
Post
#6
|
|
|
THE SILENT FORUM NINJA Group: Administrators Posts: 3,706 Joined: 23-January 10 From: on your screen Member No.: 127,507 |
the only hostname that is for MySQL on Zymic is localhost
|
|
|
|
| |
|
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users) |
|
| 0 Members: | ||
|
Forum Jump |
|
| Lo-Fi Version | Time is now: 23rd May 2013 - 01:22 AM |