Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Old 07-17-2007, 02:38 PM MySQL client?
Nathand's Avatar
Extreme Talker

Posts: 233
Location: USA
Trades: 0
Hi, where can I find a MySQL client? I new to the database. I installed a version of MySQL on my computer, and use it for testing my website (localhost), but now I need to access a MySQL database installed on a remote host.

Thanks for the help,
Nathan
Nathand is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 07-17-2007, 03:32 PM Re: MySQL client?
tripy's Avatar
Do not try this at home!

Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
Trades: 0
In the directory where you have the mysql server installed, there should be a "bin" subdirectory.
And in that subdirectory, a program named "mysql".
It's the official command line client.

Yes, command line, like ms-dos.
There are a lot of others client, beginning with the "query browser" that you can find on http://www.mysql.com/products/tools/
Try google to find a handful hundreds of clients, open-source or not, running on almost anything.
__________________
Only a biker knows why a dog sticks his head out the window.
tripy is offline
Reply With Quote
View Public Profile Visit tripy's homepage!
 
Old 07-17-2007, 05:20 PM Re: MySQL client?
Nathand's Avatar
Extreme Talker

Posts: 233
Location: USA
Trades: 0
When I run "mysql.exe" I get a beeping noise from my computer and the command window immediately closes.
Nathand is offline
Reply With Quote
View Public Profile
 
Old 07-17-2007, 06:38 PM Re: MySQL client?
tripy's Avatar
Do not try this at home!

Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
Trades: 0
Because it must be run from a terminal, and having options passed to it.
It's displaying the options, but as windows see the program as stopped, it closes the windows right after that.

I believe that you can say windows to keep the windows open after the end of the program if you right click and ask for the file properties.

Last time I used a windows station (it was windows 98), I had to open a shell (I believe it's start button -> run -> cmd.exe on windows 2000, 2003 and xp) and then either have put the mysql bin directory in your path, or navigate to your mysql bin directory through a series of "cd ..", "cd {directory name}" to access it and launch mysql.exe
I'm running linux, so I cannot say much more, sorry.

On my linux box, I connect to my local mysql with this command line:
Code:
mysql -u webdev -h 127.0.0.1 -p sandbox
Meaning that I connect on my local computer (-h 127.0.0.1), with the user webdev (-u webdev), that the front-end must ask me for a password to authenticate (-p) and to the database named "sandbox"
__________________
Only a biker knows why a dog sticks his head out the window.
tripy is offline
Reply With Quote
View Public Profile Visit tripy's homepage!
 
Old 07-19-2007, 05:15 AM Re: MySQL client?
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,517
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Download HeidSQL

IMO just about the best MySQL GUI there is
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Reply     « Reply to MySQL client?
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.15735 seconds with 12 queries