Category: MySQL

22/05/2020

How to Install Java, Tomcat, MySQL, phpMyAdmin on Ubuntu 20.04 in GCP/AWS Intance

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 […]

16/03/2019

Install phpMyAdmin on Ubuntu

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 […]

16/03/2019

Reset Password in MySQL | How to fix Access denied for user ‘root’@’localhost’

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 […]

17/07/2018

How to Uninstall MySQL from Windows 7/8/10 Completely

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 >> Programs >> […]