MySQL How to setup a MySQL Database (screenshots included) - Last update: 16/7/2009

[Muhmo]

localhost :S

when i open localhost/phpmyadmin i cant login :S it comes some text about Can not create connection: invalid settings
i can send a picture on messenger if u add [email protected]
please help me! i have made this once before and i could login then... but now i cant :S

 

[Strashni]

Did u start Apache and MySql??

 

[Kurorow]

Hello man, when I try Import schema.mysql....


SQL query:

DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` NOT IN ( 1, 2 ) AND `value` = OLD.`id` ;



MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR ' at line 1



Help me please :/

 

[CorruptEnzo]

Great guide man, i hope it works.

peace

 

[Mattt]

Nice tutorial

 

[Delirium]

Thank you

 

[Matti96]

i need help when i want to start apache it says:

ERROR: Apache service not started [-1]

 

[Delirium]

i need help when i want to start apache it says:

Run Apache through Xampp control panel then.

 

[Matti96]

Quote:
Originally Posted by Matti96 View Post
i need help when i want to start apache it says:
ERROR: Apache service not started [-1]
Originally Posted by KuGaSh1ra
Run Apache through Xampp control panel then.

it says agaian
ERROR: Apache service not started [-1]

 

[Noobish123]

when i import forgottenserver.s3db it doesnt work... it comes up some red text which i dont understand... what is wrong?

someone please help me!

 

[Delirium]

it says agaian
ERROR: Apache service not started [-1]

It might be an error due to a closed port. Try opening port 80 on firewall (both udp and tcp). Else reinstall xampp.

when i import forgottenserver.s3db it doesnt work... it comes up some red text which i dont understand... what is wrong?

someone please help me!

forgottenserver.s3db is an SQLite file

 

[Zakatan]

I have done everything you told me to in this tutorial but I don't get same version of Xampp and when I install it I don't get the window u said should come and so on, I can't even start Apache or something :s
Can you PM me and help me better or link to a better Xampp?

 

[skitzo]

The Error [1] or [-1] is because your using Vista and or Windows 7 Beta... Try moving xampp control to desktop, then running as admin works for me, I had the same problem Although im having another problem if anyone has the solution...



Error
SQL query:

DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` NOT IN ( 1, 2 ) AND `value` = OLD.`id` ;



MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
' at line 1


Thanks in advance..

@UP i hope this helps

 

[dave182]

kuga... I've searching for tutorials, this is great, but EVERY TUTORIAL I READ JUST EXPLAINS HOW TO SETUP AN ACC MAKER FOR "TFS", MY SERVER IS SQL, BUT IT DOESN'T HAVE A "database", I'M TRYING TO MAKE AN ACC MAKER FOR WODBO (World of Dragon Ball Online), BUT I JUST CAN'T, BECAUSE IT IS "MySql" BUT DOESN'T HAVE A DATABASE :S... PELASE HELP D:

 

[Lording]

when i go to localhost:

Works.

This appear.. any1 know why?

 

[Zakatan]

 

[knatteengels]

Why My MySQL Port Stop Always ?? help..

 

[knatteengels]

Fel
SQL-fråga:

CREATE TABLE `house_data` (

`house_id` INT UNSIGNED NOT NULL ,
`world_id` TINYINT( 2 ) UNSIGNED NOT NULL DEFAULT 0,
`data` LONGBLOB NOT NULL ,
UNIQUE (
`house_id` ,
`world_id`
)) ENGINE = InnoDB;



MySQL sa:

#1050 - Table 'house_data' already exists

WHY?

 

[Hellrage]

Would this tutorial work with Avesta 7.6?

 

[pskonejott]

i get the error "unable to load items"
help please?