Salutare ,
Cand pornesc serverul cu comanda sh start.sh , imi apare urmatoarele erori in putty:

Log Offmysql_real_connect: Access denied for user 'm2user'@'localhost' (using pa ssword: YES)
mysql_real_connect: Access denied for user 'm2user'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: m2user db: common
cannot start server while no common sql connectedmysql_real_connect: Access denied for user 'm2user'@'localhost' (using password: YES)
failed, retrying in 5 secondsAccess denied for user 'm2user'@'localhost' (usi ng password: YES)
^C
root@metin2:/usr/home/game # mysql_real_connect: Access denied for user 'm2user' @'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'm2us er'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'm2us er'@'localhost' (using password: YES)
failed, retrying in 5 secondsSuccess PLAYER
mysql_real_connect: Access denied for user 'm2user'@'localhost' (using password: YES)

Cum pot rezolva ?

parola la mysql(navicat) ai resetat-o?Este una din rezolvarile acestei probleme.

Da am resetat-o.

Intri in navicat la serverul tau, si sus ai categoria user si dai click pe ea.
Intri in usr/home/game/channel1/CONFIG si vezi ce ai acolo cu localhost m2user m2pass!@# account...eu asa am.
Si compari si tu conexiunile din config cu user(mt2 sau m2user) si modifici incat sa fie acelasi user pass

Cum adica compar conexiuniile din config cu user ?

la m2user trebuie sa ai parola m2pass@#

Asa le am nu vezi mai sus ?

G.Marian scrie:Asa le am nu vezi mai sus ?

La userul din navicat trebuie sa ai parola respectiva ( din CONFIG )

Ai creat userul m2user in baza de date? Daca nu, fa asa:

mysql -u root -p

"PUNE ACTUALA PAROLA DE LA BAZA DE DATE (INTRI CU USER-UL root)"

GRANT ALL PRIVILEGES ON *.* TO 'm2user'@'%' IDENTIFIED BY 'm2pass@#' WITH GRANT OPTION;
flush privileges;
quit
/usr/local/etc/rc.d/mysql-server restart



P.S. Recomand sa schimbi parola si in CONFIG si in baza de date

3 zile,nici-un semn de viata, Subiect inactiv,arhivă!

[ Mesaj scris via Android ]