当前位置:网站首页>Database MySQL installation and uninstallation

Database MySQL installation and uninstallation

2022-08-09 08:04:00 The worst programmer

1. Uninstall

If data already exists in your system, and then you need to install the high-level version of the database, then you should first uninstall the database, the steps are as follows:
(1) Stop the mysql service: our current service name is mysql80 You mayIs another name mysql
insert image description here
(2) Then control panelUninstall the software about mysql
insert image description here
(3) delete cDelete the C:\Program Files\mysql directory under the disk

(4) Delete the C:\Program Files (x86)\mysql directory under the C drive

(5) Delete the C:\ProgramData\mysql directory under the C drive, it is a hidden directory

(6) Delete mysql in the registry.
Enter the registry first: win+R --> Enter regedit, find the MySQL directory in the registry and delete it according to the path given below

(1)HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\EventLog\Application\MySQL directory(2) HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\EventLog\Application\MySQL directory(3) HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application\MySQL directory(4) HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl001\Services\MySQL directory(5) HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl002\Services\MySQL directory(6) HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySQL directory

2. Install mysql.

My version is 5.8 now called 8.0
insert image description here
insert image description here
insert image description here
hereinsert image description
insert image description here
insert image description here
insert image description here
insert image description here
insert image description here
insert image description here
insert image description here
insert image description here
insert image description here
insert image description here
insert image description here
insert image description here
insert image description here
insert image description here
insert image description here
insert image description here

3. Turn on the service

insert image description here

4. Connect MySql

There are three ways to connect:

(1) mysql client connection

insert image description here
insert image description here
Insert picture description here
(2) The way to pass the command in cmd----must be executed in the directory where the mysql command is located.

C:\Program Files\MySQL\MySQL Server 8.0\bin
insert image description here

mysql -uroot -p-u:account username-p:password password

(3) Use a graphical interface to connect to the mysql service—navicate------->this scheme is the largest
insert image description here
insert image description here
(You can send database and graphical interface by private message)

原网站

版权声明
本文为[The worst programmer]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/221/202208090757281144.html