LIB Science Info

 Easy Way to Reset MYSQL Root Password for Linux User Stop the MySQL service, Run the following command for Ubuntu and Debian Users  sudo /etc/init.d/mysql stop For CentOS, Fedora, and Red Hat Enterprise Linux Users sudo /etc/init.d/mysqld stop Now Start MySQL without a password Run the following command sudo mysqld_safe --skip-grant-tables & Connect to MySQL mysql -uroot Set a new MySQL root password use mysql; update user set password=PASSWORD(" yournewpassword ") where User='root'; flush privileges; quit Run the following command to Stop and start the MySQL service For Ubuntu and Debian Users  sudo /etc/init.d/mysql stop sudo /etc/init.d/mysql start For CentOS, Fedora, and Red Hat Enterprise Linux Users sudo /etc/init.d/mysqld stop sudo /etc/init.d/mysqld start Refer:  https://www.librarianvijender.com/2022/12/easy-way-to-reset-mysql-root-password.html

 Koha Backup and Restoration Run the following command from the terminal in order to take the backup of your Koha database.  sudo mysqldump -u root -p koha_library > koha_library.sql Enter the MySQL root password. (Check the name of your database, in the above-mentioned command, root is a username for MySQL database (usually it is root unless you changed it) koha_library is a database name, and koha_library.sql is the name of the database backup file) Now Restore the database backup in the newly installed Koha machine Apply following commands sudo su (Hit Enter and enter the password) sudo apt-get update Open the MySQL database. sudo mysql -uroot -p Enter the MySQL database password Drop (remove) the existing database from koha. drop database koha_library; Now create the new database named " koha_library " create database koha_library; quit; Place your database backup file in the home folder. Execute the below command to restore the old backup to the new Koha installati