For some reason the database of cyberpanl does not exist. it wasn’t added when installing or i accidentally deleted it.
# OperationalError at /
(1045, "Access denied for user 'cyberpanel'@'localhost' (using password: YES)")
when i check there is no 'cyberpanel' user or database cyberpanel created in mariadb.
when i create 1 user as 'cyberpanel' it says missing table.
when i create 1 table loginSystem_administrator it says -- 1364, "Field 'id' doesn't have a default value". even though I added the id, userName, passwork and default values NOT NULL primary key(id). it still gives this error. I tried following the instructions but it still doesn't work. https://community.cyberpanel.net/t/how-to-change-admin-username/17100/19 and https://community.cyberpanel.net/t/urgent-i-deleted-the-cyberpanel-database-accidently-please-help-what-can-i-do-now/36626/8
error_logs.txt :
05.28.2023_19-00-04] (1045, "Access denied for user 'cyberpanel'@'localhost' (using password: YES)"). Renew.SSLObtainer
[05.29.2023_19-00-04] Running SSL Renew Utility
[05.29.2023_19-00-04] (1146, "Table 'cyberpanel.websiteFunctions_websites' doesn't exist"). Renew.SSLObtainer
[05.30.2023_19-00-05] Running SSL Renew Utility
[05.30.2023_19-00-05] (1146, "Table 'cyberpanel.websiteFunctions_websites' doesn't exist"). Renew.SSLObtainer
then i installed : set sql_mode=""
erorr : Could Not Login, Error message: (1054, "Unknown column 'loginSystem_administrator.firstName' in 'field list'")
I don’t know how to fix this error, is there an alternative sql file to import it?
if there is this sql file can you give me the link. thanks !