Before you deploy any Web Application on your Ubuntu Server, You have to install Java , Tomcat Server, MySql Database, phpMyAdmin etc. First of all open Terminal on GCP Ubuntu Instance OR connect your AWS Ubuntu Instance in Putty Software through SSH. Login as root and update > sudo su > apt-get update Install JAVA (OpenJDK) Run below command to install OpenJDK 11 > sudo […]
After installing MySql/MariaDB Database Server, You can easily install phpMyAdmin on Ubuntu Machine.Follow the steps below:1. Update the package index and upgrade the system packages to the latest versions: > sudo apt update > sudo apt upgrade (optional)2. Install the phpMyAdmin package > sudo apt install phpmyadmin3. Choose apache2 by pressing Space Key and then Enter on Keyboard, when a popup screen appears.4. Next, you will be asked […]
Set/Reset Password in MySQL use mysql; SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘newpassword’); OR ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘newpassword’; OR UPDATE mysql.user SET authentication_string = PASSWORD(‘newpassword’), password_expired = ‘N’ WHERE User = ‘koha_library’ AND Host = ‘localhost’; flush privileges; Mysql(Ubuntu): How to fix Access denied for user ‘root’@’localhost’ sudo mysql -u root use mysql; update user set plugin=’mysql_native_password’ where User=’root’; flush privileges; Koha auto_increment bug […]
Follow the steps to uninstall MySQL Completely from Windows: NOTE: This method will remove/clean all MySQL databases and instances, so keep backup before going through this process, to save your existing databases. 1. First, Run Command Prompt as Administrator and execute the following command to STOP and REMOVE MySQL service. > Net stop MySQL > Sc delete MySQL 2. Now Go to Control Panel >> […]
You can use the command to repair individual tables in MySQL Database. > REPAIR TABLE <table_name> ; Example: REPAIR TABLE EMPLOYEES; (there must be ample space for the mysql files) Total Views: 1355