Issues

Cannot create table - Permission denied

1. Update database file permission

   docker exec mysql chown -R mysql:mysql /var/lib/mysql/npm
   

2. Restart database container

   docker restart mysql
   

3. Recreate database container

   • Backup database

     docker exec -it mysql sh
     mysqldump -u root -pnpm --all-databases > alldb.sql
     

   • Delete container and volume

     docker rm -f mysql
     docker volume rm mysql
     

   • Recreate container

     docker compose up mysql -d
     

   • Restore database

     docker exec -it mysql sh
     mysql -u root -pnpm < alldb.sql
     

owner is null

mysql -u root -pnpm npm

User id status

select id,email from npm.user;

-- related tables
update npm.certificate set owner_user_id = '<id>';
update npm.proxy_host set owner_user_id = '<id>';