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
Enable TLS 1.0 in Firefox Browser March 26, 2022 Firefox 43 supports TLS 1.0, 1.1, and 1.2 by default. You shouldn’t need to make any changes, but you can double-check the settings here if you like: (1) In a new tab, type or paste about:config in the address bar and press Enter/Return. Click the button promising to be careful…. Read More
Fixing error: ‘Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)’ January 17, 2017 For all you Ubuntu/MySQL developers out there, have you ever seen the following? neo@thematrix:~$ sudo /etc/init.d/mysql restart * Stopping MySQL database server mysqld [fail] * Starting MySQL database server mysqld [ OK ] /usr/bin/mysqladmin: connect to server at ‘localhost’ failed error: ‘Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)’ So,… Read More
Install LAMP with PHP-FPM on Ubuntu 20 April 4, 2021 Step 1 – Installing Apache Apache web server debian packages are available under the default repositories. Login to your Ubuntu system with sudo privileges account. Open a terminal and execute the following commands: sudo apt update sudo apt install apache2 libapache2-mod-fcgid The above commands will install Apache and FastCGI module… Read More