remote connection to mysql

raj_55555 · August 22nd, 2010, 10:30 PM

I have followed this book, and found everything step by step for a beginner(not only in mysql

) like me. However the steps to connect to remote databases were not there, I would really like to learn it. Google doesn't help much as the infos are incomplete for a beginner. Mostly I don't understand terms and things like how do I know the name of the server, should mysql be installed on the hosts as well as the server and so on and so forth.

I will happily buy any book you refer to that provides an insight to a beginner like me. Please help. Any step by step references will do.

regards,
raj

om_prakash · August 23rd, 2010, 04:51 AM

Please check the following link to check different options for connecting to mySQL server
http://www.connectionstrings.com/mysql

raj_55555 · August 23rd, 2010, 08:12 AM

Thanks a lot sir for the link.

My problem is that I have no experience at all in network programming. Now if I want to build a database application using C# I am getting choked at some (maybe obvious) areas. Let me give an example:

Code:

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

In this, I dont understand where do I get the serveraddress?

chroniclemaster1 · August 24th, 2010, 12:01 PM

Quote:

Originally Posted by raj_55555

Thanks a lot sir for the link.

My problem is that I have no experience at all in network programming. Now if I want to build a database application using C# I am getting choked at some (maybe obvious) areas. Let me give an example:

Code:

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

In this, I dont understand where do I get the serveraddress?

:) This is a common problem. Working out the the correct parameters for any configuration issues is a *&(%(&^%(*& and DB connection strings can be confusing for exactly these reasons. So don't feel bad. No matter how much experience you get, you (and all the rest of us) will always cringe a little when you need to work with connection strings. The day you don't mind is the day you've become a hardcore DBA / server admin.

server is used in a couple of my connection strings. On my development box where I use VWD's built-in web server to view my sites, the web.config files give the parameter as

server=localhost;

I should note that this is also how the web server displays my website. My root folder for the application is webroot so whenever I access a page in the browser, the address bar reads "http://localhost:1420/webroot/Somepage.aspx".

In the version of the web.config that runs on my production server (I keep both around as WebDev.config and WebProduction.config, and the copy the one I need to Web.config depending on which server I'm on. I find this really easy.), I have server set to the computer name which was provided by my hosting company, it's something like "db42.brinkster.com". I'll note that it was not part of my control panel. While the DB was provided "automatically" as part of my package, I had to call the tech support guys and they turned it on before I could use it (in fact, before the appropriate server name would even display in my control panel). So you may need to call them. This was just one of the many times I've been glad that I called all the tech support lines for the hosting companies I was looking at. After deciding which ones had the features I wanted in the price range I was looking for, I made my final decision based on who had the best tech support... best. decision. ever. :)