DTP


 
Lively discussions on the graphic arts and publishing — in print or on the web


Go Back   Desktop Publishing Forum > General Discussions > Web Site Building & Maintenance

Reply
 
Thread Tools Display Modes
Old 05-29-2006, 06:56 AM   #1
dthomsen8
Member
 
dthomsen8's Avatar
 
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default XAMPP Installed, no MySQL command line

After an earlier discussion in this section, I went ahead and installed (On Windows XP Pro) Apache, MySQL, PHP, and FileZilla. Everything seems to work fine. The XAMPP window lets me check the security and change passwords. I can use WinMySQLadmin, too. I installed these in the second copy of WinXP on my dual-boot computer, and I shut down the network interface to avoid any security issues from the Comcast cable connection.

What I cannot do is find the command line for MySQL. I can't figure that out from the MySQL sites or the XAMPP site. I didn't figure it out from five PHP/MySQL books I consulted, either. Some of those books are brand new, consulted without purchasing them at B&N. So, what is the secret?
dthomsen8 is offline   Reply With Quote
Old 05-29-2006, 07:11 AM   #2
iamback
Member
 
iamback's Avatar
 
Join Date: Oct 2005
Location: Amsterdam, NL
Posts: 4,894
Default

Quote:
Originally Posted by dthomsen8
What I cannot do is find the command line for MySQL. (...) So, what is the secret?
What, exactly, did you try where to find it?

And which "MySQL sites" are you referring to? As far as I'm aware there is only a single one, documentation here.

   
__________________
Marjolein Katsma
Look through my eyes on Cultural Surfaces (soon!), My ArtFlakes shop and Flickr.
Occasionally I am also connecting online dots... and sometimes you can follow me on Marjolein's Travel Blog
iamback is offline   Reply With Quote
Old 05-29-2006, 08:14 AM   #3
Kelvyn
Staff
 
Kelvyn's Avatar
 
Join Date: Feb 2005
Location: In the Heart of the English Lake District
Posts: 1,381
Default

It would be a lot easier to use phpMyAdmin - surely this is in XAMPP?

Otherwise connect through the windows command prompt.
  1. Open the windows command prompt (don't double click mysql.exe)
  2. Navigate to the directory where mysql.exe is located.
  3. Call mysql with user parameters eg "mysql -u [root] -p" [RTN] = command line access!

   
__________________
Kelvyn

Web site design, hosting and marketing, Keswick in the UK Lake District

If you are planning a visit to Keswick then try Keswick Tourist Information website

Kelvyn is offline   Reply With Quote
Old 05-30-2006, 11:58 AM   #4
dthomsen8
Member
 
dthomsen8's Avatar
 
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default XAMPP Details

Quote:
Originally Posted by Kelvyn
It would be a lot easier to use phpMyAdmin - surely this is in XAMPP?
Yes, this is in XAMPP, but the install leaves me unable to do what you suggest.

Here are more details from my installation of Apache, MySQL, FileZilla and PHP using XAMPP.

When installing this software using XAMP, I received a dialog box asking "Install XAMPP Servers (Apache, MySQL or FileZilla FTP) as service? I answered Yes.

After that, I received a message stating that the install was successful.

I rebooted, and could see a desktop icon, echoed with a notification bar icon for XAMPP.

Below are attachments showing progress to that point. To avoid too big a set of attachments, I am placing further information in a separate message.







Attached Thumbnails
Click image for larger version

Name:	badx10.jpg
Views:	118
Size:	24.1 KB
ID:	574   Click image for larger version

Name:	badx01.JPG
Views:	100
Size:	6.7 KB
ID:	575  
dthomsen8 is offline   Reply With Quote
Old 05-30-2006, 12:07 PM   #5
dthomsen8
Member
 
dthomsen8's Avatar
 
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default XAMPP Details

Clicking on the XAMPP icon provides the XAMPP Control Panel Application. This GUI provides quite a few options. The attachment provides the results of the STATUS button. There are also ADMIN buttons for Apache, MySQL, and FileZilla. An attachment shows the results of the MySQL Admin, with yet more options. Needless to say, I am confused by this proliferation of controls and options.
Attached Thumbnails
Click image for larger version

Name:	badx21.JPG
Views:	120
Size:	83.4 KB
ID:	576   Click image for larger version

Name:	badx22.JPG
Views:	102
Size:	93.1 KB
ID:	577   Click image for larger version

Name:	badx32.JPG
Views:	127
Size:	113.8 KB
ID:	578   Click image for larger version

Name:	badx33.JPG
Views:	109
Size:	146.3 KB
ID:	579  
dthomsen8 is offline   Reply With Quote
Old 05-30-2006, 12:39 PM   #6
Kelvyn
Staff
 
Kelvyn's Avatar
 
Join Date: Feb 2005
Location: In the Heart of the English Lake District
Posts: 1,381
Default

Quote:
Originally Posted by dthomsen8
Needless to say, I am confused by this proliferation of controls and options.
But there is a menu link to phpMyAdmin there. This package is for developers and it may be that you have too many options so can't see the wood for the trees! I prefer to use JSAS because it is so easy to install and manage. And running on a virtual drive reduces security issues.

   
__________________
Kelvyn

Web site design, hosting and marketing, Keswick in the UK Lake District

If you are planning a visit to Keswick then try Keswick Tourist Information website

Kelvyn is offline   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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
First line and letter formatting Bo Aakerstrom Web Site Building & Maintenance 8 08-24-2006 08:45 AM
Off line for a (short) week iamback The Corner Pub 3 08-10-2006 12:53 PM
Back command in PDF Richard Waller Web Site Building & Maintenance 2 03-26-2006 07:31 PM
Your Driver's License on Line George The Corner Pub 7 11-04-2005 09:32 PM


All times are GMT -8. The time now is 08:47 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Contents copyright 2004–2014 Desktop Publishing Forum and its members.