ALTER USER'root'@'localhost'IDENTIFIED BY'newRootPassword';
https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html Check and veify your my.cnf ssl entries if you see the following error in the /var/log/mysqld.log file at startup:
1
Failed toset up SSL because of the following SSL library error:SSL_CTX_set_default_verify_paths failed
I wanted to save the iptables list to disk, but got an error when I tried: # service iptables save The service command supports only basic LSB actions (start, stop, restart, try-restart, reload, force-reload, status). For other actions, please try to use systemctl. The solution was to install the iptables-services package: # yum install iptables-services […]
When trying to mount can XFS filestsen on an AWS instance, I got the error “mount: wrong fs type, bad option, bad superblock on /dev/sdh” Examine the volume’s UUID with the xfs_db command: shell> sudo xfs_db -c uuid /dev/nvme2n1 To fix the problem, you have two options… Temporary Solution Add nouuid mount option to temporarily […]
When trying to access the serial console on AWS, I got the following error: Cannot open access to console, the root account is locked Since I had edited /etc/fstab, the host would not boot. The only way to fix this problem is to unmount the root volume from the affected instance, mount it on another […]
In the macOS Terminal, my mouse scroll wheel would magically start scrolling the command line history instead of the window buffer scroll bar on the right to show window history. This happened when an SSH session was disconnected or timed out. The fix is to run the reset command.
I was unable to login from my old iMac running Yosemite to my new iMac running Ventura using RSA keys. It turns out that RSA key support was disabled in Ventura. To correct the problem, I added the following two lines to the bottom of BOTH /etc/ssh/ssh_config and /etc/ssh/sshd_config on the Ventura side:
I have been using RSA SSH keys forever to login to my various AWS EC2 instances. With macOS Ventura 13.3.1 ssh failed with the “Permission Denied” error. Using ssh -vvv, I saw that the RSA key was now being rejected. After much research, I decided to implement new keys on the client (Ventura) side using […]
In order to get rsync to have access to the hard drive in macOS Ventura, you need to add rsync and other programs to the Full Disk Access panel under Privacy […]
First, use the AWS Console to modify the volume to the desired size, in our example we want to go from 10GB to 25GB for the root filesystem For a Xen ext4 root volume
PROBLEM: I was seeing the following error when trying to do a plugin update, and an error in my WordPress logs: Update failed: 504 Gateway Timeout Gateway Timeout The gateway did not receive a timely response from the upstream server or application. [Tue Apr 11 22:12:01.373709 2023] [proxy_fcgi:error] [pid 26878] (70007)The timeout specified has expired: […]
erics, August 31st, 2023 
Categories: How-To's, Technology 5.7, 8.0, AWS, AWS Linux, CentOS, howto, mysql, MySQL 5.7, MySQL 8.0, tips, upgrade
| 
No comments 
