Facebook
Twitter
- Server operating system version
- ubuntu
- Plesk version and microupdate number
- 18.0.46
hi,
i have error with my db Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist'
I tried to follow this tutorial to fix it https://support.plesk.com/hc/en-us/...x-server-Can-t-open-and-lock-privilege-tables
on the last step zcat /var/lib/psa/dumps/mysql.daily.dump.0.gz | sed -n '/-- Current Database: `mysql`/,/-- Current Database:*/p' | plesk db
I got this error ERROR 1813 (HY000) at line 180: Tablespace for table '`mysql`.`gtid_slave_pos`' exists. Please DISCARD the tablespace before IMPORT
how I can fix this try to search it but no luck
thank you
i have error with my db Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist'
I tried to follow this tutorial to fix it https://support.plesk.com/hc/en-us/...x-server-Can-t-open-and-lock-privilege-tables
on the last step zcat /var/lib/psa/dumps/mysql.daily.dump.0.gz | sed -n '/-- Current Database: `mysql`/,/-- Current Database:*/p' | plesk db
I got this error ERROR 1813 (HY000) at line 180: Tablespace for table '`mysql`.`gtid_slave_pos`' exists. Please DISCARD the tablespace before IMPORT
how I can fix this try to search it but no luck
thank you
