VisualGuideToInstallingStendhalStep2: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
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 |
||
| (41 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
{{Navigation for Stendhal Top|Building & Hosting}} |
|||
| ⚫ | |||
| ⚫ | |||
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 |
|||
| ⚫ | |||
Then press <tt>enter</tt> and the window will close. |
|||
| ⚫ | |||
<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