Win a copy of Transfer Learning for Natural Language Processing (MEAP) this week in the Artificial Intelligence and Machine Learning forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Paul Clapham
  • Devaka Cooray
  • Bear Bibeault
Sheriffs:
  • Junilu Lacar
  • Knute Snortum
  • Liutauras Vilda
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Piet Souris
Bartenders:
  • salvin francis
  • Carey Brown
  • Frits Walraven

MySQL install not working

 
Ranch Hand
Posts: 151
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I hope that JDBC is the correct Forum to post this.

I downloaded and installed MySQL as well as the Prerequisites.   The directory was created on my C: drive.  I click on the executable and nothing happens.

Thanks,

Kevin
 
Saloon Keeper
Posts: 11881
253
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What executable? What are you expecting to happen?
 
Marshal
Posts: 25436
65
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).
 
Ranch Foreman
Posts: 95
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Saloon Keeper
Posts: 21960
149
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oh, goodie. Scrambled directories.

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).
 
Paul Clapham
Marshal
Posts: 25436
65
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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.
 
kevin Abel
Ranch Hand
Posts: 151
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Paul,
Tiim,
Bob,
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.

Thanks,

Kevin
 
Bob Winter
Ranch Foreman
Posts: 95
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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?
 
kevin Abel
Ranch Hand
Posts: 151
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Bob,
I'll consider it solved for now.
Is there something I can click on to mark the topic closed?
Thanks,
Kevin
 
Paul Clapham
Marshal
Posts: 25436
65
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If it's a Windows box then you can load a lot of unused stuff on it without issue. Anyway I agree that the issue is solved for you so I've marked it as such.
 
Sheriff
Posts: 7051
184
Eclipse IDE Postgres Database VI Editor Chrome Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

kevin Abel wrote:Is there something I can click on to mark the topic closed?


Just below the Post Reply button there may be a checkmark button.  Press that.
 
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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:

5. Then test your installation.

6. Change your root password
7. Install MySQL as a Windows service

This all will help you to complete the MySQL Installation.
 
Forget Steve. Look at this tiny ad:
Two software engineers solve most of the world's problems in one K&R sized book
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic