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 ...
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...
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:...
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...
@@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...
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...

Search This Blog

Categories

About

Home

blogger visitor