Jump to content
The Uniform Server Community
Sign in to follow this  
guysmiley

mysql terminal

Recommended Posts

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...

Share this post


Link to post
Share on other sites

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 :)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...