1

Help setting up MySQL

TheLibra123 7/15/13 7:01 am
218
7/20/2013 10:55 am
I'm a beginner when it comes to MySQL. I've dabbled with it here and there, but I really don't know what I'm doing. Would someone offer a little of their time to help me get started please?

(I'm not looking for people to link me to youtube videos, I know I can look it up on youtube, and I probably will, but I just prefer someone I can talk to, and ask questions if I don't understand something.)

You can add me on skype if you want.
LibraRob21
Posted by
TheLibra123
Level 2 : Apprentice Miner
0

  Have something to say?

JoinSign in

10

Mayoz
07/15/2013 8:44 am
Level 29 : Expert System
You're going to need to be a little more spicific, do you need help connecting to the database, do you need help making one?
1
TheLibra123
07/15/2013 9:04 am
Level 2 : Apprentice Miner
I was just finally able to download it off of the main site. I was having trouble with it before o.O they changed it to making you download it through oracle, and oracle wouldn't let me sign up. Anyways... I would need help with everything pretty much lol. I've only used MySQL for ragnarok online before. But that was a while ago, and I forget how to use it. I'm pretty sure I can handle the original setup, like making an account and all of that for the server, but I would need help connecting it to my server, or plugins, or however it works.
1
TheLibra123
07/15/2013 12:13 pm
Level 2 : Apprentice Miner
ok, so far I've managed to convert 3 plugins, but I don't see any information on the tables? they are all just blank? and I'm having the most trouble trying to convert PEX to MySQL from YML. Again, it shows no tables, even after I import the permissions list.
1
aman207
07/15/2013 3:46 pm
Level 40 : Master Cake
Any errors in the console?
1
TheLibra123
07/16/2013 5:55 pm
Level 2 : Apprentice Miner
I've managed to convert everything else I've attempted, to mysql. It's just the permissions I'm still having trouble converting. probably because it's the only one that I have any information stored that I'm trying to import to mysql. It doesn't give me any errors, and it does create tables when I first convert it. The tables are "permissions" "permissions_entities" and "permission_inheritance" (not sure if that last one it correct). In the inheritance table, it has the names of all the users, and their group permissions title. In the entities table, it has the names of all the users, but not the group permissions titles. Nothing in the permissions table except for "default | modifyworld*". In-game while it's like this, it will NOT show the permission group prefix for the players in the chat, and no player has any permissions (even ops). I was able to add the permission group titles to the column provided for it in the entities table though. After I had done this, the players now had the prefix in-game. But still no permissions what so ever.

Can anyone help me fix the permissions? Or show me/tell me how to add the permissions manually?

Note: I'd prefer if someone could just add me on skype, so we could get this fixed up much quicker.
1
TheLibra123
07/19/2013 1:58 pm
Level 2 : Apprentice Miner
Still need help with this!
1
nahtnam
07/20/2013 9:14 am
Level 18 : Journeyman Modder
Step 1 Dowload Xampp...
Step 2 turn on MySql
Step 3 Open your browser and go to http://localhost/phpmyadmin
Step 4 create a database
Step 5 put in info in config of plugins like this:

host: localhost
username: root
password: (blank)
db name: whatever you named it!
1
TheLibra123
07/20/2013 10:29 am
Level 2 : Apprentice Miner
Oh, I forgot about Xampp. What exactly does Xampp do anyways? does it allow the mysql server to connect to the plugin, so changes can be made through mysql, and it will actually save the changes to the plugin?

nahtnam
Step 3 Open your browser and go to http://localhost/phpmyadmin

This is giving me a "page does not exist" message.
1
nahtnam
07/20/2013 10:46 am
Level 18 : Journeyman Modder
Ok, so here are the solutions. First xampp is a software used to automatically setup a php server on your computer for you. It allows a plugin to connect AS LONG AS YOU HOST THE SERVER ON THE SAME COMPUTER! So there are 2 possible reasons phpmyadmin wont work. Check the url. If it says localhost.com or something it wont work. It has to be localhost. Also (forgot to mention in previous post) make sure you have BOTH apache (<--- sorry forgot to tell you) and mysql is running. After that it should work. Also feel free to skype me: nahtnam. I will be on for another 2 hr!
1
TheLibra123
07/20/2013 10:55 am
Level 2 : Apprentice Miner
I just got APACHE before I read your last post lol. APACHE wouldn't run at first, due to a conflict of ports with skype >.> so I had to change those. But it's still not connecting me to that localhost/phpmyadmin! Adding you on skype.
1

Welcome