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?
 
Ryan ChongConnect With a Mentor Commented:
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
 
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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
skullnobrainsConnect With a Mentor Commented:
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 ChongConnect With a Mentor Commented:
if it's windows base you can also verify if there's any errors in the Event Viewer.
0
 
NerdsOfTechConnect With a Mentor Technology 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 FavorConnect With a Mentor Linux/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 FavorConnect With a Mentor Linux/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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.