The following article describes how to configure a non-installed MySQL database in win32. We all know that the current non-installed version is v5.1.40 downloaded from MySQL.com, it is a ZIP package and decompressed to the C: \ MySQL5.1.40 directory.
Next, set the system environment variables and use the MySQL database 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 installation directory of the mysql database 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
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.
- }
The connection to the MySQL database is successful. 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)
The above content is an introduction to the MySQL database. I hope you will get some benefits.