Strumful scrie:Salut am vrut sa pun un serverfiles pe vdi si cand am bagat comanda:

GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'localhost'
IDENTIFIED BY 'root' WITH GRANT OPTION;

A aparut eroare .
Am cautat pe forum cum ca cica trebuie ca parolele din navicat de la user sa coincida cu cea din chanel le-am pus la fel dar acum imi da o gramada de erori am restetat parola la baza de date in root si am pus peste tot root si degeaba da eroarea asa:

nection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
Success ACCOUNT
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
Success COMMON
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
Success HOTBACKUP
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused

Nu stiu cum sa o mai rezolv

select * from mysql.user;

/usr/local/etc/rc.d/mysql-server stop
apo
chown -R mysql /var/db/mysql && chgrp -R mysql /var/db/mysql
apo
/usr/local/etc/rc.d/mysql-server start
/usr/local/etc/rc.d/mysql-server stop
Apoi
mysqld_safe --skip-grant-tables &
Apoi
mysql -u root
apoi
use mysql;
apoi
update user set password=PASSWORD("Parola aleasa intre ghilimele") where User='root';
apoi
flush privileges;
apoi
quit

Strumful scrie:Intrebare:
Problema poate fi din cauza ca am dezarhivat baza de date direct in filezila?
Adica eu nu am bagat arhiva.tar.gz am dezarhivat-o si am bagat-o direct acolo.

/usr/local/etc/rc.d/mysql-server stop

chown -R mysql /var/db/mysql && chgrp -R mysql /var/db/mysql

/usr/local/etc/rc.d/mysql-server start
/usr/local/etc/rc.d/mysql-server stop
Apoi
mysqld_safe --skip-grant-tables &
Apoi
mysql -u root
apoi
use mysql;

select * from mysql.user;

update user set password=PASSWORD("Parola aleasa intre ghilimele") where User='utilizatorul gasit acolo';
apoi
flush privileges;
apoi
quit

Ene scrie:normal o bagi tar.gz in filezila si o instalezi din puty sau virtual box ce folosesti

comanda instalare
mysql : tar -xzvf mysql.tar.gz

game: tar -xzvf game.tar.gz