Retrieve Mysql users list and its privilege

Developer

Interview Question of C#, Asp.Net, Linq, SQL, MySql, Azure, Javascript, Web API, Software Development, Software Architecture and Design Pattern.

Monday, 30 April 2012

Retrieve Mysql users list and its privilege

Run the below query through command prompt of my-sql

select * from mysql.user\G;

Posted by Vikash Sinha at 14:17

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

Labels: SQL

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Popular Posts

stored procedure in sql server

SQL SERVER- stored procedure In a database management system (DBMS), a stored procedure is a set of Structured Query Language (SQL) state...
Candidate Key Vs Primary Key Vs Alternate key Vs Composite Key Vs Unique Key VsForeign Key

Candidate Key A Candidate Key is a set of one or more fields/columns that can identify a record uniquely in a table. There can be multi...
Read tnsnames.ora in VB.NET

Below are the code for read tnsname.ora file(tns name) in vb.net. Through below functions you can get the information of the tns. //Decla...
Retrieve Mysql users list and its privilege

Run the below query through command prompt of my-sql select * from mysql.user\G;
Directcast-Vs-Ctype

By "conversion" mean converting one datatype to another (e.g. string to integer, decimal to integer, object to string etc). By ...
Import excel data in sql server 2005

Run the below Query in Sql Server query window Select * FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:...
SQL SERVER – Stored Procedure Optimization

1) Use schema name with object name eg. Select * from dbo.tablename 2) Do not use the prefix “sp_” in the stored procedure name : I...
python for loop

for loop in python There are two types of loops in Python, for and while. The "for" loop For loops iterate over a given...
BDD Vs TDD Vs ATDD

BDD lets organizing software development documentation in a more efficient, more business-like way. Thus business analysts can access info...
@@rowcount in SQL Server

@@rowcount: Returns the number of rows affected by the last statement. Example: print @@rowcount--It will return 0 select top 10 * f...

Search This Blog

Categories

About

Home

blogger visitor