Acum merge site-u si dar apare problema din putty de care ziceam :KrYpToNNN scrie: ↑07 Aug 2019, 00:04La ceea ce-ti apare acum, fa urmatorii pasi, cu exactitate :alifnevazutul scrie: ↑06 Aug 2019, 23:52Mersi de info . Am verificat si nu e alt "var" acolo. In schimb nu mai primesc eroarea cu "unknown database" in putty. Primesc asta in putty :KrYpToNNN scrie: ↑06 Aug 2019, 23:38hai ca incerc eu sa te ajut cu chestia asta pentru ca mereu mi se intampla asta cand reinstalam mysql si uitam sa fac o chestie mereu si imi dadea chestia cu "unknown database"
Intra in /var/db/ si vezi sa nu ai INCA un folder cu "var" acolo. Daca ai vreun serverfiles pe 40k cum am eu, s-ar putea ca atunci cand urci arhiva mysql si ii dai -tar xzvf la arhiva, sa-ti bage calea catre mysql-ul bun -> /var/db/var/db/mysql . Verifica daca este asa cum ti-am zis si, daca da, da-i click dreapta pe mysql-ul din calea pe care tocmai am zis-o si la path sa fie doar "/var/db/" (si cu ultimul " / "). Dupa asta poti sa-i dai linistit start la server, bafta
PS: Asta e valabil doar daca ai ceea ce am zis aici. Daca nu, nu stiu altcevaIar pe site imi apare asta:Cod: Selectaţi tot
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: 188.214.88.236 interface em0 HOSTNAME: auth mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mys ql.sock' (2) cannot open direct sql connection to host: localhost user: root db: common cannot start server while no common sql connected PORNESC CHANNEL1_2 CORE... PUBLIC_IP: 188.214.88.236 interface em0 HOSTNAME: channel1_1 mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mys ql.sock' (2) cannot open direct sql connection to host: localhost user: root 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 secondsPUBLIC_IP: 188.214.88.236 interface em0 HOSTNAME: channel1_2 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: root db: common cannot start server while no common sql connected PORNESC CHANNEL99_1 CORE... PUBLIC_IP: 188.214.88.236 interface em0 HOSTNAME: channel99_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: root 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 CH1 pornit cu succes! root@metin2:/usr/game # mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) failed, retrying in 5 secondsIn Navicat imi apare ceva de genu:Cod: Selectaţi tot
Connection refusedAm protectie IPFW si mi-am adaugat ip-u in putty ca sa pot avea acces la db dar degeaba.
As putea rezolva totul simplu printr-o reinstalare de svfiles , dar vreau sa stiu cum sa rezolv , nu doar sa fac sa fie.
Va multumesc pana acum de informatii , am sa tin cont de tot ce imi ziceti.
1. Intra in putty si logheaza-te
2. /usr/local/etc/rc.d/mysql-server stop
3. chown -R mysql /var/db/mysql && chgrp -R mysql /var/db/mysql
4. reboot
5. te loghezi iarasi si dai urmatoarele comenzi :
6. /usr/local/etc/rc.d/mysql-server stop
7. mysqld_safe --skip-grant-tables &
8. mysql -u root
9. use mysql
10. update user set password=PASSWORD('parolata') where user='root' ;
11. flush privileges ;
12. quit
13. /usr/local/etc/rc.d/mysql-server restart
14. start server
Vezi daca-ti merge
Ma jur ca ii dau foc ))
edit:
de 
de 
de 
de