Use win32 to configure non-installed MySQL

This article describes how to use win32 to configure non-installed MySQL. Currently, the non-installed MySQL version is v5.1.40 downloaded from MySQL.com. Download a ZIP package, decompress the package to the C: \ MySQL5.1.40 directory. Next, set the system environment variables and use MySQL In the CMD command line.

Environment variable settings: Right-click my computer on the desktop and choose Properties> advanced> environment variables> double-click the Path to add the C: \ MySQL5.1.40 \ bin directory. If you want to use SDK development, add the Lib and include directories to the corresponding Lib and include environment variables;

Set the environment variables, choose Start> RUN> CMD, run MySQLD, or directly switch to C: \ MySQL5.1.40 \ bin to run the mysqld.exe service program, or run it as a service: note that the mysql installation directory should not contain Chinese characters or spaces. In SDK development, unexpected problems may occur in QT;

Install mysqld-install

Start the Service net start mysql

Stop Service. net stop mysql

Delete service mysqld-remove

During the actual operation of win32 configuration for non-installed MySQL, open a CMD window and run MySQL-h localhost and press Enter.

 
 

  
  
{  
  
  
Welcome to the MySQL monitor. Commands end with ; or \g.  
  
  
Your MySQL connection id is 5  
  
  
Server version: 5.1.40-community MySQL Community Server (GPL)  
  
  
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.  
  
  
} 
 
 

Indicates that the MySQL database is successfully connected. Next, you can view the database,

 
 

  
  
->show databases;  
  
  
+--------------------+  
  
  
| Database |  
  
  
+--------------------+  
  
  
| information_schema |  
  
  
| test |  
  
  
+--------------------+  
  
  
2 rows in set (0.01 sec)  
  
  
->use test;  
  
  
Database changed 
 
 

Constant expressions are supported in the same way as select 444 + 44 from dual in MSSQL or Oracle;

 
 

  
  
mysql> select 444+44;   
  
  
+--------+  
  
  
| 444+44 |  
  
  
+--------+  
  
  
| 488 |  
  
  
+--------+  
  
  
1 row in set (0.00 sec) 
 
 

Tag: win32 configuration non-installed MySQL

Original article title: win32 non-installed MySQL Configuration

Connection: http://www.cnblogs.com/jfyes/archive/2010/02/09/1666314.html