Reset Forgotten MySQL Root Password Rumi, September 9, 2008September 9, 2008 Have you ever forgotten the root password on one of your MySQL servers? No? Well maybe I’m not as perfect as you. This is a quick h00tow (how to) reset your MySQL root password. It does require root access on your server. If you have forgotten that password wait for another article. Original article posted on reset mysql root password. First things first. Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords. mysqld_safe –skip-grant-tables You should see mysqld start up successfully. If not, well you have bigger issues. Now you should be able to connect to mysql without a password. mysql –user=root mysql update user set Password=PASSWORD(‘new-password’); flush privileges; exit; Now kill your running mysqld, then restart it normally. You should be good to go. Try not to forget your password again. Related Administrations
Enabling SquirrelMail For Your Web Sites On An ISPConfig 3 Server (Debian Lenny) January 29, 2011January 29, 2011 SquirrelMail's Apache configuration is in the file /etc/squirrelmail/apache.conf, but this file isn't loaded by Apache because it is not in the /etc/apache2/conf.d/ directory. Therefore we create a symlink called squirrelmail.conf in the /etc/apache2/conf.d/ directory that points to /etc/squirrelmail/apache.conf and reload Apache afterwards: cd /etc/apache2/conf.d/ ln -s ../../squirrelmail/apache.conf squirrelmail.conf /etc/init.d/apache2 reload… Read More
Configuring SpamAssassin for Postfix on CentOS May 23, 2020 In the process of receiving email, spamassassin will stand between the outside world and the email services running on your server itself. If it finds, according to its definition rules and configuration, that an incoming message is spam, it will rewrite the subject line to clearly identify it as such…. Read More
Zip and Unzip Command in Linux May 28, 2011 Zipping a Directory zip is a compression and file packaging utility for Unix, Linux, VMS, MSDOS, OS/2, Windows NT, Minix, Atari and Macintosh, Amiga and Acorn RISC OS etc. This utility is installed by default on most Linux computers. he program is useful for packaging a set of files for… Read More