MySQL is a well known and open-source relational data set application. In this way, numerous servers utilize MySQL. The manner in which you access the data set relies upon the working framework from which you are working.
The primary console utilities for working with MySQL are situated in the directory where MySQL Server is installed. However, in the wake of introducing MySQL Server, finding this directory is frequently difficult. The most ideal way is to add this way to your PATH environment variable, and afterward you can utilize MySQL and mysqldump utilities straightforwardly.
MySQL is an incredibly famous open-source RDMS, and it’s generally utilized by millions of organizations and professionals. In this article, you will figure out how to check the ongoing MySQL version, and how to refresh it if vital.
To utilize Media Server with a MySQL data set, you should download and introduce a MySQL server and ODBC driver, and configure Media Server to connect to the information base through the driver.
How to find the MySQL installation directory on Windows via UI
MySQL for Windows is administration based. To find the MySQL installation directory, take a gander at the executable record specified in the MySQL Service. To see the worth, adhere to the instructions underneath:
- Press Win+R
- Type services.msc
- Find MySQL administration in the list, it is normally named as MySQL [version number], for instance, MySQL 80
- Click on it with the right mouse button and select “Properties”
- The way to the mysqld.exe document should be visible in the “Way to executable” field
How to Find MySQL Installation Directory Using the Command Line
All actions that you do in the Windows UI can be performed utilizing a PowerShell script.
The accompanying long PowerShell order shows the way to the MySQL installation directory:
How to Add the Path to the MySQL Server to Environment Variables
- Press Win+S to open an inquiry box on your PC.
- Begin composing “Environment” in the Windows search text box and select the “Alter the framework environment factors” option in the “Best match” list.
- In the “Framework Properties” window that opens, you will find tabs, for example, “PC Name,” “Equipment” and other additional properties. Go to the “High level” tab and snap the “Environment Variables” button at the bottom. On this tab, you can likewise set the boundaries “Execution,” “Client Profiles” and “Startup and Recovery.”
- The “Environment Variables” window will open. It is partitioned into two fields with client factors and framework factors, where all factors and their qualities are displayed. Find “Way” factors in the “Framework factors” field as shown in the screen capture above.
- Double tap on the “Way” factor to open a list with all Path factors, in which Path factors can be altered, added, or eliminated.
- Press the “New” button and enter another way, for instance, “C:\Program Files\MySQL\MySQL Server 8.0\bin\”, in another editable line.
- Click OK to save the new PATH variable. However, for these progressions to influence your order brief window, you want to open it once more.
Another window will send off and display the list of administrations accessible on your framework. Look down to track down MySQL, and check the status section. Passed on click the MySQL administration to feature it, then right-snap to open a context menu. At long last, left-click on start.