Perfect way to reset MySQL Root Password on Debian/Ubuntu Rumi, August 9, 2016 If you forgot your MySQL root password, you can reset it by following these steps. 1. Stop the MySQL service. service mysql stop 2. Start MySQL without password and permission checks. mysqld_safe --skip-grant-tables & 3. Press [ENTER] again if your output is halted. 4. Connect to MySQL. mysql -u root mysql 5. Run following commands to set a new password for root user. Substitute NEW_PASSWORD with your new password. UPDATE user SET password=PASSWORD('NEW_PASSWORD') WHERE user='root'; FLUSH PRIVILEGES; 6. Restart the MySQL service. service mysql restart Related MySQL
MariaDB Galera Cluster on Ubuntu 20 December 28, 2022December 28, 2022 MariaDB Galera Cluster is a synchronous multi-master cluster for MariaDB with support for XtraDB/InnoDB storage engines. It has the following top features. It provides active-active multi-master topology You can read and write to any cluster node It has an automatic node joining Automatic membership control, failed nodes drop from the… Read More
Recover MySQL root Password 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:… Read More
Exporting Percona Database March 11, 2020March 11, 2020 Exporting percona database is however a bit tricky way to make funcitonal. The usual- mysqldump -u root -p [database] > database.sql will stuck and shoot you many error. All you need is the add an extended parameters to execute the dump, and here it is: mysqldump -u root -p [database]… Read More