Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Mac OS X > logging in to a mysql server from a windows box

logging in to a mysql server from a windows box
Thread Tools
Forum Regular
Join Date: Sep 2002
Location: Ottawa, ON
Status: Offline
Reply With Quote
Oct 10, 2003, 08:47 AM
 
i have experience logging into a local mysql server from the terminal, but not from a windows machine to a remote server.. can anyone help me out? I am pretty windows ignorant!

thanks,
Alex
     
Senior User
Join Date: Oct 2002
Location: Adelaide, South Australia
Status: Offline
Reply With Quote
Oct 10, 2003, 07:56 PM
 
Fire up a command prompt and enter the following:

cd *PATHTOMYSQL*\bin
mysql -h*IPADDRESS* -u*USER* -p


Simple as that
     
Forum Regular
Join Date: Sep 2002
Location: Ottawa, ON
Status: Offline
Reply With Quote
Oct 10, 2003, 08:01 PM
 
Originally posted by DVD Plaza:
Fire up a command prompt and enter the following:

cd *PATHTOMYSQL*\bin
mysql -h*IPADDRESS* -u*USER* -p


Simple as that
sounds too easy for windows! how do i connect to the remote machine?
     
Fresh-Faced Recruit
Join Date: Sep 2002
Status: Offline
Reply With Quote
Oct 10, 2003, 08:29 PM
 
Originally posted by alex_wlu_82:
sounds too easy for windows! how do i connect to the remote machine?
the "-h <ip address of remote machine>" argument tells mysql to connect to that machine instead of the local one.

Dont forget to make sure that the user account you are connecting with has privileges from remote adresses!
     
   
Thread Tools
Forum Links
Forum 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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Top
Privacy Policy
All times are GMT -5. The time now is 01:08 PM.
All contents of these forums © 1995-2013 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.7 © 2000-2013, Jelsoft Enterprises Ltd., Content Relevant URLs by vBSEO 3.3.2