Arianne

VisualGuideToInstallingStendhalStep2: Difference between revisions

← Older edit
Content deleted Content added
VisualWikitext
imported>Oslsachem
m relocated the same anchor link again :)
imported>Hendrik Brummermann
added navigation menu
 
(69 intermediate revisions by 3 users not shown)
Line 1:
{{Navigation for Stendhal Top|Building & Hosting}}
==Step 2. Create a MySQL database==▼
 
▲==Step 2. Create a MySQLMariaDB database==
Start MySQL command line client:
 
Start HeidiSQL:
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB02.png
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB03.png
 
[[File:CreateMariaDB01.png]]
at <tt>Enter password</tt>: prompt, enter root password chosen at the previous step (root if you have followed indications)
 
[[File:CreateMariaDB02.png]]
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB04.png
 
In the 'Password' field, enter the root password chosen at [[VisualGuideToInstallingStendhalStep1#Step_1._Install_and_configure_MariaDB|install and configure MariaDB]]
Note: if MySQL client closes before or after entering root password at <tt>Enter password:</tt> prompt that can mean three things:
*That MySQL service is not running in the background. Go to services and start it as explained in [[VisualGuideToInstallingStendhalStep6|Step 6]].
*That you entered a bad root password. Run the client again and type it right.
*That you have not set a root account successfully (type just <tt>enter</tt> to test and it should prompt you with <tt>mysql></tt>).
**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 [[VisualGuideToInstallingStendhalStep1#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
 
[[File:CreateMariaDB03.png]]
At prompt, copy from here:
 
[[File:CreateMariaDB04.png]]
create database marauroa;
 
and USE your mouse and rightRight-click anywhere insideon the windowleft panel and choose paste.'Create new -> Database'
 
[[File:CreateMariaDB05.png]]
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB05.png
 
[[File:CreateMariaDB06.png]]
Then press <tt>enter</tt>
 
<span id="CreateMariaDBDatabase_SetUserPassword"></span>Now total access to the database named ''marauroa'' is granted to the user named ''Stendhal'' (which will be actually our local Stendhal game server) with some random password ''abc123''.
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB06.png
 
Remember to use the same username and password when [[VisualGuideToInstallingStendhalStep4#ConfigureStendhalServer_EnterUserPassword|configuring and running the Stendhal server at step 4]].
Copy again from here:
 
[[File:CreateMariaDB07.png]]
<span id="CreateMySQLDatabase_SetUserPassword"></span>
 
[[File:CreateMariaDB08.png]]
grant all on marauroa.* to stendhal_user@localhost identified by 'stendhal_passwd';
 
[[File:CreateMariaDB09.png]]
and USE your mouse and right-click anywhere inside the window and choose paste. Then press <tt>enter</tt>
 
[[File:CreateMariaDB10.png]]
'''Note:''' With the previous statement you are granting total access to the database named ''marauroa'' to the user named ''stendhal_user'' with the password ''stendhal_passwd''. Remember to use this same username and password when [[VisualGuideToInstallingStendhalStep4#ConfigureMarauroa_EnterUserPassword|configuring marauroa at step 4]].
 
[[File:CreateMariaDB11.png]]
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB08.png
 
[[File:CreateMariaDB12.png]]
type ''quit'' or ''exit'' (to quit or exit the command line client :P) or copy from here:
 
[[File:CreateMariaDB13.png]]
quit
 
Then press <tt>enter</tt> and the window will close.
 
Go to [[VisualGuideToInstallingStendhalStep3|Step 3. Install marauroathe Stendhal server]]▼
 
▲Go to [[VisualGuideToInstallingStendhalStep3|Step 3. Install marauroa server]]
 
<br>
Retrieved from "https://meet.konsthol.eu/w/index.php?title=VisualGuideToInstallingStendhalStep2"