VisualGuideToInstallingStendhalStep1: Difference between revisions

From Arianne
Jump to navigation Jump to search
Content deleted Content added
imported>Oslsachem
No edit summary
imported>Hendrik Brummermann
added navigation menu, removed oversized website screenshots which looks like advertisment
 
(66 intermediate revisions by 6 users not shown)
Line 1: Line 1:
{{Navigation for Stendhal Top|Building & Hosting}}
==Step 1. Install and configure MySQL==
You need a database to manage and store adequately the user accounts and other info.


===Step 1.1. Install MySQL===
=Step 1. Install and configure MariaDB=
You need a database to manage and store adequately the user accounts and other information.
Go to the MySQL website and download the easiest and smallest binary installer package (named essential):


From Wikipedia:
[http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-essential-5.0.19-win32.msi/from/pick mysql-essential-5.0.19-win32.msi]


''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.''
Double click on the file


Go to the MariaDB downloads website:
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step11MySQLInstall/Step11MySQLInstall01.png


http://downloads.askmonty.org/mariadb/
Choose <tt>Typical</tt>


And download the Windows installer package.
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step11MySQLInstall/Step11MySQLInstall02.png


Double click on the downloaded file:
Click on <tt>Install</tt>


[[File:InstallMariaDB03.png]]
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step11MySQLInstall/Step11MySQLInstall03.png


[[File:InstallMariaDB04.png]]
Wait


[[File:InstallMariaDB05.png]]
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step11MySQLInstall/Step11MySQLInstall04.png


Choose <tt>skip sign-up</tt> and click on <tt>Next</tt>


Uncheck items to avoid installing unnecessary components which just will take up disk space:
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step11MySQLInstall/Step11MySQLInstall05.png


Click on <tt>Finish</tt>


[[File:InstallMariaDB06.png]]
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step11MySQLInstall/Step11MySQLInstall06.png


===Step 1.2. Configure MySQL===


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.
Click on <tt>Next</tt>


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


[[File:InstallMariaDB07.png]]
Choose <tt>Detailed Configuration</tt> and click on <tt>Next</tt>


[[File:InstallMariaDB08.png]]
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure02.png


[[File:InstallMariaDB09.png]]
Choose <tt>Developer Machine</tt> and click on <tt>Next</tt>


[[File:InstallMariaDB10.png]]
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>


Go to [[VisualGuideToInstallingStendhalStep2|Step 2. Create a MariaDB database]]
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure04.png


<br>
Click on <tt>Next</tt>
<br>

<br>
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure05.png
----

[[VisualGuideInstallingStendhal|Back to Visual Installation Guide Step-By-Step]]<br>
Choose <tt>Manual Setting</tt> and click on <tt>Next</tt>
[[Stendhal | Back to stendhal main wiki page]]

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 [[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]]

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