Eroare MySQL .

Înainte de a posta o problemă, caută în acest forum și poate găsești rezolvare.
Închis
Avatar utilizator
RazvanOCB
Utilizator interzis !

Utilizator interzis !
Mesaje: 22
Membru din: 11 Dec 2017, 17:51
Server: În progres .
Regat: Jinno
Aprecieri: 3  
Mulţumiri: 0
Medalii

Salut , am instalat şi eu serverfiles cartov1 modificat de GazerNr1.Îmi dă eraore cu "Ezio@localhost acc denied passowrd YES" şi am intrat în configuri la ch-uri game99 db/auth Şi am şters ezio de acolo şi parola aceea şi am pus root şi parola mea .şi acum îmi dă eroarea asta :1
BAZA DE DATE
Real Server
Log Offmysql_real_connect: Unknown database 'player'
failed, retrying in 5 seconds

LOGIN
PUBLIC_IP: ip la host . interface em0
HOSTNAME: dev_0
mysql_real_connect: Unknown database 'common'
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected

CORE2
PUBLIC_IP: ip la host interface em0
HOSTNAME: dev1_1
mysql_real_connect: Unknown database 'common'
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
mysql_real_connect: Unknown database 'player'
failed, retrying in 5 secondsPUBLIC_IP: ip la host interface em0
HOSTNAME: dev1_2
mysql_real_connect: Unknown database 'common'
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected

GAME99
PUBLIC_IP: ip la host interface em0
HOSTNAME: dev99_1
mysql_real_connect: Unknown database 'common'
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
mysql_real_connect: Unknown database 'player'
failed, retrying in 5 seconds
Gaz3rNr1-J4M
root@Clever-Host:/usr/game # mysql_real_connect: Unknown database 'player'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'player'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'player'
failed, retrying in 5 secondsSuccess PLAYER
mysql_real_connect: Unknown database 'account'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'account'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'account'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'account'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'account'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'account'
failed, retrying in 5 secondsSuccess ACCOUNT
mysql_real_connect: Unknown database 'common'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'common'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'common'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'common'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'common'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'common'
failed, retrying in 5 secondsSuccess COMMON
mysql_real_connect: Unknown database 'hotbackup'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'hotbackup'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'hotbackup'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'hotbackup'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'hotbackup'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'hotbackup'
failed, retrying in 5 secondsSuccess HOTBACKUP
1 - (1) Pornesc CH1
Badly placed ()'s.

root@Clever-Host:/usr/game #
root@Clever-Host:/usr/game # 2 - (2) Anuleaza Actiunea!
Badly placed ()'s.
root@Clever-Host:/usr/game # Copyright @ 2014! Toate drepturile sunt rezervate.
Copyright: Command not found.
root@Clever-Host:/usr/game # 1
1: Command not found.
root@Clever-Host:/usr/game # BAZA DE DATE
BAZA: Command not found.
root@Clever-Host:/usr/game # Real Server
Real: Command not found.
root@Clever-Host:/usr/game # Log Offmysql_real_connect: Unknown database 'player'
mysql_real_connect: Unknown database 'common'
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected

CORE2
PUBLIC_IP: ip host interface em0
HOSTNAME: dev1_1
mysql_real_connect: Unknown database 'common'
cannot open direct sql connection to host: localhost user: root db: common
Log: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 seconds
cannot start server while no common sql connected
failed,: Command not found.
root@Clever-Host:/usr/game #
root@Clever-Host:/usr/game # LOGIN
LOGIN: Command not found.
root@Clever-Host:/usr/game # PUBLIC_IP: ip host interface em0
PUBLIC_IP:: Too many arguments.
root@Clever-Host:/usr/game # HOSTNAME: dev_0
HOSTNAME:: Too many arguments.
root@Clever-Host:/usr/game # mysql_real_connect: Unknown database 'common'
mysql_real_connect:: Too many arguments.
root@Clever-Host:/usr/game # cannot open direct sql connection to host: localhost user: root db: common
cannot: Command not found.
root@Clever-Host:/usr/game # cannot start server while no common sql connected
mysql_real_connect: Unknown database 'player'
failed, retrying in 5 secondsPUBLIC_IP: ip host interface em0
HOSTNAME: dev1_2
mysql_real_connect: Unknown database 'common'
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected

GAME99
PUBLIC_IP: ip host interface em0
HOSTNAME: dev99_1
mysql_real_connect: Unknown database 'common'
cannot: Command not found.
root@Clever-Host:/usr/game #
root@Clever-Host:/usr/game # CORE2
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
mysql_real_connect: Unknown database 'player'
failed, retrying in 5 seconds
Gaz3rNr1-J4M
CORE2: Command not found.
root@Clever-Host:/usr/game # PUBLIC_IP: ip host interface em0
PUBLIC_IP:: Too many arguments.
root@Clever-Host:/usr/game # HOSTNAME: dev1_1
HOSTNAME:: Too many arguments.
root@Clever-Host:/usr/game # mysql_real_connect: Unknown database 'common'
mysql_real_connect:: Too many arguments.
root@Clever-Host:/usr/game # cannot open direct sql connection to host: localhost user: root db: common
cannot: Command not found.
root@Clever-Host:/usr/game # cannot start server while no common sql connected
cannot: Command not found.
root@Clever-Host:/usr/game # mysql_real_connect: Unknown database 'player'
mysql_real_connect:: Too many arguments.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsPUBLIC_IP: ip host 1 interface em0
failed,: Command not found.
root@Clever-Host:/usr/game # HOSTNAME: dev1_2
HOSTNAME:: Too many arguments.
root@Clever-Host:/usr/game # mysql_real_connect: Unknown database 'common'
mysql_real_connect:: Too many arguments.
root@Clever-Host:/usr/game # cannot open direct sql connection to host: localhost user: root db: common
cannot: Command not found.
root@Clever-Host:/usr/game # cannot start server while no common sql connected
root@Clever-Host:/usr/game # mysql_real_connect: Unknown database 'player'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'player'
cannot: Command not found.
root@Clever-Host:/usr/game #
root@Clever-Host:/usr/game # GAME99
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'player'
failed, retrying in 5 secondsSuccess PLAYER
mysql_real_connect: Unknown database 'account'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'account'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'account'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'account'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'account'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'account'
failed, retrying in 5 secondsSuccess ACCOUNT
GAME99: Command not found.
root@Clever-Host:/usr/game # PUBLIC_IP: ip host interface em0
PUBLIC_IP:: Too many arguments.
mysql_real_connect: Unknown database 'common'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'common'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'common'
root@Clever-Host:/usr/game # HOSTNAME: dev99_1
HOSTNAME:: Too many arguments.
root@Clever-Host:/usr/game # mysql_real_connect: Unknown database 'common'
mysql_real_connect:: Too many arguments.
root@Clever-Host:/usr/game # cannot open direct sql connection to host: localhost user: root db: common
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'common'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'common'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'common'
failed, retrying in 5 secondsSuccess COMMON
mysql_real_connect: Unknown database 'hotbackup'
cannot: Command not found.
root@Clever-Host:/usr/game # cannot start server while no common sql connected
cannot: Command not found.
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'hotbackup'
root@Clever-Host:/usr/game # mysql_real_connect: Unknown database 'player'
mysql_real_connect:: Too many arguments.
root@Clever-Host:/usr/game # failed, retrying in 5 seconds
failed,: Command not found.
root@Clever-Host:/usr/game # Gaz3rNr1-J4M
Gaz3rNr1-J4M: Command not found.
root@Clever-Host:/usr/game # root@Clever-Host:/usr/game # mysql_real_connect: Unknown database 'player'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'hotbackup'
root@Clever-Host:/usr/game: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'player'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'hotbackup'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'hotbackup'
failed, retrying in 5 secondsmysql_real_connect: Unknown database 'hotbackup'
failed, retrying in 5 secondsSuccess HOTBACKUP

failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'player'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsSuccess PLAYER
failed,: Command not found.
root@Clever-Host:/usr/game # mysql_real_connect: Unknown database 'account'
mysql_real_connect:: Too many arguments.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'account'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'account'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'account'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'account'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'account'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsSuccess ACCOUNT
failed,: Command not found.
root@Clever-Host:/usr/game # mysql_real_connect: Unknown database 'common'
mysql_real_connect:: Too many arguments.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'common'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'common'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'common'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'common'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'common'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsSuccess COMMON
failed,: Command not found.
root@Clever-Host:/usr/game # mysql_real_connect: Unknown database 'hotbackup'
mysql_real_connect:: Too many arguments.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'hotbackup'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'hotbackup'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'hotbackup'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'hotbackup'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsmysql_real_connect: Unknown database 'hotbackup'
failed,: Command not found.
root@Clever-Host:/usr/game # failed, retrying in 5 secondsSuccess HOTBACKUP
Avatar utilizator
Athero
Ţepar / Untrusted User

Ţepar / Untrusted User
Mesaje: 3936
Membru din: 17 Aug 2017, 00:08
Aprecieri: 559  
Mulţumiri: 7142  
Discord: Copiază ID
Medalii

Schimba parola la mysql folosind acest tutorial.

Cod: Selectaţi tot

(RESET PAROLA MYSQL)

/usr/local/etc/rc.d/mysql-server stop
mysqld_safe --skip-grant-tables &
mysql -u root
use mysql;
update user set password=PASSWORD('paroladorita') where user='root';
flush privileges;
quit
/usr/local/etc/rc.d/mysql-server stop
/usr/local/etc/rc.d/mysql-server start
//retras
Afișează semnătura
Avatar utilizator
LikePc
Nivel 10

Nivel 10
Mesaje: 2240
Membru din: 11 Aug 2015, 00:01
Server: M3
Regat: Chunjo
Aprecieri: 9  
Mulţumiri: 270  
 Contact:
Medalii

Imagine
Dai click dreapta pe likelocalhost > si selectezi editare
apoi la username pune - > root
host -> localhost
parola -> PAROLA_SERVER
Pentru acest mesaj, LikePc a primit 2 (de) mulţumiri
RazvanOCB • nytro123
https:/horus-maps.com
Afișează semnătura
Avatar utilizator
RazvanOCB
Utilizator interzis !

Utilizator interzis !
Mesaje: 22
Membru din: 11 Dec 2017, 17:51
Server: În progres .
Regat: Jinno
Aprecieri: 3  
Mulţumiri: 0
Medalii

LikePc scrie:Imagine
Dai click dreapta pe likelocalhost > si selectezi editare
apoi la username pune - > root
host -> localhost
parola -> PAROLA_SERVER
Mulţumesc ! .Problemă Rezolvată cer T/C .
Avatar utilizator
LikePc
Nivel 10

Nivel 10
Mesaje: 2240
Membru din: 11 Aug 2015, 00:01
Server: M3
Regat: Chunjo
Aprecieri: 9  
Mulţumiri: 270  
 Contact:
Medalii

Subiect mutat in probleme rezolvate.
https:/horus-maps.com
Afișează semnătura
Închis
Răspunsuri
3
Vizualizări
449
Răspunsuri
1
Vizualizări
213
Răspunsuri
9
Vizualizări
756
Răspunsuri
1
Vizualizări
310

Înapoi la “Probleme rezolvate”

  • Informaţie
  • Cine este conectat

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