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)
