IOS XMPP Learning-Environment setup (configure MySQL and OpenFire server)

Source: Internet
Author: User
Tags administrator password

1> Installing the database MySQL-Installation MYSQL-5.7.12-OSX10.11-X86_64.DMG-Above this MySQL is a new version, only one main installation program contains all features-in the old version of MySQL will have 3 installed programs *mysql-version number-requires the system version-X86_64.DMG//This is the main installation program *mysql.prefpane//This is System preference management, which is to add MySQL Manager in ' System Preferences ' *mysqlstartupitem.pkg//start MySQL server automatically-Open Terminal sudo vi ~/.bash_profile -Requires data native password-Press ' I ' after entry to enter editable state paste the following text in #mysql alias mysql= '/usr/local/mysql/bin/mysql 'alias mysqladmin= '/usr/local/mysql/bin/mysqladmin '#lsalias ls= ' Ls-g '-Press ESC-Press shift+: Enter Wq (save exit)-The service that requires MySQL is turned off at this time-Close terminal, reopen a terminal-go to MySQL folder-mysql pathcd/usr/local/mysql/bin/sudo su -/mysqld_safe--skip-grant-tables--skip-networking & Exit- mysql-u Root* Change the root password (new version of MySQL replaces the original password field with the Authentication_string field)->update mysql.user SET authentication_string=password (' 123456 ') WHERE user= ' root ';->flush privileges;
    • Try using show databases to see if it's good to make


2> Installing the XMPP server side (OpenFire)-openfire It is based on Java implementation-if you are installing a OpenFire pc you must install the Java JDK-see if the JDK is already installed-in the terminal->java-version-if not Install JDK-Install OpenFire-see if installation succeeds in System Preferences-configure database table-Access/usr/local/directory-in terminal->open/usr/local/-You can see the red logo in the lower-right corner of the OpenFire folder when you open the folder-Right click on the OpenFire folder-Show Introduction-There is a share and permissions at the bottom-click on the small lock in the lower right corner, enter the administrator password to unlock-click the plus sign in the lower left corner to add permissions-Add the entire Administrators group (Administrators), add a close-access to the directory OpenFire, resources, database (here is the script file for the table structure required by OpenFire)-Copy the Openfire_mysql.sql file to the desktop-Install MySQL graphical management tool mysql-workbench-Establish connection-Create a database for OpenFire service-When creating a database, the Schema name:openfire (one name on its own) Default Collation:utf8-utf8_bin-Import the Openfire_mysql.sql script into the OpenFire database and execute-Enter OpenFire in System Preferences, click Open Adminconsole to enter the Web-side admin

IOS XMPP Learning-Environment setup (configure MySQL and OpenFire server)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.