Problema pornire mysql

În cazul în care aveţi o nelămurire postaţi aici, de asemenea este locul unde puteţi găsi posibile rezolvări la problemele dvs.
Avatar utilizator
radwcw32
Nivel 2

Nivel 2
Mesaje: 199
Membru din: 07 Iun 2014, 16:54
Regat: Jinno
Aprecieri: 170  
Mulţumiri: 5  
  Rezolvări prob.: 1
Discord: Copiază ID
Medalii

*Problemă/Întrebare:Salut! Nu porneste mysql si nu am nici o idee de la ce este, desi in config-urile din server si db am datele bune
Am incercat si cu bsd 9.2 ymir si cu bsd13.1, la fel
Tipologie server:-
*Resursă folosită:-
*ServerFiles utilizat:-
*Syserr:asa arata .localhost.err

Cod: Selectaţi tot

230928 19:31:44 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
230928 19:31:44 InnoDB: The InnoDB memory heap is disabled
230928 19:31:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
230928 19:31:44 InnoDB: Compressed tables use zlib 1.2.7
230928 19:31:44 InnoDB: Initializing buffer pool, size = 128.0M
230928 19:31:44 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
230928 19:31:44  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
230928 19:31:44  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
230928 19:31:44  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
230928 19:31:44  InnoDB: Waiting for the background threads to start
230928 19:31:45 InnoDB: 5.5.33 started; log sequence number 0
230928 19:31:45 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
230928 19:31:45 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
230928 19:31:45 [Note] Server socket created on IP: '0.0.0.0'.
230928 19:31:46 [Note] Event Scheduler: Loaded 0 events
230928 19:31:46 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.5.33'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
Poză:-
*Detalii suplimentare:-
Avatar utilizator
GianiVersace
Nivel 1

Nivel 1
Mesaje: 123
Membru din: 29 Aug 2023, 20:06
Server: Nereide2
Regat: Jinno
Aprecieri: 1  
Mulţumiri: 14  
Medalii

Ce ai pus tu acolo arata ca mysql merge, nu e nici o eroare. Scrie service mysql-server status dupa ce ai dat service mysql-server start ca sa vezi daca merge sau nu.
Avatar utilizator
radwcw32
Nivel 2

Nivel 2
Mesaje: 199
Membru din: 07 Iun 2014, 16:54
Regat: Jinno
Aprecieri: 170  
Mulţumiri: 5  
  Rezolvări prob.: 1
Discord: Copiază ID
Medalii

GianiVersace scrie: ↑28 Sep 2023, 18:12 Ce ai pus tu acolo arata ca mysql merge, nu e nici o eroare. Scrie service mysql-server status dupa ce ai dat service mysql-server start ca sa vezi daca merge sau nu.

Cod: Selectaţi tot

root@:~ # service mysql-server start
mysql already running?  (pid=798).
root@:~ # service mysql-server status
mysql is running as pid 798.
root@:~ #

dar in putty am asta:

Cod: Selectaţi tot

 BAZA DE DATE
Real Server
Log Offmysql_real_connect: Access denied for user 'root'@'.localhost' (using password: YES)
   failed, retrying in 5 seconds

 LOGIN
PUBLIC_IP: 25.42.220.100 interface em0
HOSTNAME: auth
mysql_real_connect: Access denied for user 'root'@'.localhost' (using password: YES)
cannot open direct sql connection to host: 25.42.220.100 user: root db: common
cannot start server while no common sql connected

 CH1 CORE1/2
PUBLIC_IP: 25.42.220.100 interface em0
HOSTNAME: ch1_core1
mysql_real_connect: Access denied for user 'root'@'.localhost' (using password: YES)
cannot open direct sql connection to host: 25.42.220.100 user: root db: common
cannot start server while no common sql connected
mysql_real_connect: Access denied for user 'root'@'.localhost' (using password: YES)
   failed, retrying in 5 secondsPUBLIC_IP: 25.42.220.100 interface em0
HOSTNAME: ch1_core2
mysql_real_connect: Access denied for user 'root'@'.localhost' (using password: YES)
cannot open direct sql connection to host: 25.42.220.100 user: root db: common
cannot start server while no common sql connected

 CH99
PUBLIC_IP: 25.42.220.100 interface em0
HOSTNAME: ch99
mysql_real_connect: Access denied for user 'root'@'.localhost' (using password: YES)
cannot open direct sql connection to host: 25.42.220.100 user: root db: common
cannot start server while no common sql connected
 CH1 ONLINE
root@:/usr/game # mysql_real_connect: Access denied for user 'root'@'.localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'.localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'.localhost' (using password: YES)
   failed, retrying in 5 seconds
root@:/usr/game #
root@:/usr/game # mysql_real_connect: Access denied for user 'root'@'.localhost' (using password: YES)
   failed, retrying in 5 seconds
root@:/usr/game # Success PLAYER
mysql_real_connect: Access denied for user 'root'@'.localhost' (using password: YES)
si in navicat ma pot conecta
Avatar utilizator
GianiVersace
Nivel 1

Nivel 1
Mesaje: 123
Membru din: 29 Aug 2023, 20:06
Server: Nereide2
Regat: Jinno
Aprecieri: 1  
Mulţumiri: 14  
Medalii

Pai trebuie sa resetezi parola la mysql. Mysql-ul tau porneste nu are probleme
Avatar utilizator
radwcw32
Nivel 2

Nivel 2
Mesaje: 199
Membru din: 07 Iun 2014, 16:54
Regat: Jinno
Aprecieri: 170  
Mulţumiri: 5  
  Rezolvări prob.: 1
Discord: Copiază ID
Medalii

GianiVersace scrie: ↑28 Sep 2023, 21:11 Pai trebuie sa resetezi parola la mysql. Mysql-ul tau porneste nu are probleme
am incercat si asta si nu rezolva problema
Răspunde
Răspunsuri
4
Vizualizări
228
Răspunsuri
2
Vizualizări
218
Răspunsuri
3
Vizualizări
319
Răspunsuri
4
Vizualizări
420

Înapoi la “Probleme şi Întrebări”

  • Informaţie
  • Cine este conectat

    Utilizatori ce ce navighează pe acest forum: Niciun utilizator înregistrat și 7 vizitatori