当前位置:网站首页>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
边栏推荐
- adobe illustrator 菜單中英文對照
- eolink 如何助力远程办公
- asp. Net method of sending mail using mailmessage
- About UDP receiving ICMP port unreachable
- 牛客网数据库SQL实战详细剖析(26-30)
- How does eolink help telecommuting
- Redis主从同步
- Kubernetes详解(十一)——标签与标签选择器
- Basic operation of circular queue (Experiment)
- 免费在upic中设置OneDrive或Google Drive作为图床
猜你喜欢
How to upload large files quickly?
Detailed explanation of C language knowledge points -- first understanding of C language [1] - vs2022 debugging skills and code practice [1]
8.4 realization of recurrent neural network from zero
如何设计一个良好的API接口?
Mds55-16-asemi rectifier module mds55-16
LeetCode165-比较版本号-双指针-字符串
LeetCode162-寻找峰值-二分-数组
Nuxt project: Global get process Env information
Is asemi ultrafast recovery diode interchangeable with Schottky diode
Thread synchronization, life cycle
随机推荐
Have you really learned the operation of sequence table?
Introduction to dirty reading, unrepeatable reading and phantom reading
Compiling OpenSSL
脏读、不可重复读和幻读介绍
Share 20 tips for ES6 that should not be missed
Have you learned the basic operation of circular queue?
Leetcode167 - sum of two numbers II - double pointer - bisection - array - Search
OPPO数据湖统一存储技术实践
Little red book timestamp2 (2022 / 04 / 22)
When splicing HQL, the new field does not appear in the construction method
Detailed comparison between asemi three-phase rectifier bridge and single-phase rectifier bridge
Fill in the next right node pointer II of each node [classical hierarchy traversal | regarded as linked list]
Swift protocol Association object resource name management multithreading GCD delay once
SSH connects to the remote host through the springboard machine
Provided by Chengdu control panel design_ It's detailed_ Introduction to the definition, compilation and quotation of single chip microcomputer program header file
C语言超全学习路线(收藏让你少走弯路)
Kubernetes详解(九)——资源配置清单创建Pod实战
JS -- realize click Copy function
Sqlserver transaction and lock problem
SQLSERVER事物与锁的问题