当前位置:网站首页>MySQL installation process (steps for successful installation)
MySQL installation process (steps for successful installation)
2022-04-23 15:09:00 【White horse is not a horse·】
To install this thing , It took me almost an afternoon , I hope you can install it foolishly , The problems in the middle help .
1. Install the package first
The data link : Version is mysql-5.7.24-winx64 Extraction code :fng5
2. Direct decompression installation
I decompressed to :F:\softfixed\jJavaSoft\mysql-5.7.24-winx64
The installation path should not have Chinese , There may be some mistakes .
2.1 Configure system variables
- New... In system variables MYSQL_HOME
1) Enter the address :F:\softfixed\jJavaSoft\mysql-5.7.24-winx64( This is the installation path above me ) - System variables path Add
1)%MYSQL_HOME%\bin - How to verify whether the addition is successful ?
1) Right click to start menu ( It's the lower left corner of the screen ), choice Command prompt ( Administrators ) , Open the black box , Knock in mysql , enter . If you are prompted Can’t connect toMySQL server on ‘localhost’ It proves that the addition is successful ; If you are prompted mysql Not an internal or external command , If it is not a runnable program or batch file, it indicates that the addition failed , Please recheck the steps and try again .
2.2 New configuration file
[mysqld]
basedir=F:/softfixed/jJavaSoft/mysql-5.7.24-winx64 // You need to change it to yourself mysql root directory
datadir=F:/softfixed/jJavaSoft/mysql-5.7.24-winx64\data // You need to change it to yourself mysql The directory data Under the document
port=3306
skip-grant-tables
notes : A backslash can be used in the path to indicate , Can avoid some mistakes
2.3 install mysql
- register MySQL service :mysqld -install
- Input again mysqld --initialize-insecure --user=mysql Initialization data file
- register MySQL service :mysqld -install
- start-up MySQL service :net start mysql
- Modify default account password :mysqladmin -u root password 1234
2.4 MySQL Login and exit
- Sign in :mysql -uroot -p1234
- sign out :exit perhaps quit
3. Where it's easy to make mistakes
- First, after the software decompression is completed , need Configure system variables , Use input mysql You can check whether it is configured , If the inspection is OK , Not yet. , It can be restarted
- Add the configuration file : Here are just five lines , The middle two lines need to be changed according to their own installation path , By default, all paths are forward slashes \, You can change , Use backslash / Replace , It may work wonders .
- Just install it step by step , This is my summary , I hope the next installation will not waste time .
版权声明
本文为[White horse is not a horse·]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204231407524635.html
边栏推荐
- C语言超全学习路线(收藏让你少走弯路)
- Leetcode151 - invert words in string - String - simulation
- [thymeleaf] handle null values and use safe operators
- Modify the default listening IP of firebase emulators
- Detailed analysis of SQL combat of Niuke database (26-30)
- Lotus DB design and Implementation - 1 Basic Concepts
- Design of digital temperature monitoring and alarm system based on DS18B20 single chip microcomputer [LCD1602 display + Proteus simulation + C program + paper + key setting, etc.]
- 1n5408-asemi rectifier diode
- win10 任务栏通知区图标不见了
- Leetcode153 - find the minimum value in the rotation sort array - array - binary search
猜你喜欢
Leetcode167 - sum of two numbers II - double pointer - bisection - array - Search
Analysis of common storage types and FTP active and passive modes
中富金石财富班29800效果如何?与专业投资者同行让投资更简单
Mysql连接查询详解
How to upload large files quickly?
On the day of entry, I cried (mushroom street was laid off and fought for seven months to win the offer)
冰冰学习笔记:一步一步带你实现顺序表
Comment eolink facilite le télétravail
Kubernetes详解(九)——资源配置清单创建Pod实战
Thread synchronization, life cycle
随机推荐
Openfaas practice 4: template operation
Go basic reflection
【thymeleaf】处理空值和使用安全操作符
Analysis of common storage types and FTP active and passive modes
UML learning_ Day2
LeetCode153-寻找旋转排序数组中的最小值-数组-二分查找
Mds55-16-asemi rectifier module mds55-16
SQLSERVER事物与锁的问题
LeetCode151-颠倒字符串中的单词-字符串-模拟
Thread synchronization, life cycle
TLS / SSL protocol details (28) differences between TLS 1.0, TLS 1.1 and TLS 1.2
Share 20 tips for ES6 that should not be missed
Subnet division of flannel principle
Thinkphp5 + data large screen display effect
How to design a good API interface?
Async void caused the program to crash
TLS / SSL protocol details (30) RSA, DHE, ecdhe and ecdh processes and differences in SSL
8.5 concise implementation of cyclic neural network
js——實現點擊複制功能
LeetCode 练习——396. 旋转函数