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
Install Nginx Proxy Manager on CentOS 7 November 22, 2023 Nginx Proxy Manager is built on docker container. So, we need to deploy Docker first. Update Docker Package Database. In a terminal window, type: sudo yum check-update Allow the operation to complete. Remove if any docker is preinstalled with your OS- sudo yum remove docker docker-client docker-client-latest docker-common docker-latest docker-latest-logrotate… Read More
Proxmox GUI webpage stuck on loading January 8, 2023 Connection time out!!!! So boring nah? I can’t figure out where the problem is. It works and then couple of hours later I’d come back and it keeps on loading forever. SSH works fine, can SSH into containers as well. Just the GUI doesn’t work. Tried full upgrade. Checked for… Read More
Putting Varnish In Front Of Apache On Ubuntu/Debian March 22, 2012 Varnish is an open source "web accelerator" which you can use to speed up your website. It can cache certain static elements, such as images or javascript but you can also use it for other purposes such as Loadbalancing or some additional security. In this tutorial we will focus… Read More