Arianne

VisualGuideToInstallingStendhalStep2: Difference between revisions

← Older edit
Content deleted Content added
VisualWikitext
imported>Kymara
make clear what is to corrrect a bad step and what is the next stage to follow
imported>Hendrik Brummermann
added navigation menu
 
(48 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>).
::In thiscase you need to:
::*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]]
<br>
Otherwise, you have entered successfully and you should now me welcomed to MySQL.
 
[[File:CreateMariaDB04.png]]
At prompt copy from here:
 
Right-click on the left panel and choose 'Create new -> Database'
create database marauroa;
 
[[File:CreateMariaDB05.png]]
and USE your mouse and right-click anywhere inside the window and choose paste.
 
[[File:CreateMariaDB06.png]]
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB05.png
 
<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''.
Then press <tt>enter</tt>
 
Remember to use the same username and password when [[VisualGuideToInstallingStendhalStep4#ConfigureStendhalServer_EnterUserPassword|configuring and running the Stendhal server at step 4]].
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB06.png
 
[[File:CreateMariaDB07.png]]
Copy again from here:
 
[[File:CreateMariaDB08.png]]
<span id="CreateMySQLDatabase_SetUserPassword"></span>
 
[[File:CreateMariaDB09.png]]
grant all on marauroa.* to stendhal_user@localhost identified by 'stendhal_passwd';
 
[[File:CreateMariaDB10.png]]
and USE your mouse and right-click anywhere inside the window and choose paste. Then press <tt>enter</tt>
 
[[File:CreateMariaDB11.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:CreateMariaDB12.png]]
http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB08.png
 
[[File:CreateMariaDB13.png]]
type ''quit'' or ''exit'' (to quit or exit the command line client :P) or copy from here:
 
quit
 
Go to [[VisualGuideToInstallingStendhalStep4VisualGuideToInstallingStendhalStep3|Step 43. Install stendhalthe Stendhal server]]▼
Then press <tt>enter</tt> and the window will close.
 
 
▲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"