DIR : /home/kozerus/public_html/go/dgs0/jk_notes_dgs_users.sql

/home/kozerus/public_html/go/dgs0

GRANT SELECT, INSERT, UPDATE, DELETE, 
	CREATE TEMPORARY TABLES, LOCK TABLES, CREATE, ALTER, DROP
          ON ka10_dgs.* TO ka11_dgs@localhost IDENTIFIED BY '..goko';


          ON ka10_dgs.* TO ka11_dgs@localhost IDENTIFIED BY 'adminsecret';

For safety reasons, the website should be accessed by a separate dragon-db-user
who SHOULD NOT have rights to create, alter or drop tables!

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLES
          ON ka11_dgs.* TO ka11_dgs1@localhost IDENTIFIED BY '..go';



Create database-tables needed for a Dragon Go Server
NOTE: This DDL-Export has been created using PHPMyAdmin: Export(DB) with Export (SQL) and Options:
      - Add 'IF NOT EXISTS': on
      - Add 'AUTO_INCREMENT' value: off
      - Enclose table and field names with backquotes: on
      - Data: off
      'dragon-ddl.sql' (unused tables removed)

Have the dragon-db-admin-user create all the tables:

   > mysql -h mysqlhost -u dragon_admin -D dragondb -p < specs/db/dragon-ddl.sql

Import mandatory initial-data for the server:

   > mysql -h mysqlhost -u dragon_admin -D dragondb -p < specs/db/dragon-data.sql


IMPORTANT NOTE:
   Before you try logging in on your local DGS-server, ensure that at least the core translation files
   have been generated.
   Otherwise the import in step 2 may fail because of changed primary-keys of translation-data that will be
   inserted by the running server itself.

Step 1: generate the translations files:

  > mkdir translations
  > su -c 'chgrp www-data translations'
  > chmod 775 translations/
  > pushd scripts
  > php make_all_translationfiles.php
  > popd


# ACTIVATE-statements:
UPDATE Players SET Adminlevel=0xffff WHERE Handle='ka10_dgs';
UPDATE Players SET Adminlevel=0xffff WHERE Handle='ka10_dgs0';
UPDATE Players SET Adminlevel=0xffff WHERE Handle='ka10_dgs1';
UPDATE Players SET Adminlevel=0xffff WHERE Handle='ka10_dgs2';


# UPDATE Players SET Adminlevel=0xffff WHERE Handle='ka11_dgs00';
# UPDATE Players SET Adminlevel=0xffff WHERE Handle='ka11_dgs01';
#UPDATE Players SET Adminlevel=0xffff WHERE Handle='ka11_dgs02';




UPDATE Players SET UserFlags=UserFlags & (4|8) WHERE Handle='ka10_dgs';
UPDATE Players SET UserFlags=UserFlags & (4|8) WHERE Handle='ka10_dgs0';
UPDATE Players SET UserFlags=UserFlags & (4|8) WHERE Handle='ka10_dgs1';
UPDATE Players SET UserFlags=UserFlags & (4|8) WHERE Handle='ka10_dgs2';
UPDATE Players SET UserFlags=UserFlags & (4|8) WHERE Handle='ka10_dgs00';
UPDATE Players SET UserFlags=UserFlags & (4|8) WHERE Handle='ka10_dgs01';
UPDATE Players SET UserFlags=UserFlags & (4|8) WHERE Handle='ka10_dgs02';






UPDATE Verification AS V INNER JOIN Players AS P ON P.ID=V.uid SET V.Verified=NOW(), V.Counter=V.Counter+1 WHERE P.Handle='ka10_dgs';
UPDATE Verification AS V INNER JOIN Players AS P ON P.ID=V.uid SET V.Verified=NOW(), V.Counter=V.Counter+1 WHERE P.Handle='ka10_dgs0';
UPDATE Verification AS V INNER JOIN Players AS P ON P.ID=V.uid SET V.Verified=NOW(), V.Counter=V.Counter+1 WHERE P.Handle='ka10_dgs1';
UPDATE Verification AS V INNER JOIN Players AS P ON P.ID=V.uid SET V.Verified=NOW(), V.Counter=V.Counter+1 WHERE P.Handle='ka10_dgs2';
UPDATE Verification AS V INNER JOIN Players AS P ON P.ID=V.uid SET V.Verified=NOW(), V.Counter=V.Counter+1 WHERE P.Handle='ka10_dgs00';
UPDATE Verification AS V INNER JOIN Players AS P ON P.ID=V.uid SET V.Verified=NOW(), V.Counter=V.Counter+1 WHERE P.Handle='ka10_dgs01';
UPDATE Verification AS V INNER JOIN Players AS P ON P.ID=V.uid SET V.Verified=NOW(), V.Counter=V.Counter+1 WHERE P.Handle='ka10_dgs02';

https://www.dragongoserver.net/install.php

# insert into players (handle, password, Registerdate, BlockReason ) value( "ka10_dgs", "..goko", "2018-07-15", "blockreason" );
insert into players (handle, password, Registerdate, BlockReason ) value( "ka10_dgs0", "..goko", "2018-07-15", "blockreason" );
insert into players (handle, password, Registerdate, BlockReason ) value( "ka10_dgs1", "..goko", "2018-07-15", "blockreason" );
insert into players (handle, password, Registerdate, BlockReason ) value( "ka10_dgs2", "..goko", "2018-07-15", "blockreason" );
insert into players (handle, password, Registerdate, BlockReason ) value( "ka10_dgs00", "..goko", "2018-07-15", "blockreason" );
insert into players (handle, password, Registerdate, BlockReason ) value( "ka10_dgs01", "..goko", "2018-07-15", "blockreason" );
insert into players (handle, password, Registerdate, BlockReason ) value( "ka10_dgs02", "..goko", "2018-07-15", "blockreason" );

select handle,password, Registerdate, BlockReason from players;


update players set password="35675e68f4b5af7b995d9205ad0fc43842f16450" where handle="ka10_dgs";
update players set password="35675e68f4b5af7b995d9205ad0fc43842f16450" where handle="ka10_dgs0";
update players set password="35675e68f4b5af7b995d9205ad0fc43842f16450" where handle="ka10_dgs1";
update players set password="35675e68f4b5af7b995d9205ad0fc43842f16450" where handle="ka10_dgs2";
update players set password="35675e68f4b5af7b995d9205ad0fc43842f16450" where handle="ka10_dgs00";
update players set password="35675e68f4b5af7b995d9205ad0fc43842f16450" where handle="ka10_dgs01";
update players set password="35675e68f4b5af7b995d9205ad0fc43842f16450" where handle="ka10_dgs02";

update players set newpassword="i1B61D4D005CCB0E39709C01A29D4BD05ADFC3F49C" where handle="ka10_dgs";
update players set newpassword="i1B61D4D005CCB0E39709C01A29D4BD05ADFC3F49C" where handle="ka10_dgs0";
update players set newpassword="i1B61D4D005CCB0E39709C01A29D4BD05ADFC3F49C" where handle="ka10_dgs1";
update players set newpassword="i1B61D4D005CCB0E39709C01A29D4BD05ADFC3F49C" where handle="ka10_dgs2";
update players set newpassword="i1B61D4D005CCB0E39709C01A29D4BD05ADFC3F49C" where handle="ka10_dgs00";
update players set newpassword="i1B61D4D005CCB0E39709C01A29D4BD05ADFC3F49C" where handle="ka10_dgs01";
update players set newpassword="i1B61D4D005CCB0E39709C01A29D4BD05ADFC3F49C" where handle="ka10_dgs02";

update plasers set Registerdate="
" where handle="ka10_dgs";
update plasers set BlockReason="
" where handle="ka10_dgs";

select id, type, handle, sessioncode, sessionexpire,registerdate from players;

| ID |
 Type |
 Handle |
 Password                                 |
 Newpassword |
 Sessioncode                               |
 Sessionexpire       |
 Lastaccess          |
 LastQuickAccess     |
 LastMove            |
 Registerdate |
 Hits |
 VaultCnt |
 VaultTime           |
 Moves |
 Activity |
 Name  |
 Email |
 Rank |
 SendEmail |
 Notify |
 NotifyFlags |
 CountMsgNew |
 CountFeatNew |
 CountBulletinNew |
 Adminlevel |
 AdminOptions |
 AdminNote |
 Timezone |
 Nightstart |
 ClockUsed |
 ClockChanged |
 Rating |
 Rating2 |
 RatingMin |
 RatingMax |
 InitialRating |
 RatingStatus |
 Open |
 Lang |
 VacationDays |
 OnVacation |
 Running |
 Finished |
 RatedGames |
 Won |
 Lost |
 GamesMPG |
 Translator |
 IP         |
 Browser                                                                           | Country | BlockReason | ForumReadTime       | ForumReadNew | UserFlags | SkinName | MenuDirection | TableMaxRows | Button | UserPicture | NextGameOrder | SkipBulletin | RejectTimeoutWin | ThumbnailSize |
+-

update players set sessioncode = "1B61D4D005CCB0E39709C01A29D4BD05ADFC3F49C" where id > 1;




nano /usr/local/Cellar/mysql/5.6.20_1/my.cnf

Find the line that looks like so:

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Comment above line out and restart mysql server

mysql.server restart

phpmyadmin| more| variables| sql mode| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
phpmyadmin| more| variables| sql mode|