The IOS XMPP protocol implements the server-side configuration of the chat OpenFire (ii)

Tag: Database res connection track DMI exploits Lin Import error

This article is mainly about how to use the command line to properly configure MySQL.

First Open the terminal:

1. An alias for MySQL

Alias Mysql=/usr/local/mysql/bin/mysql

2. Create MySQL admin admin (for late login)

Alias Mysqladmin=/usr/local/mysql/bin/mysqladmin

3. Set the root account password

mysqladmin-u Root Password initial password

4. Connect to the database

Mysql-u root-p (Prompt to enter just password)

5. Create a OpenFire database

Create Database OpenFire;

6. Open the Database

Use OpenFire;

7. Open OpenFire Permissions

sudo chmod 777 /usr/local/openfire

8. Import the data table under openfire Resource directory Resources/database

Source/usr/local/openfire/resources/database/openfire_mysql.sql

9. Refresh Permissions

Flush privileges;

Note: To increase the number of connection errors encountered, just change localhost to 127.0.0.1.

The IOS XMPP protocol implements the server-side configuration of the chat OpenFire (ii)