VisualGuideToInstallingStendhalStep2: Difference between revisions

From Arianne
Jump to navigation Jump to search
← Older edit
Content deleted Content added
imported>Kymara
add missing images
imported>Hendrik Brummermann
added navigation menu
 
(37 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{Navigation for Stendhal Top|Building & Hosting}}
⚫
==Step 2. Create a MySQL database==


⚫
==Step 2. Create a MariaDB 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 right-click anywhere inside the window and choose paste.
Right-click on the left panel and choose 'Create new -> Database'


[[Image:Step2MySQLCreateDB05.png]]
[[File:CreateMariaDB05.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]].


[[Step2MySQLCreateDB08.png]]
[[File: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 [[VisualGuideToInstallingStendhalStep3|Step 3. Install the 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>
<br>

Latest revision as of 17:07, 16 February 2012


Step 2. Create a MariaDB database

Start HeidiSQL:

In the 'Password' field, enter the root password chosen at install and configure MariaDB

Right-click on the left panel and choose 'Create new -> Database'

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.

Remember to use the same username and password when configuring and running the Stendhal server at step 4.


Go to Step 3. Install the Stendhal server




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

Retrieved from "https://meet.konsthol.eu/w/index.php?title=VisualGuideToInstallingStendhalStep2&oldid=107221"