mysql terminal

[guysmiley]

Greetings,

 

I am hoping to use uniformserver with my class of 23 grade 11 Computer Science students to teach them the basics of Web servers/php/mysql/apache...

 

On their machines, the XP command prompt is disabled by Group Policy. I was hoping to use the MySQL terminal but it does not come bundled with UniformServer.

 

Is there a way to get MySQL terminal working quickly with UniformServer? I know phpmyadmin is fabulous, but I really want my students to get an understanding of things from the command prompt...

[Ric]

I am not sure what you mean by this: “I was hoping to use the MySQL terminal but it does not come bundled with UniformServer.”

Note: mysql.exe is the interface to the MySQL server and is bundled with Uniform Server.

 

To enable the console edit file: UniServer\unicon\tray_menu\UniTray1.ini

 

Locate this section:

;=== LEFT MENU ============

[Menu.Left]

Type: item; Caption: "Start UniServer (Apache MySQL)"; Action: shellexecute; FileName: "%PHP%\php.exe"; Parameters: " -n %ServerConMain%\start_servers.php 7";ShowCmd: hidden; Glyph: 9

Type: item; Caption: "Stop UniServer (Apache MySQL)"; Action: shellexecute; FileName: "%PHP%\php.exe"; Parameters: " -n %ServerConMain%\stop_servers.php 7";ShowCmd: hidden; Glyph: 11

 

Replace 7 with 15 as shown below:

;=== LEFT MENU ============

[Menu.Left]

Type: item; Caption: "Start UniServer (Apache MySQL)"; Action: shellexecute; FileName: "%PHP%\php.exe"; Parameters: " -n %ServerConMain%\start_servers.php 15";ShowCmd: hidden; Glyph: 9

Type: item; Caption: "Stop UniServer (Apache MySQL)"; Action: shellexecute; FileName: "%PHP%\php.exe"; Parameters: " -n %ServerConMain%\stop_servers.php 15";ShowCmd: hidden; Glyph: 11

 

Save file and run servers. This should bring up a command prompt where you can run MySQL commands.

 

Related information:

http://wiki.uniformserver.com/index.php/MySQL_Console

http://wiki.uniformserver.com/index.php/5.0-Nano:_UniTray

http://wiki.uniformserver.com/index.php/5....ript_Parameters

 

Trouble is mysql.exe is a command-line driven utility hence the following will be an issue “On their machines, the XP command prompt is disabled by Group Policy.”

Contact your admin staff to resolve this.

 

In a similar vein parts of Uniform Server will not function because they rely on batch files to run the PHP CLI scripts.

 

All the best

Ric