当前位置:网站首页>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
边栏推荐
- Daily question - leetcode396 - rotation function - recursion
- 大文件如何快速上传?
- When splicing HQL, the new field does not appear in the construction method
- Vscode Chinese plug-in doesn't work. Problem solving
- Brute force of DVWA low -- > High
- 免费在upic中设置OneDrive或Google Drive作为图床
- JUC学习记录(2022.4.22)
- 牛客网数据库SQL实战详细剖析(26-30)
- Application of skiplist in leveldb
- Explanation and example application of the principle of logistic regression in machine learning
猜你喜欢
Bingbing learning notes: take you step by step to realize the sequence table
setcontext getcontext makecontext swapcontext
免费在upic中设置OneDrive或Google Drive作为图床
Analysis of common storage types and FTP active and passive modes
win10 任务栏通知区图标不见了
How does eolink help telecommuting
Kubernetes详解(十一)——标签与标签选择器
UML learning_ Day2
What is the role of the full connection layer?
Have you learned the basic operation of circular queue?
随机推荐
Leetcode149 - maximum number of points on a line - Math - hash table
Openfaas practice 4: template operation
LeetCode149-直线上最多的点数-数学-哈希表
LeetCode165-比较版本号-双指针-字符串
1n5408-asemi rectifier diode
封面和标题中的关键词怎么写?做自媒体为什么视频没有播放量
Little red book timestamp2 (2022 / 04 / 22)
tcp_ Diag kernel related implementation 1 call hierarchy
C语言超全学习路线(收藏让你少走弯路)
Application of skiplist in leveldb
eolink 如何助力远程办公
Comparaison du menu de l'illustrateur Adobe en chinois et en anglais
Nacos program connects to mysql8 0+ NullPointerException
January 1, 1990 is Monday. Define the function date_ to_ Week (year, month, day), which realizes the function of returning the day of the week after inputting the year, month and day, such as date_ to
Nuxt project: Global get process Env information
Modify the default listening IP of firebase emulators
[thymeleaf] handle null values and use safe operators
Alexnet model
博睿数据携手F5共同构建金融科技从代码到用户的全数据链DNA
Is asemi ultrafast recovery diode interchangeable with Schottky diode