Guest User

Untitled

a guest
Dec 24th, 2017
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. txtsd said: ↑
  2. So I've looked and found absolutely no guides that show how to make this work with MySQL.
  3.  
  4. I've installed MySQL and it's running, but I can't get mcmmo to work with it.
  5.  
  6. Any help will be appreciated!
  7. Have you created the user and database in mysql? Or did you just install MySQL and cross your fingers?
  8.  
  9. It looks like you didn't create the database in mysql for mcmmo to use. Here is what you need to do...
  10.  
  11. First, open your mcmmo.properties file and look for the following:
  12. MySQLuserName=xxxxxx1
  13. MySQLdbPass=xxxxxxx2
  14. MySQLdbName=xxxxxxxx3
  15. Your values will not be xxxxxxx but take note of them as you will need them.
  16.  
  17. At the command prompt run mysql. The following command should work:
  18.  
  19. mysql -u root -p
  20.  
  21. This will run mysql as user root with no password. You will probably be prompted for a password, just hit enter unless you set one during the install (can't recall if it asks you to or not).
  22.  
  23. Now you should get a new prompt. Congratulations you're using MySQL! Type the following commands, pressing enter after each semi-colon. Don't forget the semi-colon!
  24.  
  25. Code:
  26. CREATE DATABASE xxxxxxx3; [enter]
  27. CREATE USER 'xxxxxxx1'@'localhost' IDENTIFIED BY 'xxxxxxx2'; [enter]
  28. GRANT ALL PRIVILEGES ON xxxxxxx3.* TO 'xxxxxx1'@'localhost' WITH GRANT OPTION; [enter]
  29. FLUSH PRIVILEGES; [enter]
  30. EXIT [enter]
  31. There is no semi-colon after EXIT.
  32.  
  33. This is:
  34. Creating the database for mcmmo.
  35. Creating a user with a password.
  36. Letting MySQL know to give that user permission to that database.
  37. Committing the changes (I think... something kinda like that).
  38. Exiting.
  39.  
  40. MCmmo will create the tables and fill in the data upon launching bukkit.
  41.  
  42. Start up bukkit and you're on your way... hopefully.
Add Comment
Please, Sign In to add comment