Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > PHP/MySQL > BOOK: Beginning MySQL
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning MySQL
This is the forum to discuss the Wrox book Beginning MySQL by Robert Sheldon, Geoff Moes; ISBN: 9780764579509
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning MySQL section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old August 22nd, 2010, 10:30 PM
Registered User
 
Join Date: Aug 2010
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default remote connection to mysql

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
Reply With Quote
  #2 (permalink)  
Old August 23rd, 2010, 04:51 AM
Friend of Wrox
Points: 2,473, Level: 20
Points: 2,473, Level: 20 Points: 2,473, Level: 20 Points: 2,473, Level: 20
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2004
Location: India
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
Default

Please check the following link to check different options for connecting to mySQL server
http://www.connectionstrings.com/mysql
__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.
Reply With Quote
The Following User Says Thank You to om_prakash For This Useful Post:
raj_55555 (August 23rd, 2010)
  #3 (permalink)  
Old August 23rd, 2010, 08:12 AM
Registered User
 
Join Date: Aug 2010
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default

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?
Reply With Quote
  #4 (permalink)  
Old August 24th, 2010, 12:01 PM
Friend of Wrox
Points: 1,749, Level: 16
Points: 1,749, Level: 16 Points: 1,749, Level: 16 Points: 1,749, Level: 16
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2007
Location: San Diego, CA, USA.
Posts: 477
Thanks: 10
Thanked 19 Times in 18 Posts
Default

Quote:
Originally Posted by raj_55555 View Post
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. :)
__________________
-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Remote Connection Error hbansal ASP.NET 2.0 Basics 1 April 11th, 2009 01:06 PM
SQL remote connection gcharri SQL Server 2000 0 March 26th, 2008 03:42 PM
I can't connect to remote MySQL server pmnghi MySQL 2 January 24th, 2006 05:38 AM
Remote connection to a MySql database. Major Sahimi MySQL 2 May 14th, 2005 06:09 AM
Remote connection to a MySQL database. Major Sahimi PHP How-To 2 July 9th, 2003 10:01 AM



All times are GMT -4. The time now is 09:11 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.