MySQL

Install

reference

Issue

Access denied for user ‘root’@’localhost’ (using password: YES)

reference

1. Add ‘skip-grant-tables’ to ‘my.ini’ file in MySQL’s directory

   

2. Reload the MySQL’s service

   net stop mysql
   net start mysql

3. Login MySQL without password and set the new password

   mysql -u root -p
   // Don't need to enter the password

4. Change the password (In the higher version, the password filed is changed to authentication_string)

   # lower version
   update mysql.user set password='123' where user='root';
   -- higher version
   update mysql.user set authentication_string='123' where user='root';
   /*password -> authentication_string*/

5. Refresh the database

   flush privileges;

6. Delete the ‘skip-grant-tables’

7. Reload the MySQL’s service

Server returns invalid timezone. Go to ‘Advanced’ tab and set ‘serverTimezone’ prope

reference

Navicat

Install

official website

Crack

Issue

rsa public key not find

copy the keygen to the installation directory and run as an administrator

No All Pattern Found！File Already Patched?

1. Click the installation file to re install Navicat
2. First run the keygen, and then open Navicat

Navicat program flutters back or no respond

Close the netease youdao dictionary