Fehler beim starten des Server's (PuTTy)

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

Quote:

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

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

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

Quote:

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

Quote:

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.

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

/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