VisualGuideToInstallingStendhalStep2

Step 2. Create a MySQL database

Start MySQL command line client:

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB02.png http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB03.png

at Enter password: prompt, enter root password chosen at the previous step (root if you have followed indications)

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB04.png

Note: if MySQL client closes before or after entering root password at Enter password: prompt that can mean three things:

• That MySQL service is not running in the background. Go to services and start it as explained in 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 enter to test and it should prompt you with mysql>).
  • Run the MySQL server instance config wizard from the MySQL group menu:
    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 Remove Instance and click Next
    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:
    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 from the beginning (close your firewall this time before clicking on execute)
    http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step1MySQLInstallConfigure/Step12MySQLConfigure/Step12MySQLConfigure01.png

At prompt, copy from here:

 create database marauroa;

and USE your mouse and right-click anywhere inside the window and choose paste.

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB05.png

Then press enter

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB06.png

Copy again from here:

 grant all on marauroa.* to stendhal_user@localhost identified by 'stendhal_passwd';

and USE your mouse and right-click anywhere inside the window and choose paste. Then press enter

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 configuring marauroa at step 4.

http://arianne.sourceforge.net/wiki_images/visual_guide_server/Step2MySQLCreateDB/Step2MySQLCreateDB08.png

type quit or exit (to quit or exit the command line client :P) or copy from here:

 quit

Then press enter and the window will close.

Go to Step 3. Install marauroa server

---

Back to Visual Installation Guide Step-By-Step
Back to stendhal main wiki page