Comments - Installation issues on Windows
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
A/ Error Get following error when trying to install MariaDB 11.2 (x64) first time via Setup:
The TCP Port you selected is already in use. Please choose a different port
B/ Actions Have performed several actions to remove any MySQL service (does not exist), checked which ports windows machine is using via netstat (it does not use TCP port 3306), and many other suggested actions
C/ Windows machine is not using TCP port 3306???
D/ Further information 1/ have not installed MySQL 2/ machine Device name Z170M-PLUS Processor Intel® Core(TM) i7-6700 CPU @ 3.40GHz 3.40 GHz Installed RAM 8.00 GB (7.90 GB usable) Device ID 1A5B0727-B7DC-47C4-83C1-EC93517AF434 Product ID 00330-71294-30096-AAOEM System type 64-bit operating system, x64-based processor Pen and touch No pen or touch input is available for this display
3/ Windows specifications Edition Windows 10 Pro Version 22H2 Installed on 5/02/2021 OS build 19045.3693 Experience Windows Feature Experience Pack 1000.19053.1000.0
I Downloaded MariaDB 10.1.21 Win32 version and tried to install on Windows 7 SP 1.
But halfway through the installation, the installer stops and just rolls back the installation. I don't get any error messages.
I tried to install from Administrator Command Prompt also, but I still get the same result.
What is the problem?
Regards, Srik
I'm having an issue: I followed instructions (kb.askmonty.org/v/installing-mariadb-windows-zip-packages) for mariadb 5.5.33a, and can't get it to install/run.
I tried several things (and didn't keep track of what I did or the results: bad idea, I know). However, what I'm stuck with now is when I attempt to run
"mysql_install_db.exe --datadir=c:\mydatabase --service=mydb --passwork=root"
I get the response:
Running Bootstrap Removing default user Setting root password Creating my.ini file Registering service 'Mydb' FATAL ERROR: OpenSCManager failed (5)
(instructions on how to get to here)
Any idea what is going on, or what I can do to get back to some of the old errors I was getting (which might be more informative)?
Hi,
If you are running Windows 7 or alike, please make sure you execute the command from a command prompt started as Administrator. Even if you think you are a privileged user, Windows tends to disagree. I'm getting the same error if I start command prompt in a usual way, but if I do it via 'Run as Administrator' option, it looks much better.
Thanks. Worked like a charm.
Should that be added to this page, for everyone (like me) who misses that little detail?
It was actually mentioned at mysql_install_db.exe page: "to create a Windows service, mysql_install_db.exe should be run by a user with full administrator privileges (which means elevated command prompt on systems with UAC)."
But I agree that this win-speak might be unclear. I added a note about 'Run as administrator' to mysql_install_db.exe and to this article.