SQL Query to add new account

[devdevdev1]

Hi everyone, for the life of me I can't find a query that add new account (username and password) I hope it is possible , I know there are tools that do this but I am having issue with my MSSQL server as I am only doing it on my pc and there are some issue with the access so any account I create in MSSQL local host won't be able to login.

Thank you in advance.

 

[KarLi]

Hi everyone, for the life of me I can't find a query that add new account (username and password) I hope it is possible , I know there are tools that do this but I am having issue with my MSSQL server as I am only doing it on my pc and there are some issue with the access so any account I create in MSSQL local host won't be able to login.

Thank you in advance.

why u dont use an editor to make account? mumaker,mueditor 2.1 / mu account create md5 etc

 

[kayito]

Depends on the files, some have more or less "not nullable" fields that require a value but this generally works.

Change "MuOnline" for the name of your Database
'testid' is the account
'testpw' is the password
'testname' is the name of the owner (doesn't really matter)
1234567891234567 is the secret code
the 0 is for bloc_code
the 1 is for clt1_code

USE MuOnline
INSERT INTO MEMB_INFO (memb___id, memb__pwd, memb_name, sno__numb, bloc_code, ctl1_code)
VALUES ('testid', 'testpw', 'testname', 1234567891234567, 0, 1)

if the query says that some of those fields doesn't exist, just remove the field name and its positional matching value
otherwise if the query says that requires some specific values like AccountLevel, AccountExpireDate, etc. just add them in the first parenthesis at the end separated with comas and in the second parenthesis add the values always matching the position of every value in both parenthesis

 

[devdevdev1]

Thanks Kayito i will try it

 

[KarLi]

Thanks Kayito i will try it

you can also just type in the table manually the user id, user pass, memb name NULL and so on, just take an example from other same database how it looks when there is account and write it manually.