Am si eu o problema

MrPower · 08 Mar 2017, 20:38

Buna Ziua.

Am si eu o problema cu un server cand si dau start si apas pe ch1 imi apare asta :

Real Server
Log Offmysql_real_connect: Access denied for user 'mt2'@'localhost' (using passw ord: YES)
failed, retrying in 5 secondsPUBLIC_IP: 5.154.240.134 interface re0
HOSTNAME: auth
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YE S)
cannot open direct sql connection to host: localhost user: mt2 db: common
cannot start server while no common sql connected

******************************************************
* Universal Elements extension library *
* made by ricky92 *
* Version 1.2.4 *
******************************************************

[*] Module "Costume system" loaded.
[*] Module "Hooks" loaded.
Init hooks count: 1
UseItem hooks count: 1

PUBLIC_IP: 5.154.240.134 interface re0
HOSTNAME: channel1_core1
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YE S)
cannot open direct sql connection to host: localhost user: mt2 db: common
cannot start server while no common sql connected

******************************************************
* Universal Elements extension library *
* made by ricky92 *
* Version 1.2.4 *
******************************************************

[*] Module "Costume system" loaded.
[*] Module "Hooks" loaded.
Init hooks count: 1
UseItem hooks count: 1

PUBLIC_IP: 5.154.240.134 interface re0
HOSTNAME: channel1_core2
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 seconds
******************************************************
* Universal Elements extension library *
* made by ricky92 *
* Version 1.2.4 *
******************************************************

[*] Module "Costume system" loaded.
[*] Module "Hooks" loaded.
Init hooks count: 1
UseItem hooks count: 1

PUBLIC_IP: 5.154.240.134 interface re0
HOSTNAME: channel1_core3
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

******************************************************
* Universal Elements extension library *
* made by ricky92 *
* Version 1.2.4 *
******************************************************

[*] Module "Costume system" loaded.
[*] Module "Hooks" loaded.
Init hooks count: 1
UseItem hooks count: 1

PUBLIC_IP: 5.154.240.134 interface re0
HOSTNAME: game99
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 seconds

Server ONLINE
root@cloud:/usr/home/game # mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 seconds

Ma puteti ajuta.

Multumesc.

C-Stroia · 08 Mar 2017, 20:39

schimba parola mysql

Cum resetez parola mysql

Cod: Selectaţi tot

1. Se intra in putty cu utilizatorul si cu parola de root

2. Se opreste serverul MySQL:/usr/local/etc/rc.d/mysql-server stop
3. Se porneste serverul mysql fara parola de root:mysqld_safe --skip-grant-tables &
4. Ne conectam ca root la serverul mysql: mysql -u root
5. Rulam urmatoarele comenzi, care vor reseta parola de root:
use mysql;
update user set password=PASSWORD('paroladorita') where user='root';
flush privileges;
quit
6. Oprim serverul mysql: /usr/local/etc/rc.d/mysql-server stop
7. Il pornim normal: /usr/local/etc/rc.d/mysql-server start

De aici inainte totul ar trebui sa functioneze normal. Pentru siguranta putem testa daca parola s-a schimbat intr-adevar folosind clientul mysql:mysql -u root -p

Nu merge parola navicat cu parola setata mai sus, ce ar trebui sa fac ?

Tot in putty rulam urmatoarea comanda : grant all on *.* to root@'%' identified by 'paroladorita';

MrPower · 08 Mar 2017, 23:09

Am incercat cum ai spus mai sus tot asa imi apare

Am si eu o problema

Problema adunare yang automat / Problema descriere item

PROBLEMA INVENTAR 3/4 - PROBLEMA SOSETE DE CRACIUN ( AS DORII SA SE STOCHEZE AUT

Problema experienta negativa la Metine + Problema Pet Azrael

Problema bug costum fata,problema pagina bonusuri..

Cine este conectat