Problem :/

[denBotBrauchIch!]

Hey
Ich hab ein kleines Problem mit meinem Root-Server. Vermutlich hab ich dieses Problem, weil ich mehrere mysql-Accounts erstellt habe.
Wenn ich den Server starte kommt:

 Spoiler

mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YS)
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: YS)
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 PLAYER
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YS)
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: YS)
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 seconds
2B8# Success COMMON
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YS)
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

Und ich kann mich nicht mehr mit Navicat verbinden:

 Spoiler

1130 - Host ... is not allowed to connect to this MySQL server

Ich vermute, dass diese zwei Probleme zusammenhängen
mfg.

[x3Bit]

Damit kannst du dein mysql pw vom benutzer root ändern

#1. Stoppe den MYSQL-Server
/usr/local/etc/rc.d/mysql-server stop

#2. Starte im Safe-Mode
mysqld_safe --skip-grant-tables &

# Noch einmal putty öffnen

#3. Logge dich in das MYSQL Terminal ein
mysql --user=root mysql

#4. Betrete nun die MYSQL Datenbank
use mysql;

#5. Update nun die User Tabelle mit dem neuen Passwort
UPDATE user SET Password=PASSWORD('hier-neues-passwort-eintragen') WHERE user='root';

#6. Hiermit werden die Rechte etc. neugeladen
flush privileges;

#7. Verlasse das MYSQL-Terminal
exit;

#8. Starte den MYSQL-Server neu
/usr/local/etc/rc.d/mysql-server restart

Is aus nem anderen Thread Kopiert weis nicht mehr woher^^

[.NighT™]

Originally Posted by x3Bit

Damit kannst du dein mysql pw vom benutzer root ändern


Is aus nem anderen Thread Kopiert weis nicht mehr woher^^

Du willst das PW vom User "root" ändern.
Wenn du dir den Fehler anschaust, steht da eindeutig "mt2".
@BotBrauchIch!:
Überprüf ob du den User "mt2" in der user Table von mysql erstellt hast.
Falls ja überprüf das PW, das du dort eingestellt hat mit dem, das in der CONFIG der jeweiligen Channel-Cores steht.
Danach rebooten und es sollte gehen.

@Hishem: Hi xD

Greetz
.NighT™

[denBotBrauchIch!]

1) Die User-Tabelle wird irgendwie nicht angezeigt. (??)

2) Wenn ich den User "mt2" löschen möchte, kommt diese Fehlermeldung:

 Spoiler

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select * from user

[.NighT™]

Du musst ihn nicht löschen.
Du musst einfach nur überprüfen, ob das Passwort von Mysql mit dem Passwort der Config´s übereinstimmt. Wenn nicht, dann geht es nicht. Wie bei deinem Fehler gezeigt wird.

[denBotBrauchIch!]

Jetzt kommt "connection refused"

[.SurPrise]

Wonach kommt Connection Refused?

[denBotBrauchIch!]

Connection refused ist weg, dafür ist jetzt das da:

 Spoiler

1
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 secondsPUBLIC_IP: XXX.XXX.XXX.XXX interface nfe0
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
PUBLIC_IP: XXX.XXX.XXX.XXX interface nfe0
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
2B8# PUBLIC_IP: XXX.XXX.XXX.XXX interface nfe0
HOSTNAME: channel99
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 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 seconds
2B8# 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 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)
...... usw...

??