[HELP] MySQL

[..:D&G:..]

Sorry for soo many questions. If I am annoying I am verry sorry, but I need help.

So, I have a server, RPG, and I need a MySQL database for it.

I have XAMPP, NAVICAT, and the Command Line, but I get some errors and I don't know how to solve them. I tried the many forums, and the apache forum, but I connot find a answer that explains clearly how to make a database from A to Z, or how to fix the errors, so if someone knows how to make it please tell me or you if you want to help me set it up from 0.

[myonlake]

Installation of XAMPP (normal installation)

1. Download XAMPP (installer: http://sourceforge.net/projects/xampp/f ... 5/download | extract-able: http://sourceforge.net/projects/xampp/f ... 5/download). Only download either the installer or the extract-able. Installer is user-friendly, but the extract-able shouldn't make any errors and also allows you to install it as a non-administrator user.

2. Install XAMPP.

2.1. If you are using the installer, just follow the instructions that comes with the installer.

2.2. If you are using the extract-able, place the extracted xampp -folder in your C-drive at C:\.

3. Run the setup_xampp.bat -file for complete installation of the services.

4. Start the control panel via the xampp -folder.

4.1. It is suggested to put up a shortcut to the control panel on your desktop for easier start-up in the future.

5. Start the Apache -service and the MySQL -service

Question: Apache -service starts and stops, why?

Answer: If you are running Skype, bring it up. Go to the settings panel, open up the additional settings panel, go to the connection section, untick the Alternatively use port 80.. or so, and if the above box has numbers 80 on it, switch it over to 2891. Additionally you could stop all other programs that you do not use, they might be using the port number 80 and that means you can't run Apache.

6. Open your web browser and go to: http://localhost/.

7. Choose your language (English is recommended).

8. Go to the security section.

9. Set the usernames and passwords, make sure they are not too simple.

10. Go over to http://localhost/phpmyadmin.

11. Log in with the credentials you set before.

12. Create a database with a name, you could use "rp" for it, for example.

13. Select the database from the list and press "Import" from the upper panel.

14. Find the database from your paradise -folder, somewhere.

15. Import the database and it should put in all the tables.

16. Stop Apache and leave your web browser.

---

Doesn't work? I'd give up.

[..:D&G:..]

I have xampp instaled, it works fine, apache runs as it needs to ,but when I try to go on http://localhost it doesn't work.

#1130 - Host '82.**.**.**' is not allowed to connect to this MySQL server 
Connection for controluser as defined in your configuration failed. 

PS: I won't show my IP..

[myonlake]

Well, it seems like you have blocked that IP-address or the server accepts only localhost connections.

Have you already set up your MySQL username and password? Also, does that error occur in the phpMyAdmin page?

Is that your own computer or are you using a VPS?

Because if you're using it on your own computer, make sure to connect via http://127.0.0.1/ or http://localhost/ instead of your whole real IP-address.

I just suggest you re-install XAMPP with the tutorial I posted you above in order to flush everything out.

[..:D&G:..]

Yes, its my own computer, and I've used http://localhost, and I also setted up a username when I instaled mysql. I tried to re-install xampp but still no luck.

-------EDITED-------

Solved it! But I don't have any good gamemode, and I don't know scripting that much, and you also stoped working on your gamemode Thanks for your help!