Jump to content
  • 0

[HELP]Mysql problem


Aurora

Question

Hello everybody

 

It's me agian :)

 

I have a little error here i think already searched on google and here i try everything what they said but still i have the same problem

 

Here is the error that appears

 


ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

 

Here a screen of top

https://metin2.download/picture/0bdE99AtpBa3x5NCkKFap1kruV5e5jSu/.png

 

If you need more information just ask

 

I hope somebody can help me :D

Edited by Metin2 Dev
Core X - External 2 Internal
Link to comment
Share on other sites

13 answers to this question

Recommended Posts

  • 0

Hello everybody

 

It's me agian :)

 

I have a little error here i think already searched on google and here i try everything what they said but still i have the same problem

 

Here is the error that appears

 


ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

 

Here a screen of top

https://metin2.download/picture/0bdE99AtpBa3x5NCkKFap1kruV5e5jSu/.png

 

If you need more information just ask

 

I hope somebody can help me :D

upgrade mysql

 

if you put from mysql 5.5 (server mysql files) to you mysql 5.0 (never this work)

Edited by Metin2 Dev
Core X - External 2 Internal
Link to comment
Share on other sites

  • 0
  • Premium

This "error" must be the most posted in metin history.

 

For once and all: it simply means MySQL is not running. That's all. Nothing else can be deducted from it. Nobody can tell you what's wrong by just seeing that error.

 

Post the MySQL error log in /var/db/mysql/hostname.err if you want to be helped with it.

Currently working on my FreeBSD blog:

FreeBSD is Fun, practical tutorials and articles

⚠️                Are you under attack?               ⚠️

Link to comment
Share on other sites

  • 0

This "error" must be the most posted in metin history.

 

For once and all: it simply means MySQL is not running. That's all. Nothing else can be deducted from it. Nobody can tell you what's wrong by just seeing that error.

 

Post the MySQL error log in /var/db/mysql/hostname.err if you want to be helped with it.


150101 11:13:11  mysqld started
150101 11:13:12  InnoDB: Started; log sequence number 0 1588761
150101 11:13:12 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.92'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port: mysql-server-5.0.92
Link to comment
Share on other sites

  • 0
  • Premium

Then you are showing me the wrong error log, as the one you posted above states MySQL 5.0 is running.

 

run this command to see the current hostname of your machine:

 

hostname

 

Then look for a file called like this with the .err suffix in /var/db/mysql

Currently working on my FreeBSD blog:

FreeBSD is Fun, practical tutorials and articles

⚠️                Are you under attack?               ⚠️

Link to comment
Share on other sites

  • 0
  • Premium

Look at this:

 

  1. 14:07:25 UTC - mysqld got signal 11 ;
  2. This could be because you hit a bug. It is also possible that this binary
  3. or one of the libraries it was linked against is corrupt, improperly built,
  4. or misconfigured. This error can also be caused by malfunctioning hardware.
  5. We will try our best to scrape up some info that will hopefully help
  6. diagnose the problem, but since we have already crashed,
  7. something is definitely wrong and this may fail.
  8.  
  9. key_buffer_size=8388608
  10. read_buffer_size=131072
  11. max_used_connections=0
  12. max_threads=151
  13. thread_count=0
  14. connection_count=0
  15. It is possible that mysqld could use up to
  16. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67554 K  bytes of memory
  17. Hope that's ok; if not, decrease some variables in the equation.
 
 
Post the contents of /usr/local/etc/my.cnf
 
If this file doesn't exist, reinstall from ports:
 
portsnap fetch update
cd /usr/ports/databases/mysql56-server
make build reinstall clean

Currently working on my FreeBSD blog:

FreeBSD is Fun, practical tutorials and articles

⚠️                Are you under attack?               ⚠️

Link to comment
Share on other sites

  • 0

Simply, follow the steps below:

-Delete the folder var/db/mysql (mysql Delete)
-Restart the server (VDS)

You'll create a new mysql.
But after careful not to overwrite and database.
 
Copy only player account, log, common, hotbackup.
 
So you should not overwrite mysql folder
  • Love 1
Link to comment
Share on other sites

  • 0

 

Simply, follow the steps below:

-Delete the folder var/db/mysql (mysql Delete)
-Restart the server (VDS)

You'll create a new mysql.
But after careful not to overwrite and database.
 
Copy only player account, log, common, hotbackup.
 
So you should not overwrite mysql folder

 

 

Thanks your solution worked

Link to comment
Share on other sites

  • 0

 

 

Simply, follow the steps below:

-Delete the folder var/db/mysql (mysql Delete)
-Restart the server (VDS)

You'll create a new mysql.
But after careful not to overwrite and database.
 
Copy only player account, log, common, hotbackup.
 
So you should not overwrite mysql folder

 

 

Thanks your solution worked

 

This problem occurs with mysql.sock overwrite mysql folder.
Example: You have preinstalled mysql56 and when downloaded serverfiles those mysql55 installed.
 
And you overwrite mysql56 with mysql55 and that this error occurs.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Activity

    1. 7

      Metin2 2003 Beta Client!!!!!

    2. 32

      Boss Effect Over Head

    3. 1

      Open Source API for Metin2 Server Management - Early Development

    4. 0

      Official Item Combination [18.4]

    5. 2

      Proper SIGNAL management for Windows

    6. 2

      Proper SIGNAL management for Windows

    7. 4

      syserr erorr ( not working OK button on client )

  • Recently Browsing

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.