UniServer

The Uniform Server (or UniServer) is a free open source WAMP package for Microsoft Windows.

1. To set operating system compatibility for uniserver. Right click on UniController.exe >> compatibility >> compatibility mode.
2. The host domain is localhost (IP: 127.0.0.1).
3. It shows the default page index.php which is in www folder.
4. To accsess mysql from cmd
[you have to add the path UniServer\udrive\usr\local\mysql\bin in environment variables]

mysql --user=root --password=root

Few commands

• SELECT VERSION();
• CURRENT_DATE;
• SHOW DATABASES;

5. To create a database and see the table

Create database databasename;
Use database;
DESCRIBE tabelname;

6. Delete all data in the table

TRUNCATE TABLE tablename; or
DELETE FROM tablename;

Advertisements