DayZ Private Server Files Pack (1.8.8)

I keep getting a

ERROR 1449 <HY000> at line 1: The user specified as a definer <'root'@'%'> does not exist

Also do I need my own MySQL or does it all come with it and just use that?It seems to but I was not sure if it depends on and outside installation of MySQL as well.
If it all runs in the server sql and all can I run this alongside a stand alone installation of MySQL for my Epoch server and just change the SQL ports?I would also like to know if I can't do that then can I just setup my own MySQL install and link it to that via the hive.ini and just remove the MySQL it seems to come with?As well if I do that is there more than one SQL file I need to import as all I see is the 183.sql.
also should the default password for the MySQL it seems to come with be changed or can it only be accessed locally?
I would also like to ask if the version it seems to come with specially made or modded to work best with DayZ or will the standard MySQL work just as well?(Is there a performance difference from the two?)
If you use navicat (if you don't, get it)

b782cad6d458bea170d5c115a032e9f0.png


FIND PMAIN

ee8cbf21fb0a0aa71ce69e4ca4a07208.png


CHANGE root@% to dayz and click save

f0a96dc43a17923b0efc652434663b3c.png


Save and exit and you're done ^_^
 
it comes with a mysql server. start the server and then find your pmain stored,prodedure and change 'root' to 'dayz' or whatever name you have set up as your login.

alternatively you create a user named 'root' with full permissions on thst database




oops, didnt see sammeh replied already .. GOOD POST ... it should,be a stickie.

except for where you say get navicat :D
navicat is a crippled version of a commercial software, mysqlworkbench is fully funtional and free .. made by oracle
 
it comes with a mysql server. start the server and then find your pmain stored,prodedure and change 'root' to 'dayz' or whatever name you have set up as your login.

alternatively you create a user named 'root' with full permissions on thst database




oops, didnt see sammeh replied already .. GOOD POST ... it should,be a stickie.

except for where you say get navicat :D
navicat is a crippled version of a commercial software, mysqlworkbench is fully funtional and free .. made by oracle
Navicat isn't that bad xD and thanks :D
 
Last edited:
i tried navicat once, i dont recall what i wanted to do but the message popped up that feature was not available in the crippled version.
of course the commercial version is good, i just am not a fan of crippleware when an as good or better alternative is available for free. and since mysqlworkbench is made by the same people who make the mysql server, Oracle, i cant imagine any other software would be more complete.
http://www.mysql.com/products/workbench/
 
Doesn't PwnozOr update the version of the private server pack,like 1.8.6.1?is it the latest?
I want to set up the prviate server(1.8.6.1).And I looked through a website in your a reply to somebody.
There are every version of the server file ,from 1.7.xx to 1.8.6.1(is it released?) But I don't know how to use it.
They are different from the private server files which PwnozOr have announced.The files in that website,including the Client file,and the Server file, and SQL file,and I didn't see the startserver.bat.I used to start the server just only put the PwnozOr private server pack in my root game file.
 
I would also appreciate an update to a more current version or at least a guide how to update properly.

I've tried it several times with several approaches but everything results in "Session lost" (Player xyz without identity) messages.
 
I would also appreciate an update to a more current version or at least a guide how to update properly.

I've tried it several times with several approaches but everything results in "Session lost" (Player xyz without identity) messages.
I would also appreciate an update to a more current version or at least a guide how to update properly.

I've tried it several times with several approaches but everything results in "Session lost" (Player xyz without identity) messages.
Did you have any server pack that the version is more new?
 
Back
Top