How to reset MySQL Root Password in Linux Rumi, June 6, 2014 First, Let’s stop the mysql service, In Red Hat’s family (Red Hat Enterprise, Fedora, CentOS) the Mysql Daemon is called ‘mysqld‘, but in Debianlike Ubuntu based distributions and OpenSuse its called ‘mysql‘. I’ll be using the debian based naming sudo service mysql stop OR sudo /etc/init.d/mysql stop Now, we’ll start the server in safe mode and skip grant tables so that it wont ask for the password we had lost when we try to login sudo mysqld_safe –skip-grant-tables you should see something like this 111026 11:05:46 mysqld_safe Logging to syslog. 111026 11:05:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Now open a new terminal window and run the mysql console using the main mysql database named ‘mysql‘ using the root user mysql –user=root mysql Then we’ll reset the password from the mysql’s users table, flush privieges, then exit the mysql console UPDATE user SET password=PASSWORD('new-password') WHERE user='root'; flush privileges; exit; Start again the mysql daemon sudo service mysql stop sudo service mysql start That’s All Related Configurations (Linux) MySQL
CentOS: Configure Piranha as Load Balancer (Direct Routing Method) April 19, 2013 I am currently working on a web cluster project using CentOS. In this project, I have 2 web servers running on Apache and mounted the same document root to serve the HTTP content. I also have 2 servers in front of it to become the load balancer and failover to… Read More
Download YouTube Videos in Linux Command Line August 3, 2020 Install youtube-dl to download YouTube videos in Linux terminal youtube-dl is a Python-based small command-line tool that allows downloading videos from YouTube, Dailymotion, Photobucket, Facebook, Yahoo, Metacafe, Depositfiles and few more similar sites. It is written in pygtk and requires Python interpreter to run this program, it’s not platform restricted. It… Read More
Using NGinx to serve static files and Apache for dynamic September 6, 2019 Apache is a great web-server, but it has a pretty heavy memory footprint. It can get quite restrictive quite quickly, especially if you’re on a system will limited resources (given how many people now run on a VPS, and the poor disk IO of these systems it’s all the more… Read More