Perfect way to reset MySQL Root Password on Debian/Ubuntu Rumi, August 9, 2016 If you forgot your MySQL root password, you can reset it by following these steps. 1. Stop the MySQL service. service mysql stop 2. Start MySQL without password and permission checks. mysqld_safe --skip-grant-tables & 3. Press [ENTER] again if your output is halted. 4. Connect to MySQL. mysql -u root mysql 5. Run following commands to set a new password for root user. Substitute NEW_PASSWORD with your new password. UPDATE user SET password=PASSWORD('NEW_PASSWORD') WHERE user='root'; FLUSH PRIVILEGES; 6. Restart the MySQL service. service mysql restart Related MySQL
Reinstalling MySQL on CentOS/Redhat 6 February 7, 2016 Some time we faces issues with MySQL installation on Linux machine. If we simply remove MySQL packages and re-install doesn’t fixes the issue, in that case old settings may still exists on server which again affects new install. In that case first uninstall MySQL completely from system and erase all… Read More
Reset a MySQL root password for Debian 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… Read More
Installing MySQL on Debian September 26, 2020 Step 1 – Prerequisites Login to your Debian 9 system using shell access. For remote systems connect with SSH. Windows users can use Putty or other alternatives applications for SSH connection. ssh root@debian9 Run below commands to upgrade the current packages to the latest version. sudo apt update sudo apt… Read More