Access the mySql command window? Admin?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Access the mySql command window? Admin?

Postby Breezy » 11. December 2007 03:57

I'm new to php/mysql. I recently installed xampp and both apache and mysql says they are running (not as svc). However, I'm stuck now. I want to create database/table from command line. Don't know how to access the mysql command window with xampp.

Does anyone know how to access the mysql command window when xampp is installeld?

start/run/C:\xampp\mysql\bin\mysql-it just flashes on the screen and disappears. Same when I click on admin in the xampp control panel.



Breezy
PHP is new to me but Javascript is comfortable.
Breezy
 
Posts: 4
Joined: 11. December 2007 03:23
Location: Austin, Texas

Postby Izzy » 11. December 2007 04:15

The Admin feature accessible from the Control Panel is no longer used.

Do you really need to use the command line to create your databases as phpMyAdmin is a very good GUI for all things MySQL?

http://localhost - click on the phpMyAdmin link or http://localhost/phpmyadmin



http://community.apachefriends.org/f/viewtopi ... 597#110597

In the above link, you would of course have to cd to C:\xampp\mysql\bin to issue the mysql command or your own path location to the mysql directory.

From this directory location in a command console you can also issue the command: mysqladmin - which will list all the commands or mysqladmin --help
Code: Select all
C:\xampp\mysql\bin>mysqladmin [OPTIONS] command


BTW it is start/run.. then type cmd or cmd.exe to open a command console - then cd to where you want to go to.


===========================================
1. The new DeskTopXampp Launch Control for XAMPP / XAMPPlite
Posted by Ridgewood available from Ridgewood'sDTX web site

2. Build Rich AJAX Applications - Faster
TIBCO General Interface Pro Edition but FREE and Open Source
Fully working with NO donations required to get a user/password
===========================================
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Thanks. This worked

Postby Breezy » 11. December 2007 06:19

Thanks Izzy. I have a php training book which recommends knowing the command window but I like the admin program better.

After installing xampp, this is what I did:

For using the command prompt:
start/run/
type cmd
type cd\
type xampp\mysql\bin
then type mysql --user=root --password=
You are now at the mysql> prompt ready to create a database!

For example:
mysql> create database training;
mysql> use training;
mysql> create table class1 (first_name varchar(50), last_name varchar(50), notes text);


For using phpMyAdmin:
go to http://localhost/phpmyadmin/
on left, choose "mysql" database
scroll down to bottom to create new table
Enter name and number of fields,
Then you are home free--


This helped a lot! A quasi-instruction manual
http://oink-pug.org/data/GettingStarted.ppt

Breezy
PHP is new to me but Javascript is comfortable.
Breezy
 
Posts: 4
Joined: 11. December 2007 03:23
Location: Austin, Texas


Return to XAMPP for Windows

Who is online

Users browsing this forum: JJ_Tagy and 74 guests