Fehler beim starten des Server's (PuTTy)

[SanjixHD]

Guten Abend,
folgender Fehler beim starten des Server's über PuTTy:

Real Server
Log Offmysql_real_connect: Access denied for user 'metin2'@'localhost' (using password: YES)
failed, retrying in 5 secondsPUBLIC_IP: 178.51.228.124 interface em0
HOSTNAME: auth
mysql_real_connect: Access denied for user 'metin2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: metin2 db: common
cannot start server while no common sql connected
PUBLIC_IP: 178.51.228.124 interface em0
HOSTNAME: channel1_core1
mysql_real_connect: Access denied for user 'metin2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: metin2 db: common
cannot start server while no common sql connected
PUBLIC_IP: 178.51.228.124 interface em0
HOSTNAME: channel1_core2
mysql_real_connect: Access denied for user 'metin2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: metin2 db: common
cannot start server while no common sql connected
mysql_real_connect: Access denied for user 'metin2'@'localhost' (using password: YES)
failed, retrying in 5 secondsPUBLIC_IP: 178.51.228.124 interface em0
HOSTNAME: channel1_core3
mysql_real_connect: Access denied for user 'metin2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: metin2 db: common
cannot start server while no common sql connected
PUBLIC_IP: 178.51.228.124 interface em0
HOSTNAME: game99
mysql_real_connect: Access denied for user 'metin2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: metin2 db: common
cannot start server while no common sql connected
mysql_real_connect: Access denied for user 'metin2'@'localhost' (using password: YES)
failed, retrying in 5 secondsroot@root258843:/usr/home/metin2 #

Wo ist der Fehler?
Danke falls mir Jemand helfen kann

mfG.
Sanji

[jubox123]

Das PW in der DB unter mysql>user "metin2" ist falsch, bzw stimmt nicht mit den Core PW's überein.

[.Ryuzaki™]

1. Putty öffnen
2. mysql -uroot -p
3. "ENTER"
3. grant all on *.* to root@"%" identified by "HierDeinPasswortRein";
4. grant all on *.* to mt2@"localhost" identified by "mt2!@#";
5. exit;
6. service mysql-server restart

[SanjixHD]

Originally Posted by Gillette'.Xynex

1. Putty öffnen
2. mysql -uroot -p
3. "ENTER"
3. grant all on *.* to root@"%" identified by "HierDeinPasswortRein";
4. grant all on *.* to mt2@"localhost" identified by "mt2!@#";
5. exit;
6. service mysql-server restart

mysql> grant all on . to root@"%" identified by "PWISTVERSTECKT";
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 'to ro ot@"%" identified by "PWISTVERSTECKT"' at line 1
mysql> grant all on . to mt2@"localhost" identified by "mt2!@#";
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 'to mt2@"localhost" identified by "mt2!@#"' at line 1
mysql> exit;
Bye
root@root258843:~ # service mysql-server restart
Stopping mysql.
Waiting for PIDS: 627.
Starting mysql.
root@root258843:~ #

Da kommt dieser Error und per Navicat habe ich jetzt mal das PW so gemacht, wie es in den Cores steht aber es kommt immernoch dieser Fehler.

[gerald500]

du musst das auch wirklich so machen wie er geschriben hat sprich
grant all on *.* to root@"%" identified by "HierDeinPasswortRein";
und nicht
grant all on . to root@"%" identified by "HierDeinPasswortRein";

die sterne gehören schon dazu sonst würde ja er auch nicht sagen du hast einen fehler im syntax

du kannst auch einfach die zeile kopieren und mit rechter maus taste in putty reinkopieren

[xXT4fuXx]

/usr/local/etc/rc.d/mysql-server stop
mysqld_safe --skip-grant-tables &
ENTER
mysql --user=root mysql oder einfach nur mysql

grant all on *.* to root@"%" identified by "DEIN PW"; ( Was in der CONFIG steht )

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

flush privileges;
exit;
/usr/local/etc/rc.d/mysql-server restart