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

Group by Provider ID of Logged in User in Laravel

  To adjust the query to accommodate transactions where the status_id is either 1 or 6, you can use the whereIn method provided by Laravel's Query Builder. This method allows you to specify an array of values that the status_id column must match. Here's how you can modify the getTransactionAggregates method in your controller to include this logic: namespace App\Http\Controllers; use Illuminate\Http\Request; use Illuminate\Support\Facades\DB; class TransactionController extends Controller { public function getTransactionAggregates($user_id, Request $request) { $startDate = $request->query('startDate'); $endDate = $request->query('endDate'); $transactionAggregates = DB::table('reports') ->where('reports.user_id', $user_id) ->join('providers', 'reports.provider_id', '=', 'providers.id') ->whereBetween('reports.created_at...
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