Can't connect to Server

[expired user #11265]'s profile image [expired user #11265] posted 6 years ago in Creating a connection Permalink

Hey Guys, After moving to a new city, I use a new network. Since then I get the error: 'can not connect to MySQL server on 127.0.0.6 (10061)'. The MYSQL service will not start either. (Error 1067: The process quits unexpectedly.) I use a static IP address and DNS server. What can I do to fix this problem?

I use HeidiSQL for the game 'Life is Feudal your own' (Server). I have spent a lot of time in the game and do not want to start again. I hope anyone can help me. Thank you very much.

ansgar's profile image ansgar posted 6 years ago Permalink

The MySQL service has to be started at first. If the service is not running, HeidiSQL is surely not able to connect to it.

You should find out why you get this "unexpectedly" error. The log file in your MySQL data folder is probably helpful here.

By the way, the local IP address is in nearly all cases 127.0.0.1, not 127.0.0.6.

[expired user #11265]'s profile image [expired user #11265] posted 6 years ago Permalink

Thanks for your answer. On the screenshot you can see all files in my mysql folder. I don't know about this topic, so I don't know which file I have to check.

I know that the local IP is in nearly all cases 127.0.0.1, but 127.0.0.6 works fine in the past. If it helps I can change. But first of all I have to start the MySQL service.

2 attachment(s):
  • MySQL-01
  • MySQL-02
ansgar's profile image ansgar posted 6 years ago Permalink

Your screenshots are from the data/mysql folder. I meant the data folder. And you should watch out for some *.err file - which is a text file you can open with notepad. In that file you should scroll down to the end and you will most likely find some cause to the non-starting server.

[expired user #11265]'s profile image [expired user #11265] posted 6 years ago Permalink

Ok ther is just the 'PaulatronPC' ERR-File. Here's a screenshot from the entire content of this file.

2 attachment(s):
  • MySQL-04
  • MySQL-03
ansgar's profile image ansgar posted 6 years ago Permalink

Looks like you did not yet try to start the MySQL service.

Do that by starting "cmd" with administrator privileges, then type "net start mysql".

[expired user #11265]'s profile image [expired user #11265] posted 6 years ago Permalink

I get the same error message as I get them all the time when I try to start the service:

MySQL could not be started. A system error has occurred. System error 1067 has occurred. The process quite unexpectedly.

1 attachment(s):
  • MySQL-05
[expired user #11265]'s profile image [expired user #11265] posted 6 years ago Permalink

I found a second ERR-File:

2 attachment(s):
  • MySQL-06
  • MySQL-07
ansgar's profile image ansgar posted 6 years ago Permalink

Please just read your log files.

They say the "host" file (table) in the "mysql" folder (database) is missing. Probably it's broken to some harddisk crash, or you deleted it or whatever. You should use the original data folder from the installation, then import your old data.

[expired user #11265]'s profile image [expired user #11265] posted 6 years ago Permalink

I do not know how the date has crashed. I have not changed anything on the folders. I just moved. :( I think I can not solve it without a reinstall. Is there a way to back up the database without being able to log in to HeidiSQL? Otherwise, I lose my entire score. Thanks for your help ansgar.

Please login to leave a reply, or register at first.