Database Archives

How to switch the Mysql authentication method from auth_socket to mysql_native_password

Author - Webner
|
0 Comments
|

In this article, we will come to know how we can switch the MySQL root user default (Auth_Socket) authentication method to mysql_native_password.

Auth_socket Authentication

Auth_socket authentication is a server-side default authentication plugin that is used to authenticate the client input in order to access databases. Auth_Socket authentication Read more…

Keyring Password Issue

Author - Webner
|
0 Comments
|

Use this if you have forgotten the password of the keyring in Ubuntu, but you want to safeguard a new keyring with a password.

For Ubuntu 18.04, I used the following.
Remove old keyring: For this, we need to change the directory to keyring location Read more…

How to exclude source when Syncing or Converting – DX

Author - Webner
|
0 Comments
|

While Syncing the metadata files between your local system and a target/Scratch org, you often want to exclude some of the source files. Similarly, you often have files to exclude when converting the source to the Salesforce DX project format. In both the above-said cases, you can exclude Read more…

How to export database schema with data in Microsoft SQL Server Management Studio

Author - Webner
|
0 Comments
|

Problem: When we use Microsoft SQL Server Management Studio to export the database, by default it will export the database schema only. When I was trying to export the database to import it into my other local machine, I faced this issue. I selected to export Read more…

Advantages of Azure SQL Database

Author - Webner
|
0 Comments
|

Azure SQL Database is a relational database provided as Database-as-a-Service, which is a part of Microsoft’s Cloud Infrastructure Platform, Microsoft Azure. It is also called SQL Azure. It provides database-backed managed service in the cloud with a petabyte-scale infrastructure. It is based Read more…

Salesforce CRM Features

Author - Webner
|
0 Comments
|

Growing your business isn’t simple. It needs boosting sales however it’s not simply selling the services or products to prospective and prevailing customers. A business is a scientific and economical method of collecting leads so they will be born-again to loyal customers and sales.

What does Read more…

Install Openssl with source code

Author - Webner
|
0 Comments
|

To install Openssl, we have to perform all steps with the root user. Please check the steps below:

sudo su (Do all operation with root user)
Change the directory to your desire location
cd /var/www/html/
Make two directories
mkdir Release
mkdir Sources
Go to the Sources folder and Read more…

Security token in Salesforce

Author - Webner
|
0 Comments
|

How to generate an access token?

Step 1: From Setup, enter Apps in the Quick Find box, then select App Manager.
Step 2: Locate the OAuth connected app in the apps list, click and select View.
Step 3: In the Initial Access Read more…

Azure Event Hubs

Author - Webner
|
0 Comments
|

Introduction:

Event Hubs is a real-time data ingestion service that is fully managed, simple, scalable, and trusted. It can stream, process, and receive millions of events per second from any of the sources, which builds data pipelines that are dynamic in nature. These pipelines are favourable to Read more…

Mysql | #1553 – Cannot drop Index

Author - Webner
|
0 Comments
|

Issue:

#1553 – Cannot drop index ‘index_name’: needed in a foreign key constraint

An issue is generally faced when we are going to drop a unique index from a table. For example, here I have the table articles that have the following structure:

Column
Data type
Specifications

id
int Read more…

How to Run Multiple versions of MySQL on the Same Server?

Author - Webner
|
0 Comments
|

Solution:
If your system is having a current version of MySQL installed i.e 5.6 and you also need 5.5 version then follow the below steps.
You can also play with different versions also.

Installing Docker

To install Docker on your machine Read more…

How do you convert ACLs of any key on S3?

Author - Webner
|
0 Comments
|

Introduction to ACLs of Key on S3

Many times when you need to change the access control list (ACL) of a key on the S3 to make it public to private or private to public. This is easy as we provide this control at the time when we Read more…

Firebase Cloud Messaging With Laravel 6

Author - Webner
|
1 Comment
|

Introduction to Firebase Cloud

Earlier known as Google Cloud Messaging and now called Firebase Cloud Messaging (FCM) is a messaging solution for cross-platform provided by Google itself. This service lets you reliably deliver messages or notifications at no cost. One can use FCM for sending push notification Read more…

Firebase Integration With Laravel 6.x (Ubuntu 18.04)

Author - Webner
|
0 Comments
|

Below are the steps to integrate Firebase with Laravel 6.x

Step 1

To integrate Firebase with Laravel we first need a Laravel project. Create a new Laravel project using the given composer command.

composer create-project –prefer-dist laravel/laravel firebase

Step 2

Read more…

Advanced SQL – Indexes and Triggers

Author - Webner
|
0 Comments
|

Introduction

The SQL database provides a lot of commands and functions. With the help of them, we can manage a huge amount of data easily in the database. Following are some of the examples:

INDEX:

In the SQL database Index is like a schema object. It Read more…

MySQL: only_full_group_by issue on joins

Author - Ishpreet Kaur
|
0 Comments
|

Issue

#1055 – Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column xxxx which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

After upgrading ubuntu 14.04 to 18.04 and MySQL 5.5 to Read more…

PHP: mysqli_multi_query stops the execution of further MySQL queries.

Author - Ishpreet Kaur
|
0 Comments
|

The mysqli_query statement

Generally, we use mysqli_query to execute Mysql queries in PHP. We can use multiple mysqli_query statements to execute multiple operations like insert, update, and select. Sometimes, we store records in more than one table during save operation at the backend, but it is Read more…

MongoDB Driver Not Found

Author - Manoj Thakur
|
0 Comments
|

Problem – Getting “Class ‘MongoDB\Driver\Manager’ not found” error while inserting some data in the collection (Laravel)

Check the following three points in order to resolve the MongoDB driver issue in Laravel:
1. PHP Module
2. MongoDB Extension
3. MongoDB Library
1. PHP Module –Read more…

Migrate MySql to MariaDB in Ubuntu 18.04

Author - Manoj Thakur
|
1 Comment
|

How to Migrate MySql to MariaDB in Ubuntu 18.04

We need to perform few steps to migrate the MySql database to Maria database, I have mentioned the steps below:

Log in to your MySql server with root password.

$ mysql -u root -p

mysql> show Read more…

How to Detect Mobile devices in php

Author - Gopi Garg

Detect mobile device php code

We often need to detect if site visitor is using an iPad, a smartphone or any other mobile device in order to change website appearance and even make it faster by reducing data load. Normally we use the media queries and Read more…