Lost MySQL Admin Password

If you’ve lost the MySQL admin password, you can reset it by following these steps: Stop the MySQL server: sudo systemctl stop mysql Start the MySQL server with the –skip-grant-tables option to skip the permission check: sudo mysqld_safe –skip-grant-tables & Connect to the MySQL server as the root user without a password: mysql -u root … Read more

Suse Linux ( SLES10 ) IPv6 Configuration

To configure IPv6 on SUSE Linux Enterprise Server 10 (SLES10), you can follow these steps: Open the network configuration file in a text editor: sudo vi /etc/sysconfig/network/ifcfg-eth0 Replace “eth0” with the name of your network interface. Add the following lines to the file to enable IPv6: IPV6INIT=yes IPV6_AUTOCONF=yes These options enable IPv6 on the interface … Read more

Explain: php_self or $_SERVER[‘PHP_SELF’] Usage

In PHP, $_SERVER[‘PHP_SELF’] is a predefined variable that returns the name of the currently executing script, including any path information. It is often used in web applications to generate self-referencing URLs or to specify the target of a form submission. Here’s an example of how you can use $_SERVER[‘PHP_SELF’] to generate a self-referencing URL: <form … Read more

FreeBSD: Upgrade PHP4 To PHP5

PHP4 is a very old version of PHP and is not supported anymore. Therefore, it is recommended to upgrade to a newer version of PHP, such as PHP 7.4 or 8.0. However, if you still need to upgrade from PHP4 to PHP5 for some reason, you can follow the steps below: Install the PHP5 packages: … Read more

Debian IPv6 Networking Configuration

To configure IPv6 networking on Debian, you can follow these steps: Edit the /etc/network/interfaces file: sudo nano /etc/network/interfaces Add the following lines to the file, assuming your network interface is eth0: iface eth0 inet6 auto This will tell the system to use the automatic IPv6 configuration method, which is called stateless address autoconfiguration (SLAAC). Save … Read more

MySQL Reset Root Password

To reset the root password in MySQL, you can follow the steps below: Stop the MySQL service: sudo service mysql stop Start MySQL in safe mode: sudo mysqld_safe –skip-grant-tables –skip-networking & Connect to the MySQL server: mysql -u root At the MySQL prompt, enter the following commands: use mysql; update user set authentication_string=PASSWORD(“new_password”) where User=’root’; … Read more