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

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