Zero logo

Server Command Console

The Server Command Console opens a command window with environment variables preset, and paths configured for server utilities. Apart from cosmetics, it is identical to a standard command window.

This page focuses on using the Server Command Console. It is not intended as a definitive guide but just an introduction to show you how to access and run server utilities such as the MySQL client.

Command window - background

Uniform Server Zero XI is a portable WAMP stack; each component provides a number of command line utilities. These command line utilities can be run using a standard command window (cmd). The process is tedious as the following example demonstrates, you need to change the working directory to the folder containing the utility to be run and set any environment variables as required.

How to run a standard command window

This example uses the MySQL client to demonstrate how to run command line utilities using the standard command window. MySQL client allows you to run SQL commands, for example to create or delete databases.

To open a command window, run the command cmd from the start menu. Running a MySQL utility program requires navigating to its binary folder.

Note 1: The path where you installed The Uniform Server Zero XI may be different; substitute your path as appropriate.
Note 2: To run MySQL utilities you must have the MySQL server running.

  1. Win XP :- Start a command window: (Start > click on Run > type cmd click OK)
    Alternatively: Click Start > All Programs > Accessories > click Command Prompt
  2. Win 8 :- Pressing the WIN and X keys together this opens a pop-up menu
    from this menu select Command Prompt
  3. Type following lines into the command window:
    cd \
    cd C:\UniServerZ\core\mysql\bin (Change to other location as required)
  4. Run the utility by typing the following:
    mysql -h127.0.0.1 -uroot -proot
  5. We are not going to use the utility close it as follows:
    At the mysql prompt enter exit.

The dialogue in the command window looks similar to that on the right.

Standard command window

Running a command window from the host PC steps 1 to 3 become tedious especially when running servers from a USB stick or moving servers to a different location. The paths will be different. The Server Command Console removes these three steps see below.

Server Command Console

The Server Command Console opens a command window with environment variables preset, and paths configured for server utilities removing the above three teps.

To run a server command-line utility all that is required is to enter the command name and any parameters. For the above example proceed as follows:

  1. Start UniController
  2. Start MySQL server: Click Start MySQL button
  3. Start Command Console: Click Server console button
  4. Run the utility by typing the following:
    mysql -h127.0.0.1 -uroot -proot
  5. We are not going to use the utility close it as follows:
    At the mysql prompt enter exit.

The Server Command Console with its pre-defined paths makes running utilities easier than using the standard command prompt.

Server Command Console

MySQL Prompt - Short cut

The MySQL utility is a very popular admin tool; Uniform Server Zero provides a dedicated menu button that directly runs this utility in a console window.

  1. Start UniController
  2. Start MySQL server: Click Start MySQL button
  3. Start MySQL Prompt: Click MySQL Console
  4. We are not going to use the utility close it as follows:
    At the mysql prompt enter exit.

Note: The MySQL Console button is enabled only when the MySQL server is running.

Standard command window

Note:
The utility is run with the following command line: mysql.exe --host=localhost --port=3306 --user=root --password=root
Parameters used are automatically extracted from current MySQL server configuration. The above example shows default MySQL server configuration parameters.

Command window and MySQL

Using a command window to administer the MySQL server is not specific to The Uniform Server Zero XI. Running a standard command window is the same for any Windows MySQL installation.

The Uniform Server Zero’s Server Console sets the paths to MySQL binaries transparently. With the command console you can access the MySQL server utilities:

  • mysql.exe - MySQL client runs SQL commands
  • mysqladmin.exe - MySQL admin
  • mysqldump.exe - Database dump

The MySQL client allows you to run SQL commands, for example to create or delete databases. Uniform Server Zero provides a seperate button to run the MySQL client see above (MySQL Prompt - Short cut).

Server Utilities - View help information

Each server utility contains a help facility showing parameters that can be used. The following list utilities available:

Utility Help Comment
ab.exe -h - Benchmarking tool
abs.exe -h - Benchmarking tool SSL
msmtp.exe --help - Mail utility
mysql.exe --help - MySQL client runs SQL commands
mysqladmin.exe --help - MySQL admin
mysqldump.exe --help - Database dump
openssl.exe ? - Open SSL utility
php.exe -h - PHP command line
perl.exe -h - Perl command line
Note 1: To display help information enter utility name followed by the help parameter for example.
mysqladmin.exe --help
Note 2: If output scrolls off the screen add pipe "| more" this lets you page through the output by
hitting the space bar for example.
mysqladmin.exe --help | more

Benchmarking tool

Apache Bench (ab) is a simple http load generating tool.
Suppose we want to see how fast localhost can handle 100 requests, with a maximum of 10 requests running concurrently enter the following into Server Command Console:

ab.exe -n 100 -c 10 http://127.0.0.1/

You can target a specific page using the following format and write the output to a file:

ab.exe -n 100 -c 10 http://127.0.0.1/test.php > test1.txt

Same as above with keep-alive on

ab.exe -n 100 -c 10 -k http://127.0.0.1/test.php > test1.txt

You can force the request to use mod_deflate if avaible using the following format:

ab.exe -n 100 -c 10 -H "Accept-Encoding: gzip;" http://127.0.0.1/test.php > test1.txt

Note: Running tests from localhost skews the results you should always run your benchmarks from another machine.

That said you might be interested only in comparative results, for example optimising a particular piece of code for speed. Running locally will quickly highlight any bottlenecks.

Related topics

Set New MySQL root user password using MySQL Prompt
Restore MySQL root user password using command window
Create Delete Database using Server Command Console
Create Restricted MySQL User using MySQL Prompt
Delete Restricted MySQL User using MySQL Prompt
Edit Restricted MySQL User using MySQL Prompt