How to change MySQL root password

We can change the password using SET PASSWORD() function or by using UPDATE command.

Change MySQL root password up to 5.6 versions:

USE mysql
UPDATE user SET PASSWORD = PASSWORD(‘mysql@123’)
WHERE Host = ‘localhost’ AND User = ‘root’; flush privileges;

or

SET PASSWORD FOR root@’localhost’ = PASSWORD(‘mysql@123’); flush privileges;

For both above methods, if miss to run flush privileges;, changes will not effect.

Change MySQL root password from 5.7 or later versions:

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

When we try to login MySQL server by typing mysql, received below error message.

ERROR 1045 (28000): Access denied for user

root@ubuntu:~# mysql
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)
root@ubuntu:~# mysql -u -r
ERROR 1045 (28000): Access denied for user ‘-r’@’localhost’ (using password: NO)
root@ubuntu:~#

Cause:

How to change proxy settings in Mozilla Firefox

This topic explains “How to change proxy settings in Mozilla Firefox” in LAN(Local Are Network).

In windows Operation System: Open Mozilla Firefox and click on Top right corner(Open menu shown below) then select options or on Mozilla Firefox window Press Alt+T from keyboard then select options:

How to install MySQL on Linux

In this article, we are going to install MySQL on Ubuntu Linux Distribution.

1) Log on to Ubuntu Server and open Terminal

2) Type the following command in terminal

sudo apt-get instal mysql-server

rmdir failed to remove directory not empty

When we try to remove a directory using a command the rmdir command, if we receive a prompt such as “rmdir: ‘dir’: Directory not empty”. This means directory contains, files and folder inside. To remove all files and folder inside directory, we have to use recursive option “rf” with rm command.

Note: Be careful about “-rf” option, once removed files and sub directories of directory cant be recovered.

rmdir failed to remove directo not empty

Solution:

Create user account in active directory using PowerShell

Following commands are used to manage user accounts via PowerShell.

Difference between Local User and Domain User

Local User:

  1. In Windows, a local user is one whose username and encrypted password are stored on the computer itself.
  2. A user account created in local database of a computer.
  3. Local Users are generally used in WORKGROUP model.
  4. Local Users can login only on the respective computer.

How to assign IP address in Windows

Every operating system will assign IP address at the time of OS installation. If we want to set IP address as your wish, follow the below steps.

To check current IP address of your machine open Command prompt or PowerShell, then run ipconfig

Convert Windows Core to Windows Server GUI

From Windows 2008, installations are two types: Server with GUI(full installation) and Server Core. From Windows 2012, it is also possible to convert Windows Server GUI to Core and Windows Server Core to GUI. Windows Core version had less features than Windows GUI(full installation). To change GUI to core or Core to GUI, user should login with administrator privileges.

Convert Windows Core to Windows Server GUI

Convert Windows Server GUI to Core

From Windows 2008, installations are two types: Server with GUI(full installation) and Server Core. From Windows 2012, it is also possible to convert Windows Server GUI to Core and Windows Server Core to GUI. Windows Core version had less features than Windows GUI(full installation). To change GUI to core or Core to GUI, user should login with administrator privileges.

Convert Windows Server GUI to Core Using PowerShell

Powered by k2schools