VisualGuideToInstallingStendhalStep2: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Danter mNo edit summary |
imported>Hendrik Brummermann added navigation menu |
||
| (86 intermediate revisions by 4 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>). |
|||
**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; |
|||
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 stendhal_user@localhost identified by 'stendhal_passwd'; |
|||
[[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 |
Go to [[VisualGuideToInstallingStendhalStep3|Step 3. Install the Stendhal server]] |
||
<br> |
<br> |
||