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

Captura de pantalla 2023-08-09 213932.png

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

Captura de pantalla 2023-08-09 213932.png

Falta la tabla Elendosv2 o la contraseña es incorrecta

  • 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

Captura de pantalla 2023-08-09 213932.png

 

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

 

 

  • 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

Captura de pantalla 2023-08-11 005405.png

Captura de pantalla 2023-08-11 005358.png

  • 0
AincradOn Apprentice

AincradOn

Posted
  • Author
Posted
hace 3 horas, 【ℛ-𝓝】ℛ𝔂𝓼𝒆 dijo:

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

lo hice en todos, podrias ayudarme para dejarlos funcionando, te doy 5usd o 10usd no se, porfavor

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

 

  • 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

Captura de pantalla 2023-08-09 213932.png

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

  • 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

https://mega.nz/file/eZNwxS6K#Q3vPQJ5OuI5MbpUCy542KomiBFPvMLIrcAbxs0x-GEk 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

https://drive.google.com/file/d/1yXFORNSvPk4QYb0OCYDmKFH7MESR8zLS/view?usp=sharing

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

Important Information

This site uses cookies to enhance your browsing experience and provide relevant content. By continuing to browse, you agree to our We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. and Terms of Use. For more information on how we protect your data, please check our Privacy Policy.