Jump to content
  • 0

[SOLUCIONADO] PROBLEMA MySQL AL INICIAR SERVER

AincradOn

Preguntado por AincradOn,

 Compartir

Pregunta

AincradOn Aprendiz

AincradOn

Publicado
Publicado

PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using passwo                           rd: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern4_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern5_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern6_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern7_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern8_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Neutraler_Server is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: game99
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
MFB is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: gameMFB
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
auth is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: auth
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
 

 

Alguien por favor podria ayudarme con este problema, que solucion podria darle, se lo agradeceria de ante mano, gracias

Debes iniciar sesión para ver el contenido del archivo adjunto en esta publicación.

Enlace para comentar
Compartir en otros sitios

10 respuestas a esta pregunta

Mensajes recomendados

  • 0
Marcos Pinheiro Explorador

Marcos Pinheiro

Publicado
Publicado
hace 15 horas, AincradOn dijo:

PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using passwo                           rd: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern4_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern5_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern6_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern7_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern8_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Neutraler_Server is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: game99
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
MFB is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: gameMFB
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
auth is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: auth
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
 

 

Alguien por favor podria ayudarme con este problema, que solucion podria darle, se lo agradeceria de ante mano, gracias

Debes iniciar sesión para ver el contenido del archivo adjunto en esta publicación.

Falta la tabla Elendosv2 o la contraseña es incorrecta

Enlace para comentar
Compartir en otros sitios
  • 0
【ℛ-𝓝】ℛ𝔂𝓼𝒆 Colaborador

【ℛ-𝓝】ℛ𝔂𝓼𝒆

Publicado
Publicado
hace 21 horas, AincradOn dijo:

PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using passwo                           rd: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern4_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern5_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern6_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern7_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern8_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Neutraler_Server is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: game99
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
MFB is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: gameMFB
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
auth is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: auth
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
 

 

Alguien por favor podria ayudarme con este problema, que solucion podria darle, se lo agradeceria de ante mano, gracias

Debes iniciar sesión para ver el contenido del archivo adjunto en esta publicación.

 

Cambia la contraseña MySQL y despues edita los archivos CONFIG de cada canal, mysql, game99 y auth con la contraseña y usuario que pusiste...

 

 

Enlace para comentar
Compartir en otros sitios
  • 0
AincradOn Aprendiz

AincradOn

Publicado
  • Author
Publicado
hace 6 horas, 【ℛ-𝓝】ℛ𝔂𝓼𝒆 dijo:

 

Cambia la contraseña MySQL y despues edita los archivos CONFIG de cada canal, mysql, game99 y auth con la contraseña y usuario que pusiste...

 

 

Estoy totalmente ya quemado con esto, cambie todo, aun no se si hago mal yo o que

Debes iniciar sesión para ver el contenido del archivo adjunto en esta publicación.

Debes iniciar sesión para ver el contenido del archivo adjunto en esta publicación.

Enlace para comentar
Compartir en otros sitios
  • 0
【ℛ-𝓝】ℛ𝔂𝓼𝒆 Colaborador

【ℛ-𝓝】ℛ𝔂𝓼𝒆

Publicado
Publicado
hace 19 horas, AincradOn dijo:

Estoy totalmente ya quemado con esto, cambie todo, aun no se si hago mal yo o que

Debes iniciar sesión para ver el contenido del archivo adjunto en esta publicación.

Debes iniciar sesión para ver el contenido del archivo adjunto en esta publicación.

todavia no cambiaste los datos en los CONFIG, revisa todos los CONFIG...

Enlace para comentar
Compartir en otros sitios
  • 0
clocki Nuevo

clocki

Publicado
Publicado

Por lo que veo ahí hay dos problemas, una es la contraseña de MySQL es una y la de los CONFIG es otra, te está diciendo Access denied for user elendosv2@localhost

El otro problema el del connection refused, parece que alguna tabla de MySQL está mal, o bien corruptas o está vacío nunca se te levantara el binario db, cd  /main/srv1/db seguro que debes tener un db.core que si usaras el depurador gdb te diría, o bien mira el syserr que te dice. 

 

Enlace para comentar
Compartir en otros sitios
  • 0
【ℛ-𝓝】ℛ𝔂𝓼𝒆 Colaborador

【ℛ-𝓝】ℛ𝔂𝓼𝒆

Publicado
Publicado
En 9/8/2023 a las 23:43, AincradOn dijo:

PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using passwo                           rd: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern4_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern5_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern6_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern7_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Kern8_Ch1 is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
Neutraler_Server is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: game99
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
MFB is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: gameMFB
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
auth is not running
PUBLIC_IP: 192.168.100.50 interface em0
HOSTNAME: auth
mysql_real_connect: Access denied for user 'elendosv2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: elendosv2 db: common
cannot start server while no common sql connected
 

 

Alguien por favor podria ayudarme con este problema, que solucion podria darle, se lo agradeceria de ante mano, gracias

Debes iniciar sesión para ver el contenido del archivo adjunto en esta publicación.

reinstala los files y pon estos comandos en el FreeBSD

 

mysql -p

GRANT ALL PRIVILEGES ON *.* TO 'elendosv2'@'localhost'
IDENTIFIED BY 'elendosv2live' WITH GRANT OPTION;

exit;

/usr/local/etc/rc.d/mysql-server restart

Enlace para comentar
Compartir en otros sitios
  • 0
TrafalgarLaw Contribuyente

TrafalgarLaw

Publicado
Publicado

TOMA AQUI TIENES MYSQL ARREGLADOS POR TU ERROR QUE TIENES.

APARTE DE UN PARCHE DE ROOT, LOCALE Y OTRO ARCHIVO PARA EL ESPAÑOL

Debes iniciar sesión para ver el contenido del enlace en esta publicación.
 ESPAÑOL Y LOS 2 IDIOMAS A DE DEFECTO QUE TRAE, RECUERDA DESCOMPILAR ROOT Y PONER TU IP

RECUERDA EN LOS CONDIF DE CHANEL, GAME 99 Y ETC CAMBIAR LOCAL HOST POR ESTO 

SQL_ACCOUNT = "127.0.0.1 account root 197352197352 0"
SQL_PLAYER = "127.0.0.1 player root 197352197352 0"
SQL_COMMON = "127.0.0.1 common root 197352197352 0"
SQL_HOTBACKUP = "127.0.0.1 homepage root 197352197352 0"

TE FIJAS BIEN ANTES DE COPIAR Y PEGAR, SOLO CAMBIA TU PSS POR ESTA Y LOCALHOST POR 127.0.0.1 Y EL USUARIO ELENDOSV2 POR ROOT

Debes iniciar sesión para ver el contenido del enlace en esta publicación.

Enlace para comentar
Compartir en otros sitios

Unirse a la conversación

Puedes publicar ahora y registrarte más tarde. Si tienes una cuenta, regístrate para publicar con su cuenta.

Guest
Responder esta pregunta...

×   Has pegado contenido con formato .   Eliminar formato

  Only 75 emoji are allowed.

×   Tu enlace se ha incorporado automáticamente.   Mostrar un enlace en su lugar

×   Se ha restaurado el contenido anterior. .   Borrar editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Compartir
Ir a la lista de preguntas

  • Recientemente navegando por este tema   0 miembros

    • No hay usuarios registrados visitando esta página.
×
×
  • Crear nuevo...