MySQL download, installation, configuration, and usage tutorial (win7x64), mysqlwin7x64

MySQL download, installation, configuration, and usage tutorial (win7x64), mysqlwin7x64

After using MySQL, regardless of the capacity, I found that it is much easier to use than the other two (SQL server, oracle. Next, let's write down the specific steps for those kids who do not know how to get them.

I have written this in a little too detailed or even complicated. Many steps are omitted in other tutorial documents, but I still want to write it out, because I had a lot of detours at that time, I hope you can avoid these detours. Of course, you can skip it if you know what you want.

Tools:

Computer win7 64bit

Method/step:

Step 1:Download

A. As the saying goes: "It's hard to be a man without rice! I use the ZIP Archive version here, And the 64-bit win7 machine supports this, so I suggest using this. This is simple and clean.

The address is shown in the figure below.

Pull down the bottom, clear the 64 bitZIP Archive, and click Download.

B. click it to go to another page, but it does not start downloading. You don't have to worry about it. It doesn't matter if you know that he wants you to log on (login ), you can also apply for an account (sign up). You can log on to the account or download the account after the application is successful. (Remember that the password must be a combination of letters and numbers and uppercase letters)

C. Note: The password must be a combination of letters and numbers. The letters must contain uppercase letters.

D. If you have an account, you can log in directly.

Click DownNow. The file is not big, only 200 MB or more, very fast. Wait a moment. (after the successful operation, it is reasonable to say that it has arrived at the place below, but if you do not know this, you can find it by yourself, or exit directly. Repeat the preceding steps and select the logon option.

To put it bluntly, MySQL is an open source database. The so-called open source database allows you to view the source code. I believe many of my boots will be interested in this. So where is the source code?

When you first enter (the address of the first image. There is a Select Platform, just Select the source code below.

(Similarly, if you want to download MySQL from linux, you can find it here)

After the download is complete, start installation and configuration.

Step 2:Install (unzip)

The ZIP Archive version is free of installation. You just need to decompress the package. It is no different from the installation version, but it does not need to be installed. Find the downloaded mysql-x.x.xx-winx64.zip file, right-click it, and select (decompress it ...), find the place you want to install. If you like C: disk, select C: disk. If you don't like it, select c: disk. After all, C: it is not good to store too many items on the system disk. It's okay after decompression, isn't it easy? I know the benefits of ZIP Archive.

Are you sure you want to ask? How to use it? Mysql in \ bin. How does exe not respond to a black window?

No response because the service is not available yet!

Don't open, just open it?

The service is not installed yet!

How to install it?

Next let's talk about it!

Step 3:Configure the default file

In theory, we can directly install the service now, but because it is the default configuration, we will encounter many problems when using it. For example, the Chinese characters in it are all garbled characters, so we recommend that you configure the default file first. In the mysql-x.x.xx-winx64 (small make up is 5.6.17 according to their own version) directory, create a new my. ini. Copy the following code and save it. My. ini will replace the drop-down my-default.ini file .. The INI file is the configuration file in the window. Save various default data. The installation version allows you to select and save it to you during the installation. The zip archive is written by yourself and is the same. What is the meaning of the code syntax in it? Check the relevant information by yourself. After all, I cannot tell you one or two sentences. This file is loaded when the software is running.

Code: (Change D: \ mysql \ mysql-5.6.17-winx64 to your own software path, save)

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] # set port 3306 to port 3306 # set the mysql installation directory basedir = D: \ mysql \ mysql-5.6.17-winx64 # Set the mysql database data storage directory datadir = D: \ mysql \ mysql-5.6.17-winx64 \ data # maximum number of connections allowed max_connections = 200 # the character set used by the server defaults to the 8-bit latin1 character set character-set-server = utf8 # default storage engine default-storage-engine = INNODB

Step 4:Install mysql Service

Start a-> enter an example in the search box and then click "example". Click "execute" on the right-click "cmd.exe" and select "Administrator" to run this option. Otherwise, an error code with insufficient identity will appear. This is a feature of win7. You just need to know. If my. ini is wrong, the error code is 1067.

(You can also find the cmd.exe in the C: \ Windows \ system32directory, right-click it, and confirm it as an administrator .)

Open the cmd window as an administrator and switch the directory to the bin directory of the decompressed file. My directory is the one in the figure. Your own directory should prevail. Enter mysqld install and press enter to run the command. Note that it is mysqld, not mysql.

If the installation is successful, it will be OK. This is the result of my installation.

Then, enter net start mysql to start the service. Or you can start the mysql service manually when you open the service.

This is a simple way for Windows 7 to open the service interface. Open the Task Manager (right-click the task manager or press ctrl + alt + delete, as you like ). Click the following service and click OK. Isn't it very simple? It's much easier than the control panel method. Of course, you can also enter services. msc in the cmd window.

Step 5:Open MySQL

Or switch the directory to D: \ mysql \ mysql-x.x.xx-winx64 \ bin (x. xx. xxx is based on your own version) Input mysql-uroot-p, the default is no password. Press enter to enter. Of course, my password has been set, so you have to enter the password. If you have a password, you can use the mysql-uroot-p password, or mysql-uroot-p and press enter to enter the password. The second type is recommended. The reason is that you will know it after you start it.

Set the password: mysqladmin-u root-p password.

Exit. Remember that closing the cmd window does not exit. You need to enter exit to exit.

Although mysql is enabled, it is annoying to enter so many commands to switch directories every time you open mysql? How can this problem be solved? Of course I don't need to talk about it. I don't need to worry about it. I will tell you.

Right-click my computer-> properties-> advanced system settings-> environment variables-> path-> edit, and put the full path of the bin directory under your mysql software. I suggest you put your shoes at the beginning, and add a semicolon (;) to the path of the directory to save it. Such as D: \ mysql \ mysql-x.x.xx-winx64 \ bin;

Why? What is the principle? Simply put, the path in the environment variable is the directory path of the cmd system. How does the system know if the command has been entered? What did the system do? In fact, the system searches for all paths in the current directory and path of the system environment variable. If the first path is found, an error is returned. So we do not need to switch the cmd directory every time, or set it, and we do not need to switch the cmd path in the future.

For example, the system is like a bus. Follow the established route. The path in the environment variable is the route or station. When you arrive at the station (find the first one), get off (run ).

Now we have configured environment variables. Let's run them now!

Cmd-> mysql-uroot-p-> press enter to enter the password-> show databases; find the database-> use Database Name; switch to the database directory-> show tables; select * from table name-> exit.

Other commands are lost in database operations, so I won't go into details in the editor. You can find some related books.

Xiaobian prefers to use the cmd window to operate mysql. After you get used to it, you will find it so convenient and fast. It is much easier to use than other graphical interfaces, and you have lost the meaning of setting up a graphical interface for mysql compared to the other two databases. We strongly recommend that you do not use a graphical interface to operate mysql databases. But you can't help me. We recommend several graphical management tools:

1. phpMyAdmin

2. MySQLDumper

3. Navicat

4. MySQL GUI Tools

5. MySQL ODBC Connector

How to install these tools? I believe there will still be many tutorials like me on the Internet. You can check them out.

Additional steps:Slimming your mysql

There is no found a problem, when you download mysql compressed package only a little more than m, can extract only unexpectedly reached more than 1g, right click your mysql-x.x.xx-winx64 directory, select the attribute to check its size! Why is that? In fact, it is still the problem. mysql is an open-source database, and the source files and debug files in the database are not deleted. In fact, these files are useless and deleted. Delete dubug and deleted files. Of course, there are more than one directory. You can find it yourself, but do not delete it. Is it much smaller after deletion!

I hope you will not be confused about how to download, install, configure, and use MySQL.

Sharing is happy.