What is the administrator account added to the empire cms database?

Add an administrator account by operating the Empire CMS database. Specific steps include: Connect to the database. Find the administrator table (empire_admin). Insert new administrator (using encrypted password and administrator group ID). save Changes.

Add administrator account to Empire CMS database

How to operate?

Adding an administrator account in the Empire CMS needs to be done by operating the database. The specific steps are as follows:

1. Connect to the database

Use database management tools (such as phpMyAdmin or MySQL Workbench) to connect to the Empire CMS database.

2. Find the administrator table

Find the table named empire_admin in the database, which stores the administrator account information.

3. Insert a new administrator

Execute the following SQL statement to insert a new administrator account:

<code class="sql">INSERT INTO empire_admin (
  adminname,
  password,
  adminclassid,
  createdate,
  checktime
)
VALUES (
  '新管理员账号',
  '加密后的密码',
  '管理员组ID',
  NOW(),
  NOW()
);</code>

Among them:

• adminname: The username of the new administrator
• password: The password of the new administrator (needs to be encrypted using the encryption function provided by Empire CMS)
• adminclassid: The administrator group ID to which the new administrator belongs
• createdate: Account creation time
• checktime : Account last login time

4. Save changes

After executing the above SQL statement, the new administrator account has been added to the database. Save changes and close the database connection.

Note:

• Make sure the password of the new administrator account is encrypted.
• The administrator group ID can be found in the empire_adminclass table.
• The new administrator account needs to be activated in the Empire CMS backend before it can be used.

The above is the detailed content of What is the administrator account added to the empire cms database?. For more information, please follow other related articles on the PHP Chinese website!