“This is the 17th day of my participation in the Gwen Challenge in November. Check out the details: The Last Gwen Challenge in 2021.”

Related articles

MySQL: indicates the MySQL series

Install MySQL with Widows

  • Premise: I do not recommend the use of EXE installation package to install, the reason is that if there is an error, it is difficult to uninstall clean, the following tutorial is in the form of compression package manual installation, high controllability!
  • ① Download the installation package:
  • Because MySQL is a foreign website, it is recommended to go to the mirror station to find the installation package click jump

  • Click enter to search winx64, find the right version click download!

  • (2) extract
  • Or unzip it to a fixed directory.

  • Go to the bin directory

  • Confirm decompression is 37 files, if the number of files is not correct download decompression again! Make sure the files are in order!

  • ③ Add environment variables
  • Click Add:

  • Add — your mysql installation file to the bin folder

  • ④ Edit the my.ini file and pay attention to the replacement path

  • Add content:
[mysqld]
basedir=D:\Environment\mysql-5.723.-winx64\ # here to modify the path to its own datadir=D:\Environment\mysql-5.723.-winx64\data\ # Do not create the folder manually, etc. Mysql service will automatically create port= when starting up3306# skip-grant-tables # skip password validationCopy the code
  • ⑤ Start CMD in administrator mode

  • ⑥ Enter mysqld –initialize — insecure –user=mysql to initialize the data file
  • Mysql -u root -p mysql -u root -p
  • 8 Change the root password
update mysql.user set authentication_string=password('123456') where user='root' and Host = 'localhost';
Copy the code
  • ⑨ Refresh Permission
flush privileges;
Copy the code

  • ⑩ Delete skip-grant-tables from the my.ini file

  • Finally: Restart mysql to normal use

Install MySQL on Linux

  • Two articles teach you how to install MySQL
  • MySQL installation
  • Enable remote connection permission
  • Pro test can succeed oh! I’m not going to rewrite it all, because it’s not as easy as manual installation on Windows.

The road ahead is long, I see no end, I will search high and low

If you think I bloggers write well! Writing is not easy, please like, follow, comment and give encouragement to the blogger ~ Hahah