Reset a MySQL root password for Debian Rumi, July 14, 2016 Use the following steps to reset a MySQL root password by using the command line interface. Stop the MySQL service (Ubuntu and Debian) Run the following command: sudo /etc/init.d/mysql stop (CentOS, Fedora, and Red Hat Enterprise Linux) Run the following command: sudo /etc/init.d/mysqld stop Start MySQL without a password Run the following command. The ampersand (&) at the end of the command is required. sudo mysqld_safe --skip-grant-tables & Connect to MySQL Run the following command: mysql -uroot Set a new MySQL root password Run the following command: use mysql; update user set password=PASSWORD("mynewpassword") where User='root'; flush privileges; quit Stop and start the MySQL service (Ubuntu and Debian) Run the following commands: sudo /etc/init.d/mysql stop ... sudo /etc/init.d/mysql start (CentOS, Fedora, and Red Hat Enterprise Linux) Run the following commands: sudo /etc/init.d/mysqld stop ... sudo /etc/init.d/mysqld start Log in to the database Test the new password by logging in to the database. mysql -u root -p You are prompted for your new password. Related Administrations Configurations (Linux) MySQL MySQL
Powerdns: init.d and mrtg September 4, 2011 As mentioned before, the init.d commands dump, show and mrtg fetch data from a running PDNS process. Especially mrtg is powerful – it outputs data in a format that is ready for processing by the MRTG graphing tool. MRTG can make insightful graphics on the performance of your nameserver, enabling… Read More
Install ZFS on Ubuntu May 17, 2023 Installing ZFS Filesystem on Ubuntu We will be using the command line Terminal application for the installation of the ZFS filesystem. To launch the command line Terminal, use the Ctrl+Alt+T keyboard shortcut. Now to install the ZFS filesystem on Ubuntu, issue the following command in Terminal: $ sudo apt install… Read More
Install VPN PPTP Server on CentOS October 4, 2013March 29, 2017 In this tutorial, I will use pptp as protocol to connect to VPN server using a username and password, with 128 bit MPPE encryption. Variable as below: OS: CentOS 6 64bit VPN server: 209.85.227.26 VPN client IP: 209.85.227.27 – 209.85.227.30 VPN username: vpnuser Password: myVPN$99 Install ppp via yum: $… Read More