Mysql 64-bit installation

I really spent the whole afternoon on installing ...

Download the free installation version of the website, first to write their own configuration files, and then, login not on, solve a problem after another, thought can be counted the end ... Finally more direct, the program is not connected, see the online countless posts, what server did not open, JDBC package with mybatis incompatible, and so on ...

Originally just want to install a software, and finally become half a MySQL brick home, tried n ways ... Ready to give up, you guess what the problem?

Port specified Error!!!!!!!

However, my profile is clearly written in 8877! Why did you change it to 3306????? I can't think of a problem in my head.

Why is this???? When I solve, and then tell the guys, or you know, please tell me, thank you!

Posted below: 64-bit free installation note (refer to some users)

After decompression directly to the bin directory click Mysql.exe, that is not responding, because not registered.

(1) After decompression, there is a configuration file below the directory:

Modify the following configuration file: can be modified as follows (very simple, specifically to adjust, after adding)

And then:

If this problem occurs when you sign in (congratulations, the netizen said this rarely appears):

Tried a lot of ways, before we found this can be used

Mysql

ERROR 1045 (28000): Access denied for user workaround

Problem Recurrence (The following discussion is for Windows environments only):

C:\appserv\mysql> mysql-u root-p Enterpassword:

ERROR 1045 (28000): Access denied for user root ' @ ' localhost ' (using Password:yes)

Edit the MySQL profile My.ini (do not know where to search), add under [mysqld] This entry

Skip-grant-tables save quit and restart MySQL

1. Click "Start", "Run" (shortcut key Win+r).

2. Start: Enter net stop MySQL

3. Stop: Enter net start MySQL

At this time in the cmd input mysql-u root-p can be used without password login, appear password: When the direct return can enter, will not appear error 1045 (28000), but many operations will be limited, because we can not grant (no permission). Follow the process below (the red part is the input section, the pink One is the code shown after the execution does not have to be entered):

1. Go to MySQL database:

mysql> use MySQL;

Database changed

2. Set a new password for the root user, and enter the blue part yourself:

mysql> Update User Setpassword=password ("New password") where user= "root";

Query OK, 1 rows affected (0.01 sec) rowsmatched:1 changed:1 warnings:0

3. Refreshing the database

Mysql>flush privileges;

Query OK, 0 rows Affected (0.00 sec)

4. Exit

Mysql:mysql>quit

Bye

After the change, then modify the My.ini this file, we just joined the

"Skip-grant-tables" This line delete, save exit and then restart MySQL will be OK.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Mysql 64-bit installation