How do I run 2 MySQL instances on 1 machine.

[alexlawson]

I have followed a lot of different ways to run 2 MySQL instances on 1 machine but they all seem to fail, im using Xampp and need to run it on a port different to 3306.

EDIT:
Just if someone is as silly as me and doesnt understand this is what you need to do.
Just open MySQLworkbench go into the already created connection and simply create a new schema called something other than the first one you created and just change the HiveExt.ini database name.

 

[SchwEde]

if you use Pwnoz0rs Private files just copy the mysql server to you new server folder and edit the my.ini file in it.
After that make the right changes in your hiveext.ini.
Start the new database and your server and this should be done

 

[alexlawson]

if you use Pwnoz0rs Private files just copy the mysql server to you new server folder and edit the my.ini file in it.
After that make the right changes in your hiveext.ini.
Start the new database and your server and this should be done

Someone said that to me yesterday but when I looked into doing it all I found was dayz support and none for epoch.

 

[SchwEde]

it has no epoch table in it, but you can easily add one in it
Just use HeidiSQL for it and the default epoch.sql file

 

[SchwEde]

another way would be just simple add a new table and name it different
dayz_epoch
and
dayz_epoch_1

and then just make your changes in hiveext.ini

 

[alexlawson]

it has no epoch table in it, but you can easily add one in it
Just use HeidiSQL for it and the default epoch.sql file

Ok, but 1 quick question if I run this adding epoch tables and parameters and thats all will it work without me needing to add epoch server files.

 

[alexlawson]

another way would be just simple add a new table and name it different
dayz_epoch
and
dayz_epoch_1

and then just make your changes in hiveext.ini

tried that but I cannot get Xampp to run MySQL on a port other than 3306

 

[alexlawson]

Anyway even if I do that I still need to run MySQL on another port.

 

[SchwEde]

if you have Pwnoz0rs files, then simply edit the my.ini and then run MySQL.bat this will run a new database on the port you have set in the my.ini. Then you can simply login with any MySQL tool in it

 

[alexlawson]

if you have Pwnoz0rs files, then simply edit the my.ini and then run MySQL.bat this will run a new database on the port you have set in the my.ini. Then you can simply login with any MySQL tool in it

Wait, So if I use his server file's I dont need Xampp.

 

[SchwEde]

i'm not using it
Just the mysql folder and HeidiSQL

 

[alexlawson]

i'm not using it
Just the mysql folder and HeidiSQL

OMG I feel like such an idiot, thanks ill try it now.

 

[alexlawson]

It says that I need a password and there is no password set.
Any Ideas?

 

[SchwEde]

User: DayZ
Password: dayz

 

[alexlawson]

User: DayZ
Password: dayz

Yes, thanks

 

[alexlawson]

Now it says this.

Could not connect to MySQL database at localhost: Unknown database 'dayz_epoch_test', retrying in 1 seconds

hiveext.ini settings

[Database]
;Hostname or IP of the server to connect to
;If you leave this line commented or blank, HiveExt will connect to the OFFICIAL Hive, which requires registration
;See support.dayzmod.com for more information on what OFFICIAL Hive means, what are the rules, etc.
;If using OFFICIAL hive, the rest of the settings in this section have no effect
Host = localhost

;Currently, only MySQL is supported
Type = MySQL

;Port to connect to. The default is the default listening port of a server of the selected Type
;Instead of specifying Port, you can specify Socket and set Value to the socket name
Port = 3314

;Database name to connect to.
Database = dayz_epoch_test

;Username to connect with
Username = dayz
;Password to authenticate with (default is blank)
Password = dayz

FIXED: needed to connect to: dayz_epoch not the name dayz_epoch_test

 

[FallingSheep]

xampp multiple instances is possible

first install a second copy of xammp in a different location (eg c:\xampp2)

• Edit your “my.ini” file in c:\xampp2\mysql\bin\
• Change all default 3306 port entries to a new value ie.) 3307
• Change the server value [mysql] to [mysqlvalue]
  

• edit your “php.ini” in c:\xampp2\php
  
• find mysql.default_port port 3306 and set it to what was used in my.ini

tada 2 mysqls runnig on seperate ports

 

[alexlawson]

xampp multiple instances is possible

first install a second copy of xammp in a different location (eg c:\xampp2)

• Edit your “my.ini” file in c:\xampp2\mysql\bin\
• Change all default 3306 port entries to a new value ie.) 3307
• Change the server value [mysql] to [mysqlvalue]

• edit your “php.ini” in c:\xampp2\php
  
• find mysql.default_port port 3306 and set it to what was used in my.ini

tada 2 mysqls runnig on seperate ports

Thanks got working in the end, and has anyone had trouble with the new infistar update with epoch.

 

[Merg]

Wait, So if I use his server file's I dont need Xampp.

Xampp is just a package that installa apache, mysql and a mysql browser. Xampp is really useful for example when creating a website.