خطا در اپدیت roundcube

[entel]

سلام من راند کوب رو بیلد میکنم خطای زیر و میده میشه راهنمایی کنید

Found MySQL version 10.6
Creating User: CREATE USER 'da_roundcube'@'localhost' IDENTIFIED BY 'G7T3ipUnc0ijZcQ';
ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2)
Granting access: GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,LOCK TABLES,INDEX,REFERENCES ON da_roundcube.* TO 'da_roundcube'@'localhost';
ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2)
Setting password: ALTER USER 'da_roundcube'@'localhost' IDENTIFIED BY 'G7T3ipUnc0ijZcQ';
ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2)
Editing roundcube configuration...
Roundcube 1.6.1 has been installed successfully.
WARNING: Changed defaults (These config options have new default values):
- 'skin'
- 'smtp_port'
- 'smtp_user'
- 'smtp_pass'
- 'jquery_ui_skin_map'
Executing database schema update.
ERROR: SQLSTATE[HY000] [1045] Access denied for user 'da_roundcube'@'localhost' (using password: YES)
ERROR: Failed to connect to database
Reloading litespeed.

[asrhosting]

از آموزش ذیل استفاده بفرمایید :
https://docs.directadmin.com/other-hosting-services/mariadb-mysql/troubleshooting.html#error-connecting-to-mysql-access-denied-for-user-da-admin-localhost-using-password-yes

[emdserver.com]

سلام من راند کوب رو بیلد میکنم خطای زیر و میده میشه راهنمایی کنید

Found MySQL version 10.6
Creating User: CREATE USER 'da_roundcube'@'localhost' IDENTIFIED BY 'G7T3ipUnc0ijZcQ';
ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2)
Granting access: GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,LOCK TABLES,INDEX,REFERENCES ON da_roundcube.* TO 'da_roundcube'@'localhost';
ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2)
Setting password: ALTER USER 'da_roundcube'@'localhost' IDENTIFIED BY 'G7T3ipUnc0ijZcQ';
ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2)
Editing roundcube configuration...
Roundcube 1.6.1 has been installed successfully.
WARNING: Changed defaults (These config options have new default values):
- 'skin'
- 'smtp_port'
- 'smtp_user'
- 'smtp_pass'
- 'jquery_ui_skin_map'
Executing database schema update.
ERROR: SQLSTATE[HY000] [1045] Access denied for user 'da_roundcube'@'localhost' (using password: YES)
ERROR: Failed to connect to database
Reloading litespeed.

دستورات زیر را بزن مشکلت حل میشه
systemctl stop mysqld
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
systemctl start mysqld






Now reset password for root:
mysql mysql -e "UPDATE mysql.user SET authentication_string=PASSWORD('rootpass') WHERE user='root'; FLUSH PRIVILEGES;"




And restart mysql without skip-grant-tables :
systemctl unset-environment MYSQLD_OPTS
systemctl stop mysqld
systemctl start mysqld
mysql -uroot -p'rootpass' -e "ALTER USER 'root'@'localhost' IDENTIFIED BY 'rootpass';"