Recover MySQL root Password Rumi, December 19, 2011 Step # 1 : Stop mysql service # /etc/init.d/mysql stop Output: Stopping MySQL database server: mysqld. Step # 2: Start to MySQL server w/o password: # mysqld_safe --skip-grant-tables & Output:[1] 5988 Starting mysqld daemon with databases from /var/lib/mysql mysqld_safe[6025]: started Step # 3: Connect to mysql server using mysql client: # mysql -u root Output:Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> Step # 4: Setup new MySQL root user password mysql> use mysql; mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root'; mysql> flush privileges; mysql> quit Step # 5: Stop MySQL Server: # /etc/init.d/mysql stop Output: Stopping MySQL database server: mysqld STOPPING server from pid file /var/run/mysqld/mysqld.pid mysqld_safe[6186]: ended [1]+ Done mysqld_safe –skip-grant-tables Step # 6: Start MySQL server and test it # /etc/init.d/mysql start # mysql -u root -p Src: http://www.cyberciti.biz/tips/recover-mysql-root-password.html Related Collected Articles Configurations (Linux) MySQL
Ubuntu Firewall – UFW useful commands May 17, 2020 Prerequisites To follow this tutorial, you will need one Debian 10 server with a sudo non-root user, which you can set up by following Steps 1-3 in the Initial Server Setup with Debian 10 tutorial. Step 1 – Installing UFW Debian does not install UFW by default. If you followed… Read More
reset root password on CentOS 7 January 10, 2024 You need to have a console access for running this operation. 1. Inside java or HTML5 console, please reboot your server and wait for the GRUB menu 2. Inside the GRUB menu select your first entry and press “E” key to edit. 3. Find a line with ro and change it to rw… Read More
Install ClamAV on CentOS 6 May 23, 2020 Step 1. First add yum repository your system. The EPEL repo is enabled by simply installing an RPM. Please use the command below to install the EPEL repository on your CentOS server. #CentOS 6 – 32-bit rpm -Uvh http://mirror.overthewire.com.au/pub/epel/6/i386/epel-release-6-8.noarch.rpm #CentOS 6 – 64-bit rpm -Uvh http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm Step 2. Install required ClamAV packages…. Read More