Editing Eng:J2J:AdminGuide
From JaWiki (Jabber/XMPP wiki)
Warning: The database has been locked for maintenance, so you will not be able to save your edits right now. You may wish to copy and paste your text into a text file and save it for later.
The administrator who locked it offered this explanation: MediaWiki upgrading
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 31: | Line 31: | ||
createdb j2j | createdb j2j | ||
* mysql | * mysql | ||
− | mysql -h localhost | + | mysql -h localhost -p |
+ | >CREATE DATABASE j2j; | ||
Let's create a DB user: | Let's create a DB user: | ||
Line 38: | Line 39: | ||
A -P key means, that user is created with a password-prompt. Store it, because it will be needed for next steps. Same with yourpassword in mysql: | A -P key means, that user is created with a password-prompt. Store it, because it will be needed for next steps. Same with yourpassword in mysql: | ||
* mysql: | * mysql: | ||
− | mysql -h localhost | + | mysql -h localhost -p |
+ | >GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON j2j.* TO 'j2j'@'localhost' IDENTIFIED BY 'yourpassword'; | ||
And import a database structure: | And import a database structure: | ||
Line 45: | Line 47: | ||
\i pgsql.schema | \i pgsql.schema | ||
* mysql | * mysql | ||
− | mysql -h localhost | + | mysql -h localhost -p |
+ | >use j2j | ||
+ | >\. mysql.schema | ||
=== Gateway configuration === | === Gateway configuration === |