MySQL How to setup MySQL (Answers for the normal errors too) Photos now!

[Woso]

What if they want to access their PHPMyAdmin somewhere?

Please don't post in my thread to raise your post count if you don't have anything to say or need help. :ninja:

I heard it would be safer to keep the port closed.

So what he is saying is just make everything safer.
If it now gets safer.

 

[Nikkster]

I heard it would be safer to keep the port closed.

So what he is saying is just make everything safer.
If it now gets safer.

The latest XAMPP version is nuf safe.

 

[Nikkster]

The tutorial has been re-written. I would like to thank you for your patience and if you would need any help, just post in this thread.

 

[danzigz]

Hey guys. So I set everything up with no errors. xampp and all is running smoothly. newest version of TFS is uploaded with no database errors. only thing left to do is login, which I cant. Cannot connect to login server Connection refused is what I get after I try to get into acct manager with 1/1. all my ports that need to be open are open and I tried using my IP which I used in the whole setup, to login with tibialoader. I also used the loopback to try to login. nothing works. friends on my LAN also tried to login and they could not

any thoughts?

 

[Neferet]

Hey Im kinda over my head here. I wanted to use a server so I can see what my maps look like on the big screen. I downloaded xampp and set it up but when i try to go to http://localhost/security/xamppsecurity.php it says on the web page unable to connect? What am i doing wrong? My ports are open so thats not the problem.

 

[sorcerers king]

Nice

 

[Swiff]

I hate myself for being so retarded. I can't even follow a good tutorial? It pisses me off so much.

"If you use Windows, please go to this link and choose the .exe or the .zip download:
apache friends - xampp for windows

If you use Linux, please go to this link and choose the .exe or the .zip download:
apache friends - xampp for linux


Then you install it.(I guess if I didn't download the .exe file, but the .zip file I should to the following If you downloaded the Zip files, extract them to the HTDOCS folder which is located inside the XAMPP folder.(wait, what did I miss? I have no Xampp folder yet, I thought that was what I was about to do...)"

I must be totally retarded, because I've tried to follow so many tutorials and always end up stuck on something like this. Well, ofcourse I didn't give up and got it working after some time. now 2nd error:

Error
SQL query:

DROP TRIGGER IF EXISTS `oncreate_players` ;



MySQL said:

#1046 - No database selected

This happend when I did the "import" step.


update: I just randomly tried to import my database, however at one point it didn't give me any error, nor any comfirmation. I didn't notice any new databses either, just the "MySql" one that has 40-50~entries, so I tried to redirect my server to that database. and I had 1001 pages of errors in my console when I tried to run it. Well, I guess I'm just too much noob.

 

[Strata]

hey im having a problem with the links for the webpages your spost to go to can someone help me ? msn- [email protected] aim- alexandorrr

 

[Tickit]

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

What to do? ;s

 

[Nikkster]

It's time to bump up the thread a little.

 

[lizudus]

The connection to controluser, as defined in your configuration failed. << WHAT HAPPENED?

 

[Nikkster]

The connection to controluser, as defined in your configuration failed. << WHAT HAPPENED?

Please give me more details.

Bump

 

[legendxd]

i got this

http://img843.imageshack.us/img843/1985/errornr.png


and

http://img219.imageshack.us/img219/258/error2v.png

solved

 

[Tibiafreaker]

can someone help me to portforward port 80 and 7172?

 

[Tibianerd]

could not estabilish connection to SQL database.. >_>

 

[Korrex]

Try restarting mysql , or check config .lua

 

[Runawayx100]

Error
SQL query:

DROP TABLE IF EXISTS `houses` ;


MySQL said:

#1217 - Cannot delete or update a parent row: a foreign key constraint fails





What does this mean, help?

 

[Runawayx100]

error

I have the same problem :/

 

[Runawayx100]

could not estabilish connection to SQL database.. >_>

same problem :/

 

[Tibianerd]

i cant login to my acc manager, why? :S i've done everything right, and i could login to it before, my friend too. but now nothings work, its says disconnected?