Mysql Installer... cannot start the server

Hello Experts,
I am trying to install MYSQL server on a virtual server that already has POSTGRESQL

and the process fails at START SERVER as shown in the image...

Please your advice
aa.png
RGuillermoProject ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tom CieslikIT EngineerCommented:
Check MYSQL installation log, what is causing this error

%PROGRAMDATA%\MySQL\MySQL Server 5.7\
0
RGuillermoProject ManagerAuthor Commented:
Tom, my most recent log file in that location is ib_logfile1_2017-12-12T15-46-25 size 49 k
but I cannot read it...
tried with notepad and shows blank....
Is there a tool to read those ?
0
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
and the process fails at START SERVER as shown in the imag
I encountered similar error before... which could  be a permission error that trying to run/ write something (could be write to the log file).

you got to give enough permission to relevant folder(s) for your MySQL.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

skullnobrainsCommented:
ib_logfile_whatever is one of innodbs log files. binary format, fixed size. don't expect to read anything and it's probably empty since the db never started.

the my.cnf ( and possibly included files ) should contain the location of the error log. it should default to a HOSTNAME.err file in the same location as the iblog stuff you mentioned. ( whatever *.err file should be the one )

you can also start mysqld manually from the above mentioned directory. most likely the problem will be logged on screen. if not, you can append '--console' to the startup arguments which instructs the mysql server to log to screen. this can help debugging with different users for example.
0
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
if it's windows base you can also verify if there's any errors in the Event Viewer.
0
NerdsOfTechTechnology ScientistCommented:
Let us know which OS you are running. If Windows, check to see if windows firewall or your antivirus is preventing MySQL's port 3306 from opening. Next, check permissions. Lastly, verify that you have enough resources to run both servers (being that it is a virtual environment, sometimes the resources are very limited)

P.S. while on the installation screen, click the 'log' tab to see what it says; post if possible. This might give us all insight.
0
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
Ugh... GUIs... They provide zero useful debugging data.

Refer to your actual log files. If you're running a Linux Distro, fixing this will be easy.

Windows... whew, this might take a while.

Per several people's request above, state your OS + version. If you're running Linux, post the output of...

cat /etc/os-release

Open in new window

0
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
Note: By log file people aren't referring to the data log files (which you reference).

They're referring to /var/log/mysql/*.log or your OS/Distro equivalent.

The log file which shows MySQL starting along with exact error causing start to fail.
0
RGuillermoProject ManagerAuthor Commented:
Thank you very much to all experts!
NOw its up and running
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PostgreSQL

From novice to tech pro — start learning today.