VisualGuideToInstallingStendhalStep1: Difference between revisions

Content deleted Content added
imported>Oslsachem
No edit summary
imported>Hendrik Brummermann
added navigation menu, removed oversized website screenshots which looks like advertisment
 
(84 intermediate revisions by 6 users not shown)
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==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]]