You installed it on a Windows machine, so that should have set up a service which is started automatically when Windows starts. In other words your server is always running (unless you do something to stop it).
On a modern Windows OS (You didn't told us, so I guess it's a Windows 10 client? If otherwise please note the exact Windows version.) there's the service controll panel
C:\Windows\system32\services.msc As C:\Windows\system32 is (and should be) very early in a default PATH just open run prompt (Win + R) and type services.msc should open it. This lists any services installed on the system along with their current status. So, when you install MySQL (community) server you should find an entry called "mysql server" or similar. If so, the service was installed and the status of the server is controlled by it. So, just check if the mysql service is running (should be the case by default), otherwise just start it.
Also, you should have some entries in the start menu to control the server (start and stop).
In addition to that when the MySQL server is running you should find it in TaskManager "mysqld.exe".
Note: Installing a MySQL (community) server on a Windows client can result in some odd behaviour if something goes wrong, as the installer has the very bad Windows-only habit to install the database files into C:\ProgramData (hidden by default) which can't be changed when installing the server (bad designed wizzard). So, when something goes wrong and when you just "uninstall" it often the database files remain so just "uninstall" and "re-install" can "corrupt" a MySQL server into a no longer useable state require you to remove all by hand - which can be tedious.
So, unless you really have to, I would recommend against installing MySQL (community) server on your private windows machine but rather use a 2nd machine with the linux distribution of your choice. The package managers do a way better job on correctly installing and setting up a MySQL/MariaDB (note: many distributions switched to MariaDB instead of MySQL) and even cleaning up when something goes wrong and you have to uninstall it. Even some small SoC like a RaspberryPi or an old laptop is good enough. But that's just my very personal opinion about installing a full blown database server on a personal windows machine used as developer station - for some things using some Linux distribution just is better than messing around with Windows - but I guess that's cause I have about 6 machines in my home network and 3 different OS on my laptop - so I just have the choice and hence prefer it over having just one PC used for anything.
Unfortunately, uninstallers often leave config and sometimes data directories behind in case you change your mind and want to re-install again. Although I think that Debian-based Linux distros do offer a "nuke everything" uninstall option.
So, if the database data directories are messed up, they would almost certainly have to be removed manually after uninstall before re-installing.
On the other hand, I'm suspecting that what you don't understand is how databases work. A database server does not open up a window like a desktop application does. Instead, it sits and listens for connections. Because it's a server. And unlike Microsoft SQL server, MySQL has no "control panel" app as such.
However, MySQL does have a command-line client, as do most DBMS's. And if my memory hasn't rotted too much in the 5 months since I last talked to MySQL from Windows, there should be 2 "Start Menu" applications added. Which are actually the same application, but one starts the MySQL command-line client using the desktop user's userID as the database user name and the other starts the MySQL command-line client undet the MySQL administrator id ("root"),
In either case, don't expect a GUI. There are GUI client apps available for MySQL, but they're third-party apps, not part of MySQL itself. The MySQL command-line client is just a text-mode terminal where you can type in SQL and DDL commands as well as MySQL meta-commands (to do things like select which database to use).
"privilege" comes from the Latin words for "private" and "law" (legal) and dates to feudal times. To "claim privilege" meant that you were above the laws that applied to the common people.
Tim Holloway wrote:In either case, don't expect a GUI. There are GUI client apps available for MySQL, but they're third-party apps, not part of MySQL itself.
That's true. I'm using MySQL Workbench -- it does come from MySQL but it is a separate download.
posted 1 month ago
Stephan and others,
My friend got this working on my PC using Xampp control panel.
I have not attempted to communicate with MySql through Java code yet. I'm studying my murach beginner Java book and I'm not on the database chapter yet.
posted 1 month ago
kevin Abel wrote:using Xampp
Well, I don't doubt that your pal got SOME mysql server running, but I doubt it's the one you installed but rather the one bundled with xampp.
Although there's nothing wrong with xampp to "play around" it surely poisoned the system with lot of stuff - but that's all my personal opinion as explained in my last reply. I guess as it's now "working" the topic is solved?
posted 1 month ago
I'll consider it solved for now.
Is there something I can click on to mark the topic closed?
Stephan van Hulst wrote:What executable? What are you expecting to happen?
I think his mean about the executable is, He is clicking on the executable file and after clicking it is not running.
Just follow these steps:
1. Simply download mySQL from this link: dev.mysql.com/downloads/.
2. Once it will be downloaded then extract the files.
3. I would also recommend you to move your folder into the new places in the system.
4. Create a Configuration File: