The win32 installation is configured with a non installed version of MySQL

  • 2020-05-10 23:00:14
  • OfStack

Environment variable Settings: right-click properties on the desktop of my computer - > Advanced - > Environmental variables - > Double-click the Path item to add the C:\ MySQL5.1.40 \bin directory. If you want to use SDK for development, then add the Lib and include directories to the Lib and include environment variables.
Environment variables are set well in the start menu - > Run - > CMD, execute MySQLD, or directly switch to C:\ MySQL5.1.40 \bin directory and double-click to run MySQLD.exe service program.exe service program can also be run as a service.
Install service mysqld-install
Start the service net start mysql
Stop service net stop mysql
Delete the service mysqld-remove
Open another CMD window and hit MySQL-h localhost enter to see it
{
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.
}
You have successfully connected to the MySQL database. Next, you can view the database.
- > show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.01 sec)
- > use test;
Database changed

-- can support constant expressions and MSSQL or Oracle select 444+44 from dual1 like;
mysql > select 444+44;
+--------+
| 444+44 |
+--------+
| 488 |
+--------+
1 row in set (0.00 sec)

Related articles: