Shulou(Shulou.com)06/01 Report--

Editor to share with you how to use the command to install mysql, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Installation method: 1, download the MySQL installation package on the official website, and decompress it; 2, use the cd command from the cmd command line to enter the bin directory of MySQL; 3, execute the "mysqld-- install MySQL-- defaults-file=C:\ mysql\ my.ini" command.

Windows command line install MySQL

Download the MySQL installation package

2. Extract the folder to the directory you want

III. Configuration file

To create a new my.ini configuration file, enter the following

# The following options will be passed to all MySQL clients [client] # password = your_passwordport = 3306 [mysql] # set the character set of the mysql client default-character-set = utf8# The MySQL server [mysqld] port = 330 set the installation directory of mysql basedir = c:/mysql# set the data storage directory of the mysql database, it must be data or / xxx-datadatadir = c:/mysql/data# set the character set character_set_server = utf8 of the server segment

Enter the command line as an administrator and enter it in turn

Cd C:\ mysql\ binmysqld-- install MySQL-- defaults-file=C:\ mysql\ my.ini

Note: if you prompt "Install/Remove of the Service Denied!", it means you are not using administrator mode.

Complete the installation

5. Now that the installation has been completed, configure the environment variables for MySQL

Right-click my computer-> Advanced system Settings-> Environment variables

Find the Path variable, (for both the system and the user, I usually use the system variable)

Edit Path, add "; C:\ mysql\ bin" at the end, and finish

The above is all the contents of how to install mysql with commands, thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.