Aurora 46 Posted January 3, 2015 Share Posted January 3, 2015 (edited) 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 Link to comment Share on other sites More sharing options...
Traceur3RUN 75 Posted January 3, 2015 Share Posted January 3, 2015 (edited) 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 Link to comment Share on other sites More sharing options...
Premium Shogun 4605 Posted January 3, 2015 Premium Share Posted January 3, 2015 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. Link to comment Share on other sites More sharing options...
Aurora 46 Posted January 3, 2015 Author Share Posted January 3, 2015 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 More sharing options...
Premium Shogun 4605 Posted January 3, 2015 Premium Share Posted January 3, 2015 Is there any particular reason why you are running MySQL 5.0? Install MySQL 5.6 or MariaDB 10, and then run mysql_upgrade Link to comment Share on other sites More sharing options...
Aurora 46 Posted January 3, 2015 Author Share Posted January 3, 2015 i installed mysql 5.6? Link to comment Share on other sites More sharing options...
Premium Shogun 4605 Posted January 3, 2015 Premium Share Posted January 3, 2015 You have to restart the mysql service for the upgrade to take effect. Link to comment Share on other sites More sharing options...
Aurora 46 Posted January 3, 2015 Author Share Posted January 3, 2015 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 Link to comment Share on other sites More sharing options...
Premium Shogun 4605 Posted January 3, 2015 Premium Share Posted January 3, 2015 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 Link to comment Share on other sites More sharing options...
Aurora 46 Posted January 3, 2015 Author Share Posted January 3, 2015 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 Link to comment Share on other sites More sharing options...
Premium Shogun 4605 Posted January 3, 2015 Premium Share Posted January 3, 2015 Look at this: 14:07:25 UTC - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=0 max_threads=151 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67554 K bytes of memory 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 Link to comment Share on other sites More sharing options...
Reboot 772 Posted January 3, 2015 Share Posted January 3, 2015 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 1 Link to comment Share on other sites More sharing options...
Aurora 46 Posted January 4, 2015 Author Share Posted January 4, 2015 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 More sharing options...
Reboot 772 Posted January 4, 2015 Share Posted January 4, 2015 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 More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now