Trouble Setting up Database

[rosska85]

Hi there, I've managed to upload the server files to my server but I can't get the database setup correctly.

I've tried simply using the 'import' option and uploading your .sql file from the server files zip but each time I'm met with this.

SQL query:
 
DELIMITER ; ;
 
CREATE DEFINER =  `dayz_hg`@`localhost` FUNCTION  `rndspawn` (
 
`chance` DOUBLE
) RETURNS TINYINT( 1 ) BEGIN DECLARE bspawn TINYINT( 1 ) DEFAULT 0;
 
IF( RAND( ) <= chance ) THEN SET bspawn =1;
 
END IF ;
 
RETURN bspawn;
 
END ; ;
 
MySQL said: Documentation
 
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Any help would be appreciated.

 

[rosska85]

Schoolboy error, that copy paste came from my first attempt before changing the 'user'@'localhost'. I'm still getting the error with the correct user replaced throughout the file.