Creating user in User table using SQL

[Gharryh1957]

Hi All,

As I am not able to add a user true the spcialpages from my wiki, is it possible to do so using SQL instructions. I have access to all the tables on the server.

If possible how should the SQL command look like.

Regards

Harry H. Arends

[MEMZAT]

On 12/2/2021 at 10:57 AM, Gharryh1957 said:

Hi All,

As I am not able to add a user true the spcialpages from my wiki, is it possible to do so using SQL instructions. I have access to all the tables on the server.

If possible how should the SQL command look like.

Regards

Harry H. Arends

 

[Skizzerz]

Manually creating a user via SQL is not recommend. If you need to create a user in the backend, use the createAndPromote.php maintenance script.

[Gharryh1957]

I tried that but get/got this message:

This script must be run from the command line

[Skizzerz]

On 3/3/2022 at 12:43 PM, Gharryh1957 said:

I tried that but get/got this message:

This script must be run from the command line

Correct, you will need to use the command line (accessible via SSH on linux servers) in order to run maintenance scripts. Any good host has the ability to connect via SSH, so look into how to do that wherever you are having your wiki hosted.

[Karen]

在2022年3月7日上午6點12分，Skizzerz說：

正確，您需要使用命令行（可透過linux伺服器上的SSH訪問）來執行維護指令碼。 任何好的主機都可以透過SSH進行連線，因此請研究如何在您託管維基時如何進行連線。

 

[Karen]

2 minutes ago, Karen said:

 

謝謝