Hi all, Please help to restore ISPConfig. To reset client counter ( because a lot of test users has been created), I have truncate all tables. As a result the admin account is lost. How can I recreate the admin account from mysql command line ?
I hope you did not empty all tables, e.g. when you emptied the server table, then you have to reinstall ispconfig as the data in that table is server specific and gets created by the installer. Regarding admin account, download the ispconfig tar.gz file and take a look into the install/sql/ispconfig3.sql file for the query to create the admin user.
