پاسخ : خطا در اپدیت roundcube
پاسخ : خطا در اپدیت 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.
دستورات زیر را بزن مشکلت حل میشه
systemctl stop mysqld
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
systemctl start mysqld
[COLOR=var(--code-ln-color)]
[/COLOR]
Now reset password for root:
mysql mysql -e "UPDATE mysql.user SET authentication_string=PASSWORD('rootpass') WHERE user='root'; FLUSH PRIVILEGES;"
[COLOR=var(--code-ln-color)]
[/COLOR]
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';"
