VisualGuideToInstallingStendhalStep2: Difference between revisions

From Arianne
Jump to navigation Jump to search
← Older edit
Content deleted Content added
imported>Danter
mNo edit summary
imported>Hendrik Brummermann
added navigation menu
 
(82 intermediate revisions by 4 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:
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 right-click anywhere inside the window and choose paste.
Right-click on the left panel and choose '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]]
grant all on marauroa.* to testuser@localhost identified by 'testpass';


[[File:CreateMariaDB08.png]]
and USE your mouse and right-click anywhere inside the window and choose paste. Then press <tt>enter</tt>


[[File:CreateMariaDB09.png]]
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB07.png


[[File:CreateMariaDB10.png]]
type quit or exit (to quit or exit the command line client :P) or copy from here:


[[File:CreateMariaDB11.png]]
quit


[[File:CreateMariaDB12.png]]
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB08.png


[[File:CreateMariaDB13.png]]
Then press <tt>enter</tt> and the window will close.




Go to [[VisualGuideToInstallingStendhalStep3|Step 3. Install marauroa server]]
Go to [[VisualGuideToInstallingStendhalStep3|Step 3. Install the Stendhal server]]


<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"