We moved our repositories to BitBucket!

If you can't login or you can't register to the forums do not rise an issue, instead please write to support (at) l2jserver.com

Check our wiki!

Report server issues here

Forum has been updated to phpBB 3.2, let's see if this fixes some minor bugs we had.

Thank you for visiting http://www.l2jserver.com/

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