Daniel
Member-
Posts
13 -
Joined
-
Last visited
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
Daniel's Achievements
Recent Badges
4
Reputation
-
hai sa il si incercam zic , mersi
-
sa vedem ce avem noi aici
-
ty
-
mersi
-
abandonez proiectul asta :)) ma depaseste . Poate apare o versiune care merge direct fara alte rahaturi . Link download serverfiles (game+db+source) , Parola navicat : newpassword . [Hidden Content]
-
ai compilat sursa ?
-
navicat -> mysql -> user ex : root - parola - y y y y y y y y y y y y y sau : /var/db/mysql/mysql -> user
-
Login without a password, the --skip-grant-tables basically disables authentication/authorization. Allowing you to login without a password. The whole thing: Code: service mysql-server stop sysrc mysql_args="--skip-grant-tables" mysql -u root > ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword'; > exit service mysql-server stop sysrc -x mysql_args service mysql-server start pe mine m a ajutat asta . o sa pun eu link de download la serverfiles daca reusesc sa il pornesc
-
Nu , a pornit abia după ce am reușit sa ii bag o parola la MySQL
-
Am folosit skip tables la resetat parola MySQL . Revin cu edit când îl pornesc . in MySQL - user sau db lipsește coloana password , de aceea nu merge resetat normal
-
am reusit ca sa trec de etapa de mai sus si m am conectat si la navicat dar primesc : connect: Connection refused connect: Connection refused ____________________________________________________________________________________________________ SYSERR: Dec 30 21:45:00 :: socket_connect: HOST 127.0.0.1:30000, could not connect. SYSERR: Dec 30 21:45:03 :: socket_connect: HOST 127.0.0.1:30000, could not connect.
-
2023-12-30T18:19:49.6NZ mysqld_safe Logging to '/var/db/mysql/metin2.err'. 2023-12-30T18:19:49.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 2023-12-30T18:19:49.926489Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2023-12-30T18:19:49.927314Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2023-12-30T18:19:49.935878Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.42) starting as process 895 ... 2023-12-30T18:19:49.971594Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2023-12-30T18:19:49.971633Z 0 [Note] InnoDB: Uses event mutexes 2023-12-30T18:19:49.971649Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2023-12-30T18:19:49.971658Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2023-12-30T18:19:49.974488Z 0 [Note] InnoDB: Number of pools: 1 2023-12-30T18:19:49.978579Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2023-12-30T18:19:49.986572Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2023-12-30T18:19:50.024960Z 0 [Note] InnoDB: Completed initialization of buffer pool 2023-12-30T18:19:50.056773Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2023-12-30T18:19:50.165590Z 0 [Warning] InnoDB: Resizing redo log from 2*16384 to 2*3072 pages, LSN=23548115 2023-12-30T18:19:50.276181Z 0 [Warning] InnoDB: Starting to delete and rewrite log files. 2023-12-30T18:19:50.276723Z 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2023-12-30T18:19:50.985691Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2023-12-30T18:19:51.958078Z 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2023-12-30T18:19:51.958184Z 0 [Warning] InnoDB: New log files created, LSN=23548115 2023-12-30T18:19:51.961942Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2023-12-30T18:19:51.962015Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2023-12-30T18:19:52.167502Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2023-12-30T18:19:52.168917Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2023-12-30T18:19:52.168934Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2023-12-30T18:19:52.169488Z 0 [Note] InnoDB: Waiting for purge to start 2023-12-30T18:19:52.221159Z 0 [Note] InnoDB: 5.7.42 started; log sequence number 23548106 2023-12-30T18:19:52.221876Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool 2023-12-30T18:19:52.230558Z 0 [Note] Plugin 'FEDERATED' is disabled. 2023-12-30T18:19:52.411089Z 0 [Note] InnoDB: Buffer pool(s) load completed at 231230 20:19:52 2023-12-30T18:19:52.431161Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2023-12-30T18:19:52.431182Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2023-12-30T18:19:52.431199Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2023-12-30T18:19:52.431213Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2023-12-30T18:19:52.443192Z 0 [Warning] CA certificate ca.pem is self signed. 2023-12-30T18:19:52.445860Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2023-12-30T18:19:52.447695Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2023-12-30T18:19:52.448222Z 0 [Note] IPv6 is available. 2023-12-30T18:19:52.448252Z 0 [Note] - '::' resolves to '::'; 2023-12-30T18:19:52.448340Z 0 [Note] Server socket created on IP: '::'. 2023-12-30T18:19:52.450655Z 0 [ERROR] Can't start server : Bind on unix socket: Address already in use 2023-12-30T18:19:52.450682Z 0 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 2023-12-30T18:19:52.450698Z 0 [ERROR] Aborting 2023-12-30T18:19:52.450719Z 0 [Note] Binlog end 2023-12-30T18:19:52.454273Z 0 [Note] Shutting down plugin 'ngram' 2023-12-30T18:19:52.454311Z 0 [Note] Shutting down plugin 'partition' 2023-12-30T18:19:52.454322Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2023-12-30T18:19:52.454333Z 0 [Note] Shutting down plugin 'ARCHIVE' 2023-12-30T18:19:52.454342Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2023-12-30T18:19:52.454448Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2023-12-30T18:19:52.454470Z 0 [Note] Shutting down plugin 'MyISAM' 2023-12-30T18:19:52.455497Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2023-12-30T18:19:52.455513Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2023-12-30T18:19:52.455523Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2023-12-30T18:19:52.455532Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2023-12-30T18:19:52.455541Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2023-12-30T18:19:52.455551Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2023-12-30T18:19:52.455560Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2023-12-30T18:19:52.455569Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2023-12-30T18:19:52.455578Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2023-12-30T18:19:52.455587Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2023-12-30T18:19:52.455597Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2023-12-30T18:19:52.455606Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2023-12-30T18:19:52.455615Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2023-12-30T18:19:52.455624Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2023-12-30T18:19:52.455634Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2023-12-30T18:19:52.455643Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2023-12-30T18:19:52.455652Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2023-12-30T18:19:52.455661Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2023-12-30T18:19:52.455671Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2023-12-30T18:19:52.455680Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2023-12-30T18:19:52.455689Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2023-12-30T18:19:52.455698Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2023-12-30T18:19:52.455707Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2023-12-30T18:19:52.455716Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2023-12-30T18:19:52.455726Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2023-12-30T18:19:52.455735Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2023-12-30T18:19:52.455744Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2023-12-30T18:19:52.455753Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2023-12-30T18:19:52.455762Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2023-12-30T18:19:52.455771Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2023-12-30T18:19:52.455781Z 0 [Note] Shutting down plugin 'InnoDB' 2023-12-30T18:19:52.455975Z 0 [Note] InnoDB: FTS optimize thread exiting. 2023-12-30T18:19:52.456206Z 0 [Note] InnoDB: Starting shutdown... 2023-12-30T18:19:52.558595Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/db/mysql/ib_buffer_pool 2023-12-30T18:19:52.558970Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 231230 20:19:52 2023-12-30T18:19:53.523850Z 0 [Note] InnoDB: Shutdown completed; log sequence number 23548447 2023-12-30T18:19:53.524713Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2023-12-30T18:19:53.524740Z 0 [Note] Shutting down plugin 'MEMORY' 2023-12-30T18:19:53.524756Z 0 [Note] Shutting down plugin 'CSV' 2023-12-30T18:19:53.524767Z 0 [Note] Shutting down plugin 'sha256_password' 2023-12-30T18:19:53.524776Z 0 [Note] Shutting down plugin 'mysql_native_password' 2023-12-30T18:19:53.524926Z 0 [Note] Shutting down plugin 'binlog' 2023-12-30T18:19:53.525218Z 0 [Note] /usr/local/libexec/mysqld: Shutdown complete 2023-12-30T18:19:53.6NZ mysqld_safe mysqld from pid file /var/db/mysql/metin2.pid ended
-
am instalat serverfiles zenaris , am compilat sursa dar primesc urmatoartea eroare cand vreau sa il pornesc : Log Offmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38) failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38) failed, retrying in 5 secondsPUBLIC_IP: XXXX.XXXXX.XXXX.XXX interface vtnet0 HOSTNAME: game-auth mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38) cannot open direct sql connection to host: localhost user: metin2 db: common cannot start server while no common sql connected