Current location: Hot Scripts Forums » Programming Languages » PHP » Using mysql on localhost


Using mysql on localhost

Reply
  #1 (permalink)  
Old 09-15-05, 09:25 PM
jack_mcs jack_mcs is offline
Newbie Coder
 
Join Date: Aug 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Using mysql on localhost

I need to upload a very large mysql database to my local setup using EasyPHP. I know how to use mysql but I've only used it on remote hosts. For some reason I cannot connect to the localhost. I'm running the mysql command from a dos prompt in the mysql/bin directory. It fails with "Can't connect to mysql server on localhost." Can someone please explain how I execute this so that it will work?
Reply With Quote
  #2 (permalink)  
Old 09-16-05, 03:43 AM
snaip's Avatar
snaip snaip is offline
iNET Interactive
 
Join Date: Nov 2003
Posts: 997
Thanks: 2
Thanked 7 Times in 6 Posts
Do you have phpmyadmin installed?
__________________
Regards,
Ahmad Permessur
Team HotScripts
Reply With Quote
  #3 (permalink)  
Old 09-16-05, 08:58 AM
wheezy360's Avatar
wheezy360 wheezy360 is offline
Newbie Coder
 
Join Date: Nov 2003
Location: Toronto, ON
Posts: 64
Thanks: 0
Thanked 0 Times in 0 Posts
Since you're running on localhost I'd recommend a console based gui rather than the web based PHPMyAdmin. A couple that I use frequently are SQLYog, and MySQL Administrator / MySQL Query Browser.

Note that MySQL Administrator and MySQL Query Browser are separate links to separate programs that are to be used in conjunction with each other.
Reply With Quote
  #4 (permalink)  
Old 09-16-05, 09:48 AM
jack_mcs jack_mcs is offline
Newbie Coder
 
Join Date: Aug 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Quote:
Originally Posted by snaip
Do you have phpmyadmin installed?
Yes. The size of the DB is 17 MB so I can't use phpmyadmin due to it timing our.

Jack
Reply With Quote
  #5 (permalink)  
Old 09-16-05, 09:50 AM
jack_mcs jack_mcs is offline
Newbie Coder
 
Join Date: Aug 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Quote:
Originally Posted by wheezy360
Since you're running on localhost I'd recommend a console based gui rather than the web based PHPMyAdmin. A couple that I use frequently are SQLYog, and MySQL Administrator / MySQL Query Browser.

Note that MySQL Administrator and MySQL Query Browser are separate links to separate programs that are to be used in conjunction with each other.
I don't think that makes a difference in this case. I'm trying to use the shell program mysql. It doesn't have anything to do with phpmyadmin, as far as I know. The problem seems to be that I am not executing it from the proper place or I don't have some setting correct since it cannot connect to the host.
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
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 On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Useful MySQL Resources ptesone Database 30 02-23-11 08:28 AM
PHP and MySQL ? rob2132 Hot Scripts Forum Questions, Suggestions and Feedback 4 08-29-08 02:22 AM
MySQL 4.1 Subquery Performance SLOW TokenSDragon PHP 2 06-15-07 12:46 PM
UPDATE: MySQL Auto Backup & Export v1.1 Beyonder General Advertisements 2 03-21-05 02:05 PM
great product for dumping/recovering MySQL databases Dave Brown General Advertisements 1 10-03-03 07:40 AM


All times are GMT -5. The time now is 06:12 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.