VisualGuideToInstallingStendhalStep1: Difference between revisions

From Arianne
Jump to navigation Jump to search
Content deleted Content added
imported>Oslsachem
imported>Hendrik Brummermann
added navigation menu, removed oversized website screenshots which looks like advertisment
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Navigation for Stendhal Top|Building & Hosting}}

=Step 1. Install and configure MariaDB=
=Step 1. Install and configure MariaDB=
You need a database to manage and store adequately the user accounts and other information.
You need a database to manage and store adequately the user accounts and other information.
Line 5: Line 7:


''MariaDB is a community-developed branch of the MySQL database, the impetus being the community maintenance of its free status under GPL, as opposed to any uncertainty of MySQL license status under its current ownership by Oracle.''
''MariaDB is a community-developed branch of the MySQL database, the impetus being the community maintenance of its free status under GPL, as opposed to any uncertainty of MySQL license status under its current ownership by Oracle.''

''The intent also being to maintain high fidelity with MySQL, ensuring a "drop-in" replacement capability with library binary equivalency and exacting matching with MySQL APIs and commands. It includes the XtraDB storage engine as a replacement for InnoDB.''

''Its lead developer is Monty Widenius, the founder of MySQL and Monty Program AB.''

==Step 1.1. Install MariaDB==


Go to the MariaDB downloads website:
Go to the MariaDB downloads website:
Line 16: Line 12:
http://downloads.askmonty.org/mariadb/
http://downloads.askmonty.org/mariadb/


And download the Windows installer package.

[[File:InstallMariaDB01.png]]

And download the Windows installer package:


[[File:InstallMariaDB02.png]]



Double click on the downloaded file:
Double click on the downloaded file:



[[File:InstallMariaDB03.png]]
[[File:InstallMariaDB03.png]]
Line 35: Line 23:




Choose custom setup to avoid installing unnecessary components which just will take up disk space:
Uncheck items to avoid installing unnecessary components which just will take up disk space:




Line 51: Line 39:


[[File:InstallMariaDB10.png]]
[[File:InstallMariaDB10.png]]

===Step 1.2. Configure MySQL===

Click on <tt>Next</tt>

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure01.png

Choose <tt>Detailed Configuration</tt> and click on <tt>Next</tt>

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure02.png

Choose <tt>Developer Machine</tt> and click on <tt>Next</tt>

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure03.png

Choose <tt>Transactional Database Only</tt> and click on <tt>Next</tt>

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure04.png

Click on <tt>Next</tt>

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure05.png

Choose <tt>Manual Setting</tt> and click on <tt>Next</tt>

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure06.png

It surely could work with less connections but let's be on the safe side...

Check <tt>Enable TCP/IP Networking</tt> and click on <tt>Next</tt>

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure07.png

'''Warning:''' This option is important: always enable TCP/IP networking. Default port 3306 is fine.

Choose <tt>Standard Character Set</tt> and click on <tt>Next</tt>

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure08.png

Check <tt>Install As Windows Service</tt> and <tt>Launch the MySQL Server automatically</tt> and click on <tt>Next</tt>

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure09.png

Note: You can leave <tt>Launch the MySQL Server automatically</tt> unchecked:

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure10.png

and start the service manually every time you restart your computer, so that you don't have it running when you do not need it. This is explained later in [[VisualGuideToInstallingStendhalStep6|Step 6]]. Anyway, after installation and until you reboot your computer the service will be already running in the background even when you choose to start it manually.

Check <tt>Modify Security Settings</tt> and enter the root password in both of the text boxes and click on <tt>Next</tt>

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure11.png

Note: I recommend you simply choosing <tt>root</tt> as root password since only you are going to access the database locally after all... And that way you will not forget the password when you need it at [[VisualGuideToInstallingStendhalStep2|Step 2. Create a MySQL database]]

'''Warning:''' Close your firewall (it will be only for a second) before pressing the <tt>execute</tt> button

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure12.png

Otherwise, you can end with a message like this:

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure13.png

Now do not panic, close your firewall and click on retry.

If you happened to click on skip:

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure14.png

and got this:

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure15.png

*Run the ''MySQL server instance config wizard'' from the MySQL group menu:<br>http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB02.png http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure18.png
*Choose <tt>Remove Instance</tt> and click <tt>Next</tt><br>http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure17.png
*Run the ''MySQL server instance config wizard'' again from the MySQL group menu:<br>http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB02.png http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure18.png
*and repeat [[#Step 1.2. Configure MySQL|Step 1.2]] from the beginning (close your firewall this time before clicking on <tt>execute</tt>)<br>http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure01.png

You can enable your firewall again when you get the <tt>finish</tt> button:

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure16.png




Go to [[VisualGuideToInstallingStendhalStep2|Step 2. Create a MySQL database]]
Go to [[VisualGuideToInstallingStendhalStep2|Step 2. Create a MariaDB database]]


<br>
<br>

Latest revision as of 17:07, 16 February 2012


Step 1. Install and configure MariaDB

You need a database to manage and store adequately the user accounts and other information.

From Wikipedia:

MariaDB is a community-developed branch of the MySQL database, the impetus being the community maintenance of its free status under GPL, as opposed to any uncertainty of MySQL license status under its current ownership by Oracle.

Go to the MariaDB downloads website:

http://downloads.askmonty.org/mariadb/

And download the Windows installer package.

Double click on the downloaded file:


Uncheck items to avoid installing unnecessary components which just will take up disk space:



Write a password for the root user, which will be needed any time you want to directly manage a database. Programs can be set up to remember it, though.



Go to Step 2. Create a MariaDB database





Back to Visual Installation Guide Step-By-Step
Back to stendhal main wiki page