Mysql download installation, configuration and use tutorials Detailed edition (win7x64) _mysql

After using MySQL, regardless of capacity, found more useful than the other two (SQL Server, Oracle), and suddenly like it. Here's how to write down the steps for children's shoes that you don't know how to get.

I write a bit too detailed, even some cumbersome, there are many steps in the other tutorial documents are omitted, but I still have to write out, because I took a lot of detours, I hope you can avoid the detours I go. Of course, know the students can skip, choose you want to know where to see.

Tools:

Computer Win7 64bit

Method/Step:

The first step: download

A. As the saying goes: "Ching"! I'm using the zip Archive version, and the Win7 64-bit machine supports this, so I suggest using this. Because it's simple, and it's clean.

Address See map

Down to the bottom, see clearly 64bitZIP Archive, click Download.

B. After the opening will enter another page, but did not start downloading, this time do not fear, do not understand, you just know he is to let you login (login), or application account (sign up) on the line, login or successful application will start downloading. (Remember password to combine letters and numbers, letters to have uppercase)

C. Note: Passwords should be combined with letters and numbers, letters should have capitals

D. Of course, if you have an account, you can also log in directly

Click Downnow after success. The file is not large, only 200 m, very quickly, wait a moment (after success is logically said to have reached the following place, but if you do not know this, you find yourself, or directly exit, repeat the above steps, choose the login that just.

In a word, MySQL is open source (open source) database, the so-called open source is to be able to view the sources of code, I believe that many children's boots will be interested in this. So where does the source code go?

At the time of the first step-(the one at the beginning of the picture). There is a select Platform, select the following source code on the line.

(Similarly, if you want to download the Linux platform under the MySQL is here to find)

Download complete, start installation and configuration below

Step Two: installation (decompression)

The ZIP archive version is free of installation. Just unzip it on the line. It's no different from the installation version, but it just doesn't need to be installed. Find the Download Mysql-x.x.xx-winx64.zip right button selection (extract to ... , find the place you want to install, like to put C: the choice of C: disk, do not like to choose their own, small series like to put D: disk, after all, C: system disk put things too bad. After the decompression is OK, is it very simple? Know the benefits of the ZIP archive version?

Are you going to ask? How do you use it? Bin point inside of MySQL. EXE how come out a black window is not responding?

No response because the service hasn't been opened yet!

It's not open, is it?

The service is not yet installed!

How do I install it?

Let's Talk!

Step Three: Configure the default file

In fact, in theory now this can be directly installed services, but because it is the default configuration, we use when there are many problems. For example, the Chinese characters are all garbled and so on, so I suggest you configure the default file first. In Mysql-x.x.xx-winx64 (small series is 5.6.17 according to own version to decide) under the directory, create a new My.ini. Copy the following code to save it OK. My.ini will replace the following My-default.ini file. The. ini file is the configuration file inside the window. Save the various default data inside. The installation version of the installation is to let you choose and then the system to save you in, Zip archive is their own write, are the same. What does the code grammar mean? Children's shoes to check the relevant information. After all, I can't say one or two words. This file is loaded while the software is running.

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

[MySQL]

# set MySQL client default character set

Default-character-set=utf8

[mysqld]

#设置3306端口

port = 3306

# set MySQL installation directory

basedir=d:\mysql\mysql-5.6.17-winx64

# Set up a directory of MySQL database data

datadir=d:\mysql\mysql-5.6.17-winx64\ Data

# allows maximum number of connections

max_connections=200

# The character set used by the service side defaults to a 8-bit encoded latin1 character Set

Character-set-server=utf8

# The default storage engine to use when creating a new table

Default-storage-engine=innodb

Fourth Step: install MySQL Service

A start-> in the face of the search bar inside the input cmd, which will come out a cmd.exe, do not busy point to determine, to right this cmd.exe select an administrator to run this option. Otherwise there will be a lack of identity error code, the specific number of forgotten. This is a feature of Win7. You know, that's fine. If My.ini write wrong, the error code is 1067.

(You can also find this cmd.exe in the C:\Windows\System32 directory, as well as right-clicking it as an administrator.) ）

As an administrator to open the cmd window, the directory to switch to the file you extracted the bin directory, my directory is the figure inside that, your words, to your own directory as prevail. Then enter mysqld install carriage return run on the line, note is mysqld, not MySQL

It's OK to have a successful installation. I have already installed, so this is the result.

Then you start the service in the input net start MySQL. Or not too much trouble on the manual, open the service manually started the MySQL service.

Tell everyone a simple way to Win7 open the service interface. Open Task Manager (right-select Task Manager or Ctrl+alt+delete, whatever you like). Point below the service is OK, is not very simple, than the control panel that way a lot simpler. Of course, you can also enter services.msc in the CMD window is also possible.

Fifth step: open MySQL

or switch the directory to D:\mysql\mysql-x.x.xx-winx64\bin (X.xx.xxx what is based on your version) input mysql-uroot-p, the default is no password. Enter the entry, of course, my password has been set, so you need to enter a password to go. There is a password, you can mysql-uroot-p password, but also can be mysql-uroot-p enter the password, recommend the second, the reason, you know after the hands.

How to set a password: mysqladmin-u root-p password password.

You can exit the exit. Remember to directly close the CMD window is not exited, to enter exit will exit AH.

Although open MySQL, but every time you open MySQL to enter so many instructions to switch directories is not very annoying? How do you do it? Of course I do not have to say, will not have to worry, I will tell you.

Right-click My Computer-> Properties-> advanced system settings-> environment variable->path-> Edit, put the full path of the bin directory under your MySQL software. I suggest that children put them in the front, and then add an English semicolon (;) to the path behind that directory and save the line. such as D:\mysql\mysql-x.x.xx-winx64\bin;

Why do you do that? What is the principle? The simple way of saying the environment variables inside the path is this thing, is the CMD system's lookup directory path. You enter an instruction, how does the system know this instruction is there? What did the system do? In fact, the system is in the current directory and system environment variables path inside all look for one side, find the first, the error is not found. So we either switch the cmd directory every time, or set up, and then do not need to switch the cmd path.

For example, the system is like a bus. Follow the established route. The path within the environment variable is that route or station. When you get to the station (find the first one) get Off (run).

Now we have the environment variable, let's run it!

Cmd->mysql-uroot-p-> Enter password->show databases; Find database->use database name; Toggle database directory->show tables; lookup Table-> SQL query Work select * FROM table name->exit exit.

Other instructions are the database operation of the matter, small series will not repeat, you can find some related books.

Small series is more like using the cmd window to operate MySQL, you used to find that he is so convenient and quick. It's much better than that graphical interface, and the fact that you've got a graphical interface to MySQL loses the good sense of the other two databases. Small series strongly do not recommend the use of graphical interface to operate the MySQL database. But if you really want to use me, there's no way. Recommend a few graphical management tools for you:

1, phpMyAdmin

2, Mysqldumper

3, Navicat

4. MySQL GUI Tools

5, MySQL ODBC Connector

How to install these tools I believe there will be many like me on the Web tutorials, we can look for a look.

Additional steps: slimming for your MySQL

has not found a problem, you download the MySQL compression package only a little more than 200M, can decompress only unexpectedly to reach unexpectedly 1G more, right button your mysql-x.x.xx-winx64 directory, select attributes to see his size bar! Why is this, in fact, or that problem, MySQL is open source database, inside the source files and debug files are not deleted, these files in fact, there is nothing to use, delete it. Delete dubug files and. pdf files. Of course there is more than this one, find it yourself, but do not delete the wrong. After the deletion is not found small more special!

is not very fruitful, I hope you do not think I wordy oh, share the MySQL download installation, configuration and use of the specific steps, I hope you like.

To share is to be happy.

Wonderful topic sharing: MySQL different versions of the installation Tutorials mysql5.7 version Installation Tutorials

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.