First time on XAMPP - MySQL installation error - 2

[RossaK]

Hi,

Following to the query on My SQL startup help needed, here is the message I get on command line interface on Shell:

<Welcome to MariaDB monitor.
Your MariaDB connection is 2.>

Should it be giving a message as :
<Welcome to MySQL monitor.>

I was referrring to your answers on :
[Q&A] Setting MySQL root password

Please guide.

[Nobbie]

I cannot see any error here? You get a different prompt, the documentation seems outdated, as Xampp does not install MySQL but MariaDB instead. But the message (the prompt) looks fine. Simply go on and enter your SQL Statements.

[RossaK]

Hi Nobbie,

Thanks for a heads up. However, when I try to access http://localhost/phpmyadmin/
Below message appears:

<Unable to connect

Firefox can't establish a connection to the server at localhost.

The site could be temporarily unavailable or too busy. Try again in a few moments.
If you are unable to load any pages, check your computer's network connection.
If your computer or network is protected by a firewall or proxy, make sure that Firefox is permitted to access the Web.>


and if I try with - http://10.1.13/phpmyadmin/

<The connection has timed out

The server at 10.1.13 is taking too long to respond.

The site could be temporarily unavailable or too busy. Try again in a few moments.
If you are unable to load any pages, check your computer's network connection.
If your computer or network is protected by a firewall or proxy, make sure that Firefox is permitted to access the Web.>

So I am not able to access http://localhost/phpmyadmin/
Everything is fine on the command line till steps 1a.IV. as per the instructions in - [Q&A] Setting MySQL root password
MariaDB connection id is 2
Server Version: 10.1.13
Please help me with what am I missing here.

[Altrea]

Is Apache started?

[JJ_Tagy]

and if I try with - http://10.1.13/phpmyadmin/

10.1.13 is a server version, not an IP address. That would not have worked anyways.

[Nobbie]

10.1.13 is a server version, not an IP address. That would not have worked anyways.

OMG ... you have good eyes! I did not see that, i thought that this is a LAN IP like 10.1.1.13 or similar, i did not see that there is missing one part...

[RossaK]

Is Apache started?

HI Altrea/ Nobbie,

No, Apache didn't start. Shows bellow error:

"The Program can't start because api-ms-win-crt-runtime-I1-1-0.dll is missing from your computer. Try re-installing the program to fix this problem."

Few workarounds I did:

>I turned off port 443 from Skype, following instructions given in:
[Q&A] solving Port 80 & 443 in use by Skype issue

> I found one more instruction in query - Error: Apache shutdown unexpectedly.
Here a resolution given takes me to a blog - http://blog.garethjmsaunders.co.uk/2015/12/23/xampp-apache-wont-start-on-windows-10-a-fix/

It suggests to Stop World Wide Web Publishing Service, which I don't seem to have in my list of services.msc

Now, it seems my computer is missing some service which I might need to install. Only that I cannot figure out, what could it be.

and if I try with - http://10.1.13/phpmyadmin/

10.1.13 is a server version, not an IP address. That would not have worked anyways.

JJ - Thanks for making it clear, what I misunderstood.

[Nobbie]

" Try re-installing the program to fix this problem."

Few workarounds I did:

Instead you should google for that message "The Program can't start because api-ms-win-crt-runtime-I1-1-0.dll is missing from your computer", it will give you tons of hints how to fix that issue. You will have to install the appropriate Visual C++ Redistributable.

[RossaK]

Instead you should google for that message "The Program can't start because api-ms-win-crt-runtime-I1-1-0.dll is missing from your computer", it will give you tons of hints how to fix that issue. You will have to install the appropriate Visual C++ Redistributable.

Well, it seems yet few steps to go to have the Apache ready to work. As getting error 0x80240017 on trying to install Microsoft Visual C++ 2015 Redistributable
Found a helpful blog on handling this error - https://www.reddit.com/r/techsupport/comments/464swn/microsoft_visual_c_2015_redistributable_setup/

I shall get back once I am done. :p

[jad albert]

Hi,

Following to the query on My SQL startup help needed, here is the message I get on command line interface on Shell:

<Welcome to MariaDB monitor.
Your MariaDB connection is 2.>

Should it be giving a message as :
<Welcome to MySQL monitor.>

I was referrring to your answers on :
[Q&A] Setting MySQL root password

Please guide.

I was getting same error last time but after re-configuration i went away. This error often occurs due to poor configuration.