I will give you a link. This is the first time I installed it. Very easy to understand.
/article/59703552 1 D5 de 28 fc 00740 e 6 . html
After using MySQL, regardless of the capacity, I found it was much better than the other two (sql server, oracle) and liked it at once. Write down specific methods and steps for those children's shoes that don't know how to make them.
I wrote this in a bit too detailed, even a bit cumbersome. Other tutorial documents omit many steps, but I still want to write them because I took many detours at that time. I hope you can avoid these detours I took. Of course, you can skip what you know about your classmates and choose what you want to know.
Tools/raw materials
Computer win 7 64-bit
Methods/steps
1
The first big step: download.
A. As the saying goes, "A clever woman can't cook without rice"! I'm using the ZIP archive version here, and win7 64-bit computer supports this, so I suggest everyone use this. Because it is simple and clean.
The address is as shown in the figure: /downloads/mysql/
Pull down the bottom to see the 64-bit Zip archive clearly, and click Download.
2
B. After clicking, you will enter another page, but you haven't started downloading yet. Don't be afraid at this time. It doesn't matter if you don't understand. You just need to know that he wants you to log in or apply for an account (registration). After the login or application is successful, the download begins. Remember that the password should be a combination of letters and numbers, and the letters should be capitalized.
C. note: the password should be a combination of letters and numbers, and the letters should have capital letters.
four
D. Of course, if you have an account, you can also log in directly.
five
Click DownNow after success. The file is not big, only more than 200 m, so it is very fast. Wait a moment (you should arrive at the following location after success, but if you don't know this, you can find it yourself, or just quit, repeat the above steps and choose to log in.
six
By the way, MySQL is an open source database. The so-called open source means that you can view the source code. I believe many children's boots will be interested in this. So where do you download the source code?
When I first entered-(the address of the first picture). If you have a choice of platform, just select the source code below.
(Similarly, if you want to download MySQL under the linux platform, you can also find it here. )
After downloading, let's start installing the configuration.
seven
Step 2: Installation (Decompression)
ZIP archive version is installation-free. Just decompress. It is no different from the installed version, but it does not need to be installed. Locate the downloaded mysql-x.x.xx-winx64.zip and right-click (unzip it to ...), and find the place to install it. If you like to play C disk, choose C disk. If you don't like it, just choose one. Bian Xiao likes to play D disk. After all, C: It is not good to put too many things on the system disk. It's ok after decompression, isn't it simple? See the benefits of ZIP archiving?
eight
Do you want to ask? How to use it? Mysql is at \bin. Exe, why is a black window not responding?
Because the service has not been opened, there is no response!
It didn't open. Will it be good to open it?
The service has not been installed!
How to install it?
Let's talk below!
nine
Step 3: Configure the default file.
In fact, in theory, you can install the service directly now, but because it is the default configuration, there will be many problems when we use it. For example, the Chinese characters in it are all garbled, so I suggest you configure the default file first. Under mysql-x.x.xx-winx64 (5.6. 17 is based on its own version), create a new my.ini and copy the following code and save it. My.ini will replace the following my-default.ini file. Yes. The ini file is the configuration file in the window. Save all kinds of default data in it. The installation version is selected by you during installation, and then the system will save it for you. Zip archive is written by myself, and it is the same. What does the code syntax mean? Children's shoes check the relevant information yourself. After all, I can't say a word or two clearly. This file is loaded when the software runs.
10
Code: (change d: \ MySQL \ MySQL-5.6.17-winx64 to your own software path to save).
[mysql]
# Set the default character set for mysql clients
default-character-set=utf8
[mysqld]
# Set port 3306
Port = 3306
# Set mysql installation directory
basedir = D:\ MySQL \ MySQL-5 . 6 . 17-winx 64
# Set the storage directory of mysql database data
datadir = D:\ MySQL \ MySQL-5 . 6 . 17-winx 64 \ data
# Maximum number of connections allowed
max_connections=200
# The default character set used by the server is 8-bit coded latin 1.
character-set-server=utf8
# Default storage engine used when creating new tables
Default storage engine =INNODB
1 1
Step 4: Install mysql service.
A start->; Enter cmd in the search field of surface, and a cmd.exe will appear. Don't confirm it quickly. Right-click this cmd.exe and select Administrator to run this option. Otherwise, there will be an error code with insufficient identity, and the specific number has been forgotten. This is a feature of win7. It's good to know. If my.ini is misspelled, the error code is 1067.
(You can also find this cmd.exe in the directory C:\Windows\System32, and right-click to confirm that it is the administrator. )
12
After opening the cmd window as an administrator, switch the directory to the bin directory of the unzipped file. My catalog is the one in the picture. If you speak, please refer to your own catalogue. Just enter mysqld to install and run. Note that it is mysqld, not mysql.
It will be ok if the installation is successful. I have installed it, so this is the result.
Then enter net start mysql to start the service. Or don't bother to start mysql service manually by opening the service.
13
Tell you a simple way to open the service interface in win7. Open the task manager (right-click the task manager or ctrl+alt+delete as required). Just click on the service below, isn't it simple? This is much simpler than the control panel method. Of course, you can also enter services.msc in the cmd window.
14
Step 5: Open MySQL.
Or switch the directory to d: \ MySQL \ MySQL-x.x.xx-winx64 \ bin (x.xx.xxx according to your own version) and enter MySQL-uroot-pp. By default, there is no password. Get in the car, get in. Of course, my password has been set, and I have to enter it before I can enter. If you have a password, you can use mysql -uroot -p password, or you can enter the password in MySQL-uroot-p. We recommend the second one, because you will know it after you do it.
Method of setting password: mysqladmin -u root -p password.
Quit. quit. Remember that closing the cmd window directly does not exit, only entering exit will exit.
15
Although mysql is opened, is it annoying to input so many instructions to switch directories every time you open mysql? How? Of course, I don't need to say it, and there is no need to worry. I'll tell you.
Right-click my computer-> Attribute-> Advanced system settings-> Environmental variables->; Path->; Edit and put the full path of the bin directory under your mysql software. It is suggested that children's shoes should be put in front, and an English semicolon should be added at the end. ) save it. Such as d: \ MySQL \ MySQL-x.x.xx-winx64 \ bin;
Why are you doing this? What is the principle? Simply put, the path path in the environment variable is the search directory path of the cmd system. You enter an instruction, how does the system know whether this instruction exists? What did the system do? In fact, the system searches all paths in the current directory and the system environment variable path, whichever is the first. If it is not found, an error will be reported. So we either switch the cmd directory every time or set it, so there is no 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 each stop. Get off (run) (find the first one) when you get to the station.
16
Now that the environment variables are ready, let's run them again!
cmd->； MySQL-u root-p-& gt； Enter the password-> Display database; Database found-> Use database name; Switch database directory-> Display table; Lookup table->; Sql query work select * from table name-> Exit. exit.
Other instructions are all about database operation, so I won't repeat them in Bian Xiao. You can find some related books.
17
Bian Xiao prefers to use the cmd window to operate mysql. After getting used to it, you find it so convenient and fast. It's much better than that graphical interface. If you install a graphical interface for mysql, it will lose its meaning relative to the other two databases. Bian Xiao strongly recommends that you use the graphical interface to operate the mysql database. But if you really want to use it, I can't help it I recommend several graphical management tools to you:
1、phpMyAdmin
2、MySQLDumper
3、Navicat
4. MySQL graphical user interface tool
5. MySQL ODBC connector
How do I install these tools? I believe there will still be many tutorials like mine online. You can go to them.
18
Additional steps: streamline your mysql
Did you find the problem? When you download the mysql compressed package, it is only a little more than 200M, and the decompressed package reaches an unexpected high of1g. Right-click your mysql-x.x.xx-winx64 directory and select Properties to view its size! Why is this happening? Actually, it's still the same problem. Mysql is an open source database, and the source files and debugging files in it have not been deleted. These documents are actually useless, just delete them. Delete the dubug file and. Pdf file. Not just in this catalog, of course. Look for it yourself, but don't delete it wrong. After deleting it, did you find it much smaller!
end
Matters needing attention
There are still some mistakes not mentioned in it. You can copy the error code Baidu. I believe that others can meet the mistakes you can meet.
Be patient when encountering problems, and solving problems is a big step forward. Don't be afraid to encounter problems. Every problem you encounter now will be your future wealth.
Thank you for taking the trouble to see me say so much.