Get All MySql user list using command

Login using Below command 

mysql -u root -p 

After login type below command to know complete mysql User List

SELECT User, Host FROM mysql.user;




Comments

Post a Comment

Popular posts from this blog

2 Column unique validation in controller in Laravel

Two Column unique validation in controller in Laravel In Laravel, ensuring a combination of two columns is unique within a database table often arises when dealing with complex data relationships, such as enforcing that a user can only have one role within a specific organization. This scenario cannot be directly handled through Laravel's standard unique validation rule, which traditionally operates on single fields. However, Laravel is flexible enough to accommodate this requirement through custom validation logic or advanced usage of its validation features. To implement a two-column unique validation in a Laravel controller, one effective method involves utilizing a combination of custom validation rules and querying the database to check for the existence of the specific combination of values. The approach involves creating a custom validation closure that leverages Laravel's Query Builder to search the relevant table for records matching both column values submitted by th...
Read more

Axis Bank BBPS API Integration

Integrating with Axis Bank's Bharat Bill Payment System (BBPS) involves a few key steps that require both technical know-how and access to specific financial services APIs. The BBPS, facilitated by the National Payments Corporation of India (NPCI), provides a standardized platform for making bill payments across the country. While I can guide you through the general process, please note that the exact details, including API credentials and specific integration steps, will be available only through Axis Bank's official channels and documentation. ### General Steps for API Integration: 1. **Register with Axis Bank**: Before you can integrate with their BBPS API, you need to establish a formal relationship with Axis Bank. This involves registering your business and applying for access to their payment APIs. The registration process may require you to submit business details, KYC documentation, and other relevant information. 2. **API Documentation**: Once registered, you will gain...
Read more