Tusaha Maqaalka
Log inCWP Control Panelsanduuqa boostada wareegsan, fariinta qaladka soo socota ayaa soo baxaysa ▼
DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator.

Hubi khaladaadka xogta wareega wareega
Fadlan hubigalka qaladka wareega wareega ▼
/usr/local/cwpsrv/var/services/roundcube/logs/errorsHaddi khaladkaagu u ekaado sidan▼
[17-May-2021 20:18:11 +0000]: <gv4343g> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 173 (GET /roundcube/) [17-May-2021 20:18:11 +0000]: <gv4343g> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) (GET /roundcube/)
Hubi faylka isku xidhka wareega
Hubi erayga sirta ah ee ku jira faylka qaabeynta wareega /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php
grep db_dsnw /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php
Wax-soo-saarku wuxuu ahaan doonaa sidan ▼
$config['db_dsnw'] = 'mysqli://roundcube:42Etn3fd7skc@localhost/roundcube';
- Tani waxay muujinaysaa in erayga sirta ah uu yahay
42Etn3fd7skc
Hadda aynuMySQLqiime isku mid ah dhig ▼
mysql -e "SET PASSWORD FOR 'roundcube'@'localhost' = PASSWORD('42Etn3fd7skc');"
mysql -e "FLUSH PRIVILEGES;"Hubi haddii wareeggu shaqaynayo?
Hadda, mar kale hubi haddii wareeggu shaqeeyo?
Haddi ciladani dhacdo ▼
[17-May-2021 20:29:09 +0000]: <gv91fd30g> DB Error: [1146] Table 'roundcube.session' doesn't exist (SQL Query: SELECT `vars`, `ip`, `changed`, now() AS ts FROM `session` WHERE `sess_id` = 'gv93bfdsfdffdfdj3') in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 539 (GET /roundcube/)
ku socodsii amarkan ▼
mysql -u root 'roundcube' < /usr/local/cwpsrv/var/services/roundcube/SQL/mysql.initial.sql
Waa taas, ku raaxayso kaaga wareegsan (cube wareegsan).
Intaa waxaa dheer, waxaa jira qalad kale oo ka duwan qaladka kor ku xusan, xalka iyo habka hagaajinta, fadlan ka daalaco xiriirka maqaalka ee hoose▼
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) la wadaago "Xallinta iyo hagaajinta qaladka DATABASE: XIRIIRKU waa fashilmay!", kaas oo adiga ku caawinaya.
Ku soo dhawoow inaad wadaagto xiriirka maqaalkan:https://www.chenweiliang.com/cwl-1163.html
Si aad u furto khiyaamo qarsoon🔑, ku soo biir kanaalkayaga Telegram!
Share iyo like haddi aad ka heshay! Saamiyadaada iyo waxa aad jeceshahay ayaa ah dhiirigelintayada sii socota!
![Xalli Khaladka DB: [1286] Matoorka kaydinta aan la garanayn 'InnoDB xaashida 2 Xalli Khaladka DB: [1286] Matoorka kaydinta aan la garanayn 'InnoDB xaashida 2](https://img.chenweiliang.com/2021/05/innodb-is-off.jpg)