[Problem]Access Danied for user mt2

[trialend]

Witam!

Mam problem, po wpisaniu /start

[color=#ff0000]Ile Ch chcesz odpalić?[/color]

[color=#ff0000]1 - (1) Channel[/color]

[color=#ff0000]2 - (2) Channele[/color]

[color=#ff0000]3- (3) Channele[/color]

[color=#ff0000]4- (4) Channele[/color]
1
[color=#ff0000]Startuje DB[/color]
Real Server
Log Offlog_file_delete_old: stat: No such file or directory
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 seconds

[color=#ff0000]Startuje auth[/color]
PUBLIC_IP: [b][i]<tu bylo ip>[/i][/b] interface re0
HOSTNAME: auth
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: mt2 db: common
cannot start server while no common sql connected

[color=#ff0000]Startuje 1 Ch[/color]

PUBLIC_IP: 176.31.98.103 interface re0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: mt2 db: common
cannot start server while no common sql connected
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsks391046# mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsSuccess PLAYER
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsSuccess ACCOUNT
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsSuccess COMMON
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
  failed, retrying in 5 secondsSuccess HOTBACKUP

 

Czekam na odp

[~RyKoX~]

Czy to jest na plikach badara?

[trialend]

Czy to jest na plikach badara?

Kupiłem dedyka z BSD 8.3

Wgrałem mysql & porty wg tego tematu http://www.mpcforum.pl/topic/501837-mega-tutorial-serwer-metin2-od-podstaw-na-32-i-64-bitowym-freebsd-82/

Wgrałem gotowe pliki od Terenzo http://www.mpcforum.pl/topic/768196-dl-czyste-serverfiles-by-terenzo/

 

nie wiem o co chodzi ;/

[Alkoholic]

mt2 mt2!@# <---

 

CREATE USER 'mt2'@'localhost' IDENTIFIED BY 'mt2!@#';
GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'localhost' WITH GRANT OPTION;
flush privileges;

 

wklep to do "mysql -p" po jednym i enter po kazdym

[trialend]

mt2 mt2!@# <---

 

CREATE USER 'mt2'@'localhost' IDENTIFIED BY 'mt2!@#';
GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'localhost' WITH GRANT OPTION;
flush privileges;

 

wklep to do "mysql -p" po jednym i enter po kazdym

robiłem tak tyle że 'mt2'@'%'

 

zaraz zobaczę

 

//

ok działa

a powiedz mi mogę zmienić hasło z mt2!@# na inne?

[AdminFreeBSD]

Jeśli stworzyłeś takiego usera 'mt2'@'%' to lepiej szybko go usuń bo ci skasują bazę.

 

Tak możesz zmienić hasło usera mt2 wiąże się to z edycją wszystkich configów w plikach serwerowych.

[ProGosciu3]

Dokładnie tak jak mówi @up. Usuń tego usera 'mt2'@'%' bo wtedy akceptuje połączenie do bazy z każdego hosta. Dodaj 'mt2'@'localhost' a później dodaj 2 np. 'siema'@'host' i wtedy będzie akceptowało tylko tych którzy pasują do hosta.