Register for your free account! | Forgot your password?

You last visited: Today at 11:43

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

[HELP] Mysql

Discussion on [HELP] Mysql within the Metin2 Private Server forum part of the Metin2 category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2012
Posts: 32
Received Thanks: 0
[HELP] Mysql

Hello,
help me please.

xx.err
Quote:
140430 16:55:51 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2014-04-30 16:55:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-04-30 16:56:00 1041 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/libexec/mysqld: Table 'mysql.plugin' doesn't exist
2014-04-30 16:56:00 1041 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2014-04-30 16:56:00 1041 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-04-30 16:56:00 1041 [Note] InnoDB: The InnoDB memory heap is disabled
2014-04-30 16:56:00 1041 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-04-30 16:56:00 1041 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-04-30 16:56:00 1041 [Note] InnoDB: Using CPU crc32 instructions
2014-04-30 16:56:00 1041 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-04-30 16:56:00 1041 [Note] InnoDB: Completed initialization of buffer pool
2014-04-30 16:56:00 1041 [Note] InnoDB: Highest supported file format is Barracuda.
2014-04-30 16:56:00 1041 [Warning] InnoDB: Resizing redo log from 2*320 to 2*3072 pages, LSN=1594005
2014-04-30 16:56:00 1041 [Warning] InnoDB: Starting to delete and rewrite log files.
2014-04-30 16:56:00 1041 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2014-04-30 16:56:01 1041 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2014-04-30 16:56:02 1041 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2014-04-30 16:56:02 1041 [Warning] InnoDB: New log files created, LSN=1594005
2014-04-30 16:56:04 1041 [Note] InnoDB: 128 rollback segment(s) are active.
2014-04-30 16:56:04 1041 [Note] InnoDB: Creating tablespace and datafile system tables.
2014-04-30 16:56:05 1041 [Note] InnoDB: Tablespace and datafile system tables created.
2014-04-30 16:56:05 1041 [Note] InnoDB: Waiting for purge to start
2014-04-30 16:56:05 1041 [Note] InnoDB: 5.6.17 started; log sequence number 1594005
2014-04-30 16:56:05 1041 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 8ddf2c38-d077-11e3-923d-0e24988e563d.
2014-04-30 16:56:05 1041 [Note] Server hostname (bind-address): '*'; port: 3306
2014-04-30 16:56:05 1041 [Note] IPv6 is available.
2014-04-30 16:56:05 1041 [Note] - '::' resolves to '::';
2014-04-30 16:56:05 1041 [Note] Server socket created on IP: '::'.
2014-04-30 16:56:05 1041 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2014-04-30 16:56:05 1041 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2014-04-30 16:56:05 1041 [ERROR] Aborting

2014-04-30 16:56:05 1041 [Note] Binlog end
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'partition'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'ARCHIVE'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'BLACKHOLE'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_METRICS'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_CMP'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'INNODB_TRX'
2014-04-30 16:56:05 1041 [Note] Shutting down plugin 'InnoDB'
2014-04-30 16:56:05 1041 [Note] InnoDB: FTS optimize thread exiting.
2014-04-30 16:56:05 1041 [Note] InnoDB: Starting shutdown...
2014-04-30 16:56:06 1041 [Note] InnoDB: Shutdown completed; log sequence number 1598773
2014-04-30 16:56:06 1041 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-04-30 16:56:06 1041 [Note] Shutting down plugin 'CSV'
2014-04-30 16:56:06 1041 [Note] Shutting down plugin 'MEMORY'
2014-04-30 16:56:06 1041 [Note] Shutting down plugin 'MRG_MYISAM'
2014-04-30 16:56:06 1041 [Note] Shutting down plugin 'MyISAM'
2014-04-30 16:56:06 1041 [Note] Shutting down plugin 'sha256_password'
2014-04-30 16:56:06 1041 [Note] Shutting down plugin 'mysql_old_password'
2014-04-30 16:56:06 1041 [Note] Shutting down plugin 'mysql_native_password'
2014-04-30 16:56:06 1041 [Note] Shutting down plugin 'binlog'
2014-04-30 16:56:06 1041 [Note] /usr/local/libexec/mysqld: Shutdown complete
geron552 is offline  
Old   #2
 
elite*gold: 11
The Black Market: 1/0/0
Join Date: Nov 2010
Posts: 1,709
Received Thanks: 3,828
rm /tmp/mysql.sock
service mysql-server start
mysql_upgrade
.Shōgun is offline  
Old   #3
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2012
Posts: 32
Received Thanks: 0
Quote:
Originally Posted by .Shōgun View Post
rm /tmp/mysql.sock
service mysql-server start
mysql_upgrade

root@freya:/var/db # rm /tmp/mysql.sock
rm: /tmp/mysql.sock: No such file or directory
root@freya:/var/db # service mysql-server start
Starting mysql.
root@freya:/var/db # mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed
root@freya:/var/db # mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
geron552 is offline  
Old   #4
 
elite*gold: 11
The Black Market: 1/0/0
Join Date: Nov 2010
Posts: 1,709
Received Thanks: 3,828
reboot and try again
.Shōgun is offline  
Old   #5
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2012
Posts: 32
Received Thanks: 0
Quote:
Originally Posted by .Shōgun View Post
reboot and try again
after reboot:

Quote:
root@freya:~ # rm /tmp/mysql.sock
rm: /tmp/mysql.sock: No such file or directory
root@freya:~ # mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
root@freya:~ #
root@freya:~ # rm /tmp/mysql.sock
rm: /tmp/mysql.sock: No such file or directory
root@freya:~ # service mysql-server start
Starting mysql.
root@freya:~ # mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed
geron552 is offline  
Reply

« Kostüm System einfügen: Client startet nichtmehr | Frage zum Blueshining :) »

Similar Threads Similar Threads
Mysql fehler 1130-Host 'xxxx' is not allowed to connect to this MySQL server
02/21/2017 - Metin2 Private Server - 3 Replies
Hallo Community, und zwar ich habe ein Problem wenn ich auf Navicat gehe und auf meiner DB zugreifen möchte steht dort Mysql fehler 1130-Host 'xxxx' is not allowed to connect to this MySQL server ich hoffe mir kannn jemand helfen oder mir es beheben..
Mysql fehler 1130-Host 'xxxx' is not allowed to connect to this MySQL server
10/18/2012 - Metin2 Private Server - 0 Replies
Ich brauche eure hilfe ich wollte einen P-server machen und benutzte Navicat für die DatenBank aber beim ersten mal ging es doch ich hatte dann die DB gelöscht,weil ich ein neues script hatte und dann wollte ich wieder eins machen aber es ging nicht so wie oben der Fehler ich bitte um hilfe danke :) aber bitte so schnell wie möglich um antwort danke Liebe Grüße : Silver2011
MySQL-Fehler ("socket:'/tmp/mysql.sock' doesn't exist)
10/10/2012 - Metin2 Private Server - 3 Replies
Ohai M2-Community, nachdem ich nun schon etliche Male versucht habe, MySQl 5.5 zu installieren, erscheint immer der gleiche Fehler und mir ist es nicht möglich mit der Datenbank zu verbinden. Fehler: http://i.epvpimg.com/48mUd.png
MySQL - L server through socket '/tmp/mysql.sock' (38) failed, retrying in 5 secon
06/28/2012 - Metin2 Private Server - 2 Replies
Hi EPvP I have one problem whit my server. I install a new game + db and i start him L server through socket '/tmp/mysql.sock' (38) failed, retrying in 5 secondsSuccess HOTBACKUP Why?



All times are GMT +2. The time now is 11:43.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.