salut. am server fille forest
am instalat game toate bune...
la mysql imi da o erroare dupa ce se dezarhiveaza putin..
dupa incerc sa schimb parola mysql
la fel eroare,,,, le voi pune aici
mentionez ca a mers o data de am si jucat pe server...

erroare cand schimb parola mysql..
ERROR 1146 (42S02): Table 'mysql.host' doesn't exist
si erroare la instalare mysql

tar: Error exit delayed from previous errors.
ce este de facut sa pot schimba parola si sa nu mai dea erroarea asta cand pornesc sv

PORNESC BAZA DE DATE ..
Real Server
Log Offmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 seconds

PORNESC LOGINU ..
PUBLIC_IP: 77.81.181.253 interface em0
HOSTNAME: dev_0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
cannot open direct sql connection to host: localhost user: ezio db: common
cannot start server while no common sql connected

PORNESC CHANNEL1_2CORE ..
PUBLIC_IP: 77.81.181.253 interface em0
HOSTNAME: dev1_1
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
cannot open direct sql connection to host: localhost user: ezio db: common
cannot start server while no common sql connected
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 seconds

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

mysqld_safe --skip-grant-tables &

mysql -u root

use mysql

update user set password=PASSWORD('aici_parola_ta') where user='root' ;

flush privileges ;

quit

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

SkyLine scrie: ↑02 Mar 2020, 23:58 /usr/local/etc/rc.d/mysql-server stop

mysqld_safe --skip-grant-tables &

mysql -u root

use mysql

update user set password=PASSWORD('aici_parola_ta') where user='root' ;

flush privileges ;

quit

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

am urmat in tocmai tutorialul tau si se vad errorile si aici:

root@metin2:~ # /usr/local/etc/rc.d/mysql-server stop
mysql not running? (check /var/db/mysql/metin2.hzone.ro.pid).
root@metin2:~ # mysqld_safe --skip-grant-tables &
[1] 2270
root@metin2:~ # 200303 00:23:02 mysqld_safe Logging to '/var/db/mysql/metin2.hzone.ro.err'.
200303 00:23:02 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.5.53 Source distribution

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql
Database changed
mysql> update user set password=PASSWORD('n11u4m34e3ou') where user='root' ;
ERROR 1146 (42S02): Table 'mysql.user' doesn't exist
mysql> flush privileges ;
ERROR 1146 (42S02): Table 'mysql.host' doesn't exist
mysql> quit
Bye
root@metin2:~ # /usr/local/etc/rc.d/mysql-server restart
Stopping mysql.
Waiting for PIDS: 2346200303 00:24:15 mysqld_safe mysqld from pid file /var/db/mysql/metin2.hzone.ro.pid ended
.
Starting mysql.

... cere la host să-ti reinstaleze freebsd-ul, iar apoi instalează serverfiles-ul, ai șters tu ce nu trebuia.

[ Postat de pe iPhone ]

Topic inactiv, arhivat.