Jump to content
  • 0

[SOLUCIONADO] PROBLEMA MySQL AL INICIAR SERVER

AincradOn

Asked by AincradOn,

 Share

Question

AincradOn Apprentice

AincradOn

Posted
Posted

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.

Link to comment
Share on other sites

10 answers to this question

Recommended Posts

  • 0
Marcos Pinheiro Contributor

Marcos Pinheiro

Posted
Posted
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

Link to comment
Share on other sites
  • 0
【ℛ-𝓝】ℛ𝔂𝓼𝒆 Collaborator

【ℛ-𝓝】ℛ𝔂𝓼𝒆

Posted
Posted
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...

 

 

Link to comment
Share on other sites
  • 0
AincradOn Apprentice

AincradOn

Posted
  • Author
Posted
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.

Link to comment
Share on other sites
  • 0
【ℛ-𝓝】ℛ𝔂𝓼𝒆 Collaborator

【ℛ-𝓝】ℛ𝔂𝓼𝒆

Posted
Posted
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...

Link to comment
Share on other sites
  • 0
clocki Newbie

clocki

Posted
Posted

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. 

 

Link to comment
Share on other sites
  • 0
【ℛ-𝓝】ℛ𝔂𝓼𝒆 Collaborator

【ℛ-𝓝】ℛ𝔂𝓼𝒆

Posted
Posted
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

Link to comment
Share on other sites
  • 0
TrafalgarLaw Contributor

TrafalgarLaw

Posted
Posted

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

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

×
 Share
Go to question listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...