How to get a list of MySQL user accounts?

In MySQL, you can get list of user account with user details. Just execute following Query of PHPMySQL/SQL Yog/Other MySQL Tools.

List of MySQL users.

SELECT User FROM mysql.user

List of MySQL unique users.

select distinct User from mysql.user;

List of MySQL users with password and host.

SELECT Host,User, Password FROM mysql.user

List of MySQL unique Users with password and host.

SELECT Host,User, Password FROM mysql.user  group by User

List of MySQL users with all permissions.

SELECT * FROM mysql.user WHERE 1

Best Related Posts are Following:

1. DBMS Interview Questions and Answers for Freshers.
2. MySQL Interview Questions and Answers for Experienced.
3. Difference between inner join and outer join in MySQL.
4. How to get a list of MySQL user accounts?.
5. What is MySQLI technology in php.
6. How to delete MySQL Binary logs Files in Wamp Server?.
7. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 2269548 for key PRIMARY.
8. Multiple column ordering in Zend Framework.
9. Mysql Privileges - Types of privileages in MySql - How do I grant privileges in MySQL.
10. Difference Between Primary Key And Unique Key And Foreign Key And Composite Key.
11. Difference Between MyISAM and innoDB - MySQL.
12. MySQL Functions - MySQL tutorial for beginners.
13. mysqlsubqueries examples Scalar Subqueries Row Subqueries Column Subqueries Table Subqueries.
14. Mysql FullText Search Examples.
15. MySQL Constraint Example.
16. MySQL Cascade Example.
17. Mysql-Group-Concat.
18. MySQL Expressions.
19. MySQL Delete Table Example.
20. Replace Table - Update Field, Move Records to another table MySQL.
21. mysql insert syntax - Add records from another table - Copy Table from one table to another.
22. Mysql Update Syntax - Update Multiple Records.
23. What is Mysql.
24. Mysql Console Commands - Export and Import database from command line.
25. MySQL interview Questions and Answers For Experienced.

What is stdClass? and How to create stdClass class?

What is stdClass class?
stdClass is Generic empty class in PHP.
OR
stdClass is universal base class in PHP.



Question: Why stdClass class is used?
stdClass is used to create anonymous objects with properties.



Question: Where it is used?
When we need to create an object without having new class. then we used stdClass class which is inbuilt in PHP.
After create object, we can add properties.



Question: How to create stdClass class?

$object=new stdClass();

Question: Can we set different variables in StdClass?
Yes, We can do both get and set.
See Example Below:

//First, create an object with use of stdClass
$object=new stdClass();

//Set new variables in $object 
$object->name='Web Technology Experts Notes';
$object->url='web-technology-experts-notes.in';

//Get the variables values
echo $object->name;
echo $object->url;

Best Related Posts are Following:

1. Top 10 PHP Interview Questions and Answers.
2. PHP Questions and Answers for experienced.
3. PHP Difficult Interview Questions and Answers.
4. How to Detect Request type (GET OR Post ) in PHP.
5. PHP Basic questions and answers for fresher and experienced.
6. PHP Mysql Interview Questions and Answers for fresher and experienced.
7. PHP interview questions and answers for 5 year experienced.
8. PHP Frequently asked Questions and Answer 2015.
9. PHP problem solving interview questions and answers for Fresher and Experienced.
10. PHP Interview Questions and Answers for 2 year Experience.
11. What is stdClass? and How to create stdClass class?.
12. Advanced PHP Interview Questions and Answers.
13. SPDY Protocol - Improve the Speed of web page.
14. PHP Technical Interview Questions and Answers for Fresher and Experienced.
15. How to stop parsing the HTML tags?.
16. Difference between Notice and warning and fatal error.
17. Object Oriented Programming in PHP.
18. Htaccess RewriteRule Flags by Code Example.
19. Enabling the openssl in Wamp-Xampp.
20. How to find day of week in php in a specific timezone.
21. What is difference between natcasesort and sort?.
22. Zend Cache Tutorial - Zend Framework 1.12.
23. Important PHP Interview Questions and Answers - jQuery, SQL Modes, Client Programs and Reset.
24. PHP Check Mime Type of File - Return Information About A File.
25. PHP Captcha Code Example Code Snippets.
26. PHP - Secure Ajax Call from Hackers - Example.
27. Zend Database Query - Zend Profiler Example - Code Snippets.
28. Export to CSV File - PHP.
29. htaccess code snippets example.
30. Manage Cron Job with PHP - SSH2 Connection.
31. OOP Interview Questions and Answers.
32. CURL Example.
33. PHP Interview Questions and Answers PDF.
34. Stored Procedure - Advantage of Stored Procedure - Disadvantage of Stored Procedure.
35. How To Track the Real IP Address Behind the Proxy - PHP - REMOTE_ADDR.
36. Pending Interview Questions and Answers.
37. Cache in PHP - Speed Up your website.
38. PHP DataStructures.
39. php interview questions and answers for 1 year experience.
40. PHP Interview Questions and Answers for Experienced.
41. Difference between Abstract class and Interface in PHP.
42. Concurrent Connections of Apache Server.
43. Regular Expressions PHP/Javascript.
44. php interview questions and answers.
45. What is Zend Engine in PHP.