Arianne

VisualGuideToInstallingStendhalStep2: Difference between revisions

← Older edit
Content deleted Content added
VisualWikitext
imported>Kymara
add missing images
imported>Hendrik Brummermann
added navigation menu
 
(42 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:
[[Image:Step2MySQLCreateDB02.png]]
[[Image: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)
[[Image:Step2MySQLCreateDB04.png]]
 
[[File:CreateMariaDB02.png]]
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>).
::In thiscase you need to:
::*Run the ''MySQL server instance config wizard'' from the MySQL group menu:<br>[[Image:Step2MySQLCreateDB02.png]][[Image:Step12MySQLConfigure18.png]]
::*Choose <tt>Remove Instance</tt> and click <tt>Next</tt><br>[[Image:Step12MySQLConfigure17.png]]
::*Run the ''MySQL server instance config wizard'' again from the MySQL group menu:<br>[[Image:Step2MySQLCreateDB02.png]][[Image: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>[[Image:Step12MySQLConfigure01.png]]
 
In the 'Password' field, enter the root password chosen at [[VisualGuideToInstallingStendhalStep1#Step_1._Install_and_configure_MariaDB|install and configure MariaDB]]
<br>
Otherwise, you have entered successfully and you should now me welcomed to MySQL.
 
[[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'
 
[[ImageFile:Step2MySQLCreateDB05CreateMariaDB05.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''.
[[Image: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]].
 
[[Step2MySQLCreateDB08File:CreateMariaDB11.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 [[VisualGuideToInstallingStendhalStep4VisualGuideToInstallingStendhalStep3|Step 43. Install stendhalthe Stendhal server]]▼
 
▲Go to [[VisualGuideToInstallingStendhalStep4|Step 4. Install stendhal server]]
 
<small>Step 3 is no longer needed - one used to install marauroa there, but now marauroa is included as a pre built jar in the stendhal server distribution.)</small>
 
<br>
Retrieved from "https://meet.konsthol.eu/w/index.php?title=VisualGuideToInstallingStendhalStep2"