VisualGuideToInstallingStendhalStep2: Difference between revisions

← Older edit

Content deleted Content added

VisualWikitext

Revision as of 23:27, 26 March 2006 view source imported>Oslsachem No edit summary ← Older edit		Latest revision as of 17:07, 16 February 2012 view source imported>Hendrik Brummermann added navigation menu
(130 intermediate revisions by 4 users not shown)
Line 1: {{Navigation for Stendhal Top\|Building & Hosting}} ==Step 2. Create a MySQL database==▼ ▲==Step 2. Create a ~~MySQL~~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 [[#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~~Right-click ~~anywhere inside~~on the ~~window~~left panel and choose ~~paste.~~'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 ~~marauroa~~the Stendhal server]] <br> <br> <br> ---- [[VisualGuideInstallingStendhal\|Back to Visual Installation Guide Step-By-Step]]<br> [[Stendhal \| Back to stendhal main wiki page]]