Type '\c' to clear the current input statement. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. Commands end with or \g.Ĭopyright (c) 2000, 2016, Oracle and/or its affiliates. ![]() 'ejabberd' (use password defined on GRANT command): mysql -h localhost -u ejabberd -p -D ejabberd You should now be able to connect to 'ejabberd' database with user You can then create a dedicated 'ejabberd' database (use passwordĬreated earlier): echo "CREATE DATABASE ejabberd " | mysql -h localhost -u ejabberd -p 'ejabberd' user (replace password with your desired password): echo "GRANT ALL ON ejabberd.* TO IDENTIFIED BY 'password' " | mysql -h localhost -u root MySQL admins should use that schema and grant right to a dedicated MySQL database creation Create ejabberd user and database You can connect on the database with your created admin password: mysql -uroot -ppassword On Windows you can install MySQL easily like on Linux using Ubuntu Bash: sudo apt-get install mysql-server-5.6Īfter configuration, you can start MySQL with: sudo /etc/init.d/mysql start To connect to your local MySQL server using mysql command-line,Īssuming you kept the default set up, use: mysql -uroot You can manually start server with: rver start You can then follow instruction to finish the installation, forĮxample by running mysql_secure_installation. With homebrew properly installed, you can use the following command to install MySQL: brew install mysql Here is how to get started to help with setup up environment. Example MySQL installation on OSX with homebrewįor testing / development, it is common to start experimenting with You just need to make sure to use MySQL version 5.6 or greater when youĬreate your database. It is also well documented, so it should not be an issue. It is dependent on Linux distributionĪnd system administrators preferences and habits. This documentation will not get into the details of making MySQL Schema to cope with those older MySQL versions. Note: If you do not store message archive in database however, youĬan try using older 5.5 version. MySQL 5.6 or greater to use with ejabberd. RequirementsĮjabberd make use of FULLTEXT indexes with InnoDB. The database does not have to be on the same server than ejabberd. ![]() You need a MySQL server that you can point your ejabberd configuration Passing option -enable-mysql to configure script. You configure ejabberd to include MySQL module. If you are building ejabberd from source, you need to make sure that ejabberd installationĮjabberd packages and binary installers contains all the module needed Using MySQL as backend is thus extremely straightforward. Migrating data from internal database to MySQLĮjabberd is bundled with native Erlang driver to use MySQL as a.Switch modules to use MySQL instead of Mnesia.Configure desired authentication backend.Adding MySQL connection configuration to ejabberd config file.Load database schema into your new database.Example MySQL installation on OSX with homebrew.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |