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

Post here doubts, ideas, suggestions and support requests about the website and the forums.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
angkor_tm
Posts: 135
Joined: Fri Nov 19, 2010 1:38 pm

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

Post by angkor_tm » Thu Jan 30, 2014 12:44 pm

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;

Post Reply