Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > mysql > answers

Windows Interface for MySQL

Newbie
  
Join Date: Apr 2007
Posts: 4
#1: Apr 28 '07
Hi,

My internet provider has mysql available but does not provide a user interface. I am using phpmyadmin on a different site but the file size is to large to consider it for the new site.

What choices do I have for working with mysql on a windowsxp setup? My code of choice is php.

Andy

pbmods's Avatar
Site Moderator
  
Join Date: Apr 2007
Location: Texas
Posts: 5,435
#2: Apr 29 '07

re: Windows Interface for MySQL

You mean aside from using the CLI?
Newbie
  
Join Date: Apr 2007
Posts: 4
#3: Apr 29 '07

re: Windows Interface for MySQL

Sorry, I don't know what you are referring to, 'CLI'.

Andy
pbmods's Avatar
Site Moderator
  
Join Date: Apr 2007
Location: Texas
Posts: 5,435
#4: Apr 30 '07

re: Windows Interface for MySQL

Quote:

Originally Posted by windrunner

Sorry, I don't know what you are referring to, 'CLI'.

Andy

CLI stands for 'Command-Line Interface'. On Windows, it would be interfacing with MySQL via the command prompt.

To use it, you would simply open up a new command prompt window (Windows-R, type 'cmd', press return), then type something like this:

"C:\Program Files\Mysql 5.0\bin\mysql" -u username -p
Newbie
  
Join Date: Apr 2007
Posts: 4
#5: Apr 30 '07

re: Windows Interface for MySQL

I don't know how to do that.

The mysql db is on the web host server. I have no direct link to it that I can determine, except to upload a php document to connect to the db.

Is CLI practical is this case?

Andy
pbmods's Avatar
Site Moderator
  
Join Date: Apr 2007
Location: Texas
Posts: 5,435
#6: May 5 '07

re: Windows Interface for MySQL

Quote:

Originally Posted by windrunner

The mysql db is on the web host server. I have no direct link to it that I can determine, except to upload a php document to connect to the db.

Ah.

To get this working, you'd have to add privileges for a remote User using your server's control panel, then log into MySQL remotely using its -h argument:

mysql -h ip.of.mysql.server -u username -p database_name

This is a fairly difficult setup to troubleshoot, so you might just be better off purchasing more space on your server so that you can install PHPMyAdmin.
Newbie
  
Join Date: Apr 2007
Posts: 4
#7: May 16 '07

re: Windows Interface for MySQL

Quote:

Originally Posted by pbmods

Ah.

To get this working, you'd have to add privileges for a remote User using your server's control panel, then log into MySQL remotely using its -h argument:

mysql -h ip.of.mysql.server -u username -p database_name

This is a fairly difficult setup to troubleshoot, so you might just be better off purchasing more space on your server so that you can install PHPMyAdmin.

How do I estimate the additional server space needed for a new install of phpmyadmin?
Motoma's Avatar
Moderator
  
Join Date: Jan 2007
Location: Maine, USA
Posts: 2,904
#8: May 16 '07

re: Windows Interface for MySQL

SQLyog is my interface of choice.
Reply

« previous question | next question »

Similar MySQL Database bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,471 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved