This comes up many times when you need to add a backup super user to MySQL (or MariaDB). Passwords are lost, forgotten, etc and although MySQL allows for a fairly quick password reset, it is always a good idea to have a backup.
Login as root and run the following query. It will add a new user, called "sysadminuser", with access to localhost (ie: the current machine locally). This new user will be allowed to login using the password: "passwordfortheuser". (Change these as needed):
If you have a non-existing (or unplugged) external drive in /etc/fstab, Linux will not boot until you either press S to skip or M for manual mount. This is a desired behavior, because the operating system does not know what is on that external drive and whether it should ignore the error. If the disk is just used for archiving, the system not booting can be a problem, especially if the disk is just temporarily removed.
To avoid this, you have to add nofail to the fstab, so if the disk becomes detached, the system will continue to boot.
Here's an example:
Linux allows you to access an ISO image, rather than having to burn a CD or DVD. Keep in mind that the image will be read-only.
Assuming your ISO image is in ~/Downloads/ and you have a directory called /media/cdrom (these are usually created automatically during the install)
You can achieve this using the following command.
If you have a disk that has been uncleanly unmounted, you can run a tool called ntfsfix to correct the issues. Keep in mind that ntfsfix is a utility that fixes some common NTFS problems, but it is not a Linux version chkdsk or equivalent of fsck. It will repair some basic inconsistencies and reset the NTFS journal. You should repair NTFS disks under windows, when possible.
Running the command:
Some Canon multifunctions do not allow you to change the ports from the web interface (ie: iR-ADV 4525), only when you are in front of the multifunction itself. If there's no on-site access, there's a way to bypass this issue.
First enable remote access. On the Web Interface, go to:
Management Settings -> License/Other:
1) Select "Remote Operation Settings" and enable "Use Remote Operation" checkbox
2) Select "ACCESS MANAGEMENT SYSTEM Settings" and enable "Use ACCESS MANAGEMENT SYSTEM" checkbox.
Once done, hit "Apply Setting Changes" and reboot the printer.
A small script to capture video stream (eg: from a security camera). The script takes in time in format of HH:MM:SS and created directories based on the current date. Based on the current variables, it outputs the files to /opt/camera/recordings/. It also needs a temp directory, called streams under /opt/camera/.
Usage example (to capture 11 minutes of the stream):
This comes up over and over again. Accidentally drag or move a window in GIMP and then you go both panels on one side. As annoying as it may be, there's an easy way to reset the windows layout to their default location.
Go to Edit menu -> Preferences -> expand the Interface item -> Window Management -> Reset Saved Window Positions to Default Values
We've tried to install a Perl package unsuccessfully on a Mac and, as it turns out, you need to do a few things before you can run CPAN and install packages. Specifically, you need to install developer tools:
Once that installs, you should now be able to run cpan and install packages. Make sure cpan runs as a super user (ie sudo):
When you enable the VNC connection on a Mac, it will not let you login directly to the current user, but rather it will present you with a login screen after you've authenticated with VNC. This is convenient when you want to login to another account remotely, but not so much if you are trying to assist the current user (this is especially annoying for IT technicians, accessing the computer remotely and not knowing the user password)
There are various ways to restart and shut down your mac. The obvious one is through the Apple menu (there's very little magic about that), but the one that is more useful is using a command line. Because MacOS is a derivative of Unix, it has many tools hidden from an average user. To restart the system using a command line, open a terminal and run the following:
Q. Hello IT Support, I know there's a feature in BIOS for PCs to be turned on after a power outage. Is there such a function in a Mac?
A. Yes, this is a useful feature to have for remote computer access. If you login with an account that has administrative privileges, you should be able to do that. Go to: