To change user password in WordPress using MySql you can use the following query.
Sample MySql
UPDATE wp_users SET user_pass = MD5('NewPassword') WHERE user_login = 'UserName';
User
How to change default Admin Username in WordPress
Every default WordPress installation will create an account with a default Admin username. This can be a security issue.
To change default Admin Username in WordPress you can use the mySql snippet below.
UPDATE wp_users SET user_login = 'NewUsername' WHERE user_login = 'Admin';
How to list all user defined functions in MSSQL
To list all user defined functions in MSSQL you can use the following snippet.
Sample MSSQL
SELECT name AS function_name, SCHEMA_NAME(schema_id) AS SCHEMA_NAME ,type_desc FROM sys.objects WHERE type_desc LIKE '%FUNCTION%' ORDER BY name asc;
How to detect browser in PHP
To detect browser in PHP you can use the following snippet.
Sample PHP
$userAgent = $_SERVER ['HTTP_USER_AGENT'];
How to get the current logged in user in Java
To get the current logged in user in Java you can use the following snippet.
Sample Java
System.getProperty("user.name")
How to list all users in MSSQL
To list all users in MSSQL you can use the following snippet.
select * from sys.sysusers ORDER BY name asc
How to get the current username using C# or VB.NET
There is more than one way to get the current username using C# or VB.NET i will show you one using Environment Variable and one using the WindowsIdentity.
If you are in a Network the output of both methods is different.
using the Environment variable
Sample C#
string currUsername = Environment.UserName;
Sample VB.NET
Dim currUsername As String = Environment.UserName
using the WindowsIdentity
Sample C#
string currUsername = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
Sample VB.NET
Dim currUsername As String = System.Security.Principal.WindowsIdentity.GetCurrent().Name
Possible Output
|
1 |
<span class="str">using the Environment Variable: <strong>Username</strong></span> |
|
1 |
<span class="str">using the WindowsIdentity: <strong>Domainname\Username</strong></span> |
Tip
if you want to use the Environment variables and want to get the Domainname also, take a look at Environment.UserDomainName Property
for more informations take a look at the MSDN: Environment.UserName, WindowsIdentity Class