MySQL How to Setup a MySQL Database (with photos)

[LordXavy]

Everything is acting correctly.

 

[Krahl]

Ive did EXACTLY as in the tutorial but even i cant get on the localhost (http://localhost) Please help me and sorry for bad English.

 

[robbie]

It says "Temple position is rong please contact administrator" wat do i do ??

 

[7136605]

Hey. i got 1 question.. why do ppl play this game?? i got a own wow server.. fisrt i had xml 8.0 tibia now 3.1.2 wow patch server :S

 

[Arrexano]

Great job! but im stick at the fourth step!!
How do i put in this codes in MySQL part!? I can't write in the file i don't know why.
Please answer fast cuz i rly need this! Thank you for all good information mate!

 

[Vaynne]

Just wanted to say thanks a lot for all this information and indeed, the server and map setup. got the server up and running but I get a connection refused error when trying to enter the account maker.

My IP has been changed to 127.0.0.1 and as far as i know, i have followed each step carefully. Anyone have any ideas? It all seems to be working except that I cannot connect.

Thanks again for all this and thanks in advance for any reply.

 

[Eternal Legend]

Thank you soooo much dude ive been trying to do this forever now i finaaly understand the whole thing! THanks bro!!

 

[Dante]

I dont know whats the problem is but in xampp control panel
the first one wont run, only the second one

 

[Cykotitan]

I dont know whats the problem is but in xampp control panel
the first one wont run, only the second one

run /xampp/xampp-portcheck.exe

skype usually uses port 80

 

[Dante]

run /xampp/xampp-portcheck.exe

skype usually uses port 80

My brother said that i need to shutdown skype but i dunno i need it open.

 

[Cykotitan]

You can run Apache on port 8080 if you want to keep Skype open.

/xampp/apache/conf/httpd.conf, change:

Listen 80

To:

Listen 8080

If you want to access localhost now, you'll have to use http://localhost:8080/ or http://127.0.0.1:8080/

 

[Dante]

You can run Apache on port 8080 if you want to keep Skype open.

/xampp/apache/conf/httpd.conf, change:

Listen 80

To:

Listen 8080

If you want to access localhost now, you'll have to use http://localhost:8080/ or http://127.0.0.1:8080/

Ah ok thanks, but got one more question, now im on this "import the db thing to localhost"

on frakfarmers rl map, the new one, there is two db things and i tested both of them but nothing happens :S

This is really diffrent, last time i did a sql thing was when these photos was created.

 

[Cykotitan]

1. ​
2. ​
3. ​
4. ​

​

 

[Dante]

1. ​
2. ​
3. ​
4. ​

​

O my gosh! D

Thanks bro <3


-.-

"You must spread some Reputation around before giving it to Cykotitan again"

 

[meliis]

ive done everything !
when i click on my database all things comes upp like
accounts, accountsviplist, bans ....
BUT when i klick on SQL it says :

Fel
SQL-fråga:

SELECT label, id
FROM `phpmyadmin`.`pma_bookmark`
WHERE dbase = 'noobwar'
AND (

user = 'root'
OR user = ''
)
ORDER BY label
MySQL sa:

#1142 - SELECT command denied to user ''@'localhost' for table 'pma_bookmark'

 

[Influential]

Alright i have 2 problems.

1. The Apache in Xampp wont Load Apache, it asks for me administration, so i allow that, then it never loads
2. The Localhost wont ever let me go their, i get to the link above for localhost 8080, and it sends me to a japanese Website, so can you guy's please help me out and maybe i can use Teamviewer for help on how to make one

Thanks

 

[cmarofpicka]

see this on STEP 4 i have this error

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'world_id' in 'field list'' in C:\Program Files\xampp legend\htdocs\install.php:515 Stack trace: #0 C:\Program Files\xampp legend\htdocs\install.php(515): PDO->query('INSERT INTO `pl...') #1 {main} thrown in C:\Program Files\xampp legend\htdocs\install.php on line 515

on step 5 i have this error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'' in C:\Program Files\xampp legend\htdocs\pot\OTS_Account.php:228 Stack trace: #0 C:\Program Files\xampp legend\htdocs\pot\OTS_Account.php(228): PDO->query('SELECT `id`, `n...') #1 C:\Program Files\xampp legend\htdocs\install.php(572): OTS_Account->load(1) #2 {main} thrown in C:\Program Files\xampp legend\htdocs\pot\OTS_Account.php on line 228

can sombody help me thx

 

[cont4iner123]

Old post but still helped me out tons!
Thank you so much!