Posted on 23rd Sep 2018 03:58:47 in Database
MySQL cheat sheet provides you with the most commonly used MySQL commands and statements that help you work with MySQL more effectively.
Posted on 23rd Sep 2018 03:41:47 in Database
The MySQL root password allows the root user to have full access to the MySQL database. You must have (Linux) root or (Windows) Administrator access to the Cloud Server to reset the MySQL root password.
Note: The Cloud Server (Linux) root or (Windows) Administrator account password is not the same as the MySQL password. The Cloud Server password allows access to the server. The MySQL root password allows access only to the MySQL database
Use the following steps to reset a MySQL root password by using the command line interface.
Posted on 23rd Sep 2018 03:29:08 in XMPP
Although ejabberd has its default database called Mnesia but when you want to access this database,you have to learn this new database.so if you have used sql database earlier then it will be easy for you to use mysql with ejabberd.
For using Mnesia database,you do not need to do anything it comes by default with ejabberd installation but if you want use mysql instead of Mnesia then you need to enable it at the time of ejabberd installation and after installation you have to configure mysql in the configuration file of ejabberd called "ejabberd.yml".
so we are going to give a step by step guide to make ejabberd working with mysql.