Problema navicat

alifnevazutul · 06 Iul 2019, 14:01

Salut. Am schimbat parola navicat de 10 ori in putty dar tot imi apare asta in putty :

CH1 pornit cu succes!
root@metin2:~ # mysql_real_connect: Access denied for user 'ezio'@'localhost' (u                                                                                                             sing password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsSuccess PLAYER
mysql_real_connect: Access denied for user 'ezio'@'localhost' (using password: Y                                                                                                             ES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsSuccess ACCOUNT
mysql_real_connect: Access denied for user 'ezio'@'localhost' (using password: Y                                                                                                             ES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsSuccess COMMON
mysql_real_connect: Access denied for user 'ezio'@'localhost' (using password: Y                                                                                                             ES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'ezio                                                                                                             '@'localhost' (using password: YES)
   failed, retrying in 5 secondsSuccess HOTBACKUP

Iar pe site imi apare asta :

Cod: Selectaţi tot

Host 'IP' is not allowed to connect to this MySQL server

Sigur ii ceva banalr dar nu imi dau seama ce e de facut ca am tot resetat si dres mysql ala din putty dar nimic

BeauDeCiuda · 06 Iul 2019, 14:36

pune in config pe fiecare core user si parola sau schimba parola la userul "ezio"

alifnevazutul · 06 Iul 2019, 14:43

Nu inteleg cum zici, in config de la fiecare core nu am un user sau parola, am asa ceva :

Cod: Selectaţi tot

HOSTNAME: channel1_1
CHANNEL: 1
PORT: 21000
P2P_PORT: 13000
DB_PORT: 11000
DB_ADDR: localhost
MAP_ALLOW: 1 3 4 5 6 21 23 24 25 26 41 43 44 45 46 104 240 222 301 302 304 303 402 256
TABLE_POSTFIX:
PASSES_PER_SEC: 25
SAVE_EVENT_SECOND_CYCLE: 180
PING_EVENT_SECOND_CYCLE: 180
PLAYER_SQL: localhost ezio DevelopersEzio player
COMMON_SQL: localhost ezio DevelopersEzio common
LOG_SQL: localhost ezio DevelopersEzio log
LOCALE_SERVICE: romania
MAX_LEVEL: 127
MAX_LEVEL_STATUS: 92
MAX_STATUS: 90
SERVER_CHECK: 1
SERVER_VERSION: 0767662984
EMPIRE_WHISPER: 1
MARK_SERVER: 1
STONE_CHANCE: 100
adminpage_ip: 127.0.0.1
adminpage_ip1: 127.0.0.1
adminpage_ip2: 127.0.0.1
adminpage_ip3: 127.0.0.1
adminpage_password:**************

HetFrietje · 06 Iul 2019, 14:55

Baga in putty comanda : mysql -p (parola ceruta este : mysql)

grant all on *.* to mt2@"localhost" identified by "metin2";

grant all on *.* to user@"%" identified by "parola";

metin2 - username
parola - parola

alifnevazutul · 06 Iul 2019, 18:00

Deci am facut ceea ce mi-ai zis in putty, dar acum imi apare ceva de genu` Imagine

In navicat am doar tabelele astea iar pe site imi apare asta Imagine

Desi configuratia din public_html e facuta bine cu datele din mysql
Is convins ca e ceva banal ce imi scapa doar ca nu imi dau seama

HetFrietje · 06 Iul 2019, 18:03

alifnevazutul scrie: ↑06 Iul 2019, 18:00 Deci am facut ceea ce mi-ai zis in putty, dar acum imi apare ceva de genu` In navicat am doar tabelele astea iar pe site imi apare asta Desi configuratia din public_html e facuta bine cu datele din mysql
Is convins ca e ceva banal ce imi scapa doar ca nu imi dau seama

clar nu i full mysql, sau tu nu l-ai instalat bine.

un sfat, cand il instalezi da-i direct reboot, nu i da permisiuni la mysql

alifnevazutul · 06 Iul 2019, 18:07

E full crede-ma am 2 versiuni, nu inteleg de ce apare asa

HetFrietje · 06 Iul 2019, 18:39

adauga-ma pe discord, te ajut eu.

HetFrietje
#7236

YouTube · 06 Iul 2019, 21:08

alifnevazutul scrie: ↑06 Iul 2019, 18:00 In navicat am doar tabelele astea iar pe site imi apare asta

In acest caz reinstaleaza mysql, pentru ca nu este complet.

alifnevazutul · 06 Iul 2019, 22:13

Am dat 100 de euro pt pachetu` navicat , eu cred ca problema e ca i-am dat permsiuni in sql

Problema navicat

Navicat 12.1.27 (ultima versiune de navicat 12) cu keygen

Problema navicat.

Problema Navicat

Problema navicat 34k

Cine este conectat