MySQL is a relational database management system developed by MySQL AB of Sweden and currently belongs to Oracle Corporation. MySQL is an associative database management system that stores data in separate tables instead of putting all the data in a large repository, which increases speed and increases flexibility. The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts a dual authorization policy (this term "authorization policy"), which is divided into community version and commercial version. Due to its small size, fast speed, low total cost of ownership, especially open source, it is generally small and medium-sized. Website development has chosen MySQL as the website database. Thanks to the excellent performance of its community version, PHP and Apache can form a good development environment.
Xiaobian installs a MySQL database, but because the MySQL Install MSI only has 32 bits, I chose to use Windows (x86, 64-bit) and ZIP Archive.
Below I introduce the process of installing MySQL, for reference only.
1. Workers must first sharpen their tools, so the first step is to go to http://dev.mysql.com/downloads/mysql/ to download Windows (x86, 64-bit), ZIP Archive,
2. After the download is complete, extract it to the path you want to install. For example, I extracted it to the D:\MySql\mysql-5.7.12-winx64\ path. Just unzip it and it should be the following folders:
3. This step is the step to start the configuration. If your file suffix name is not displayed, it is recommended that you set your own file suffix display, because we need to add the configuration file: set the file suffix display step: win7 select double-click Computer "-" Click "Organization" under the navigation bar - "Select "Folder and Search Selection" - "Click "View" -" to "Hide the extension of known file types" check to cancel .
4. ——————》
5. Create a new my.ini configuration file. This configuration file will overwrite the my-default.ini file in the current folder. The previous step to set the display file suffix is ​​to prepare for this step. Open this configuration file and add the following code. Into the file:
[mysql]
# Set the default character set of the mysql client
Default-character-set=utf8
[mysqld]
#设置3306å£
Port = 3306
# Set the mysql installation directory
Basedir=D:\MySql\mysql-5.7.12-winx64
# Set the mysql database data storage directory
Datadir=D:\MySql\mysql-5.7.12-winx64\data
# Allow the maximum number of connections
Max_connecTIons=200
# The character set used by the server defaults to the 8-bit encoded laTIn1 character set.
Character-set-server=utf8
# Default storage engine to be used when creating a new table
Default-storage-engine=INNODB
• Save after adding, and then create a new empty data folder in this path. The layout of the whole process should be as follows:
1. The pre-preparation is done, the next step is to start the installation service, run cmd.exe as an administrator, remember to run as an administrator, enter the installation bin directory, the most important and most important commands are here, Indispensable, or you can not start the service after installing the service, enter the mysqld --iniTIalize-insecure --user=mysql command, and then press Enter.
2.
3. Then enter the mysqld install installation service, the installation will prompt the installation is successful, then start the MySQL service is OK,
4.
5. Configure environment variables - "Computer right" "Properties" - "" Advanced System Settings" - "" Environment Variables" - "path" - "copy the path of the bin directory to the path environment variable, most So copy it to the front, then add a semicolon to get it.
6.
7. Open MySQL, open cmd.exe, enter the mysql -uroot -p command, the default is no password, enter to enter. If some have already set a password, you must enter the password to enter. If you have a password, you can use mysql -uroot -p password, or you can use mysql -uroot -p to enter the password.
8.
At this point, the mysql installation and use of the tutorial will be introduced to everyone, and the writing is not good, please forgive me, welcome everyone to put forward criticism and suggestions, and learn and progress together.
Fiber Optic Patch Panel,Fiber Patch Panel,Fiber Distribution Panel,Optical Patch Panel
Cixi Dani Plastic Products Co.,Ltd , https://www.danifiberoptic.com