[HELP]Mysql problem

[Aurora 46]

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

Edited August 30, 2022 by Metin2 Dev
Core X - External 2 Internal

[Traceur3RUN 73]

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

upgrade mysql

 

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

Edited August 30, 2022 by Metin2 Dev
Core X - External 2 Internal

[Shogun 4483]

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.

[Aurora 46]

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

[Shogun 4483]

Is there any particular reason why you are running MySQL 5.0? Install MySQL 5.6 or MariaDB 10, and then run mysql_upgrade

[Aurora 46]

i installed mysql 5.6?

[Shogun 4483]

You have to restart the mysql service for the upgrade to take effect.

[Aurora 46]

You have to restart the mysql service for the upgrade to take effect.

i installed 5.6 in the begin and i restart it many times

[Shogun 4483]

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

[Aurora 46]

Yeah sorry i have a lot of .err files

 

here is the right one 

 

http://pastebin.com/39fWszvQ

 

this is not everything there is more

 

if you want that to just say

[Shogun 4483]

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

[Reboot 764]

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

[Aurora 46]

 

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

[Reboot 764]

 

 

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.