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 Plugin : In Out Management System System Requirements:   Software:   Apache (Already there in koha server)   PHP   MySQL (Already there in koha server)  Any text editor like vim/mousepad/leafpad/gedit Hardware:  A computer system with a widescreen monitor  Automatic barcode scanner Installation: PHP Installation:  for Debian 10 & Ubuntu 20.04 LTS Open a terminal and enter the following commands. sudo apt-get install -y git php libapache2-mod-php php-{bcmath,bz2,intl,gd,mbstring,mysql,zip,cli,fpm,opcache,xml,curl,intl,xsl,soap,json} cd /usr/share/koha/opac/htdocs sudo git clone https://github.com/omkar2403/inout.git sudo chmod 777 -R inout Setup the database: Go to MySQL shell and create a database, user, and password for inout   sudo su mysql -uroot -p [Enter MySQL Root password] CREATE database   libinout ; CREATE USER ' libinout '@'localhost' IDENTIFIED BY ' libinout123 '; GRANT ALL PRIVILEGES ON *.* TO ' libinout '@'localhost' WIT