Page 1 of 1

Wiki guide: small fix for Install MySQL and create the DB

Posted: Thu Jan 30, 2014 12:44 pm
by angkor_tm
http://www.l2jserver.com/wiki/Setup_Server_-_Linux
You need to add privileges DROP because some sql-scripts require them.
example: droplist.sql, dimensional_rift.sql, fort_spawnlist.sql and other...
DROP TABLE IF EXISTS `droplist`;
...
or you have Error: DROP command denied to user....

Installing actual server
1) Install MySQL and create the DB
grant CREATE,INSERT,DELETE,UPDATE,SELECT,DROP on l2jldb.* to l2j@localhost;
grant CREATE,INSERT,DELETE,UPDATE,SELECT,DROP on l2jgdb.* to l2j@localhost;
grant CREATE,INSERT,DELETE,UPDATE,SELECT,DROP on l2jcdb.* to l2j@localhost;