Easy Way to Reset MYSQL Root Password for Linux User

-

 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: 

Comments

Post a Comment

Popular posts from this blog

Install Dspace 6.3 on Windows10

-
Image
Install Dspace 6.3 on Windows10 Pre-Requisite Software: i) Java JDK ii) Apache Maven iii) Apache Ant iv) Apache Tomcat v) PostgreSQL vi) Dspace Step-1: Download Java jdk-8u111-windows-x64.exe from below link. ( Note: If you are new to Oracle, you need to create user account otherwise you can log in to download the software).     https://www.oracle.com/java/technologies/javase/javase8-archive-downloads.html Step-2: Download apache-maven-3.3.9-bin.zip file from below link. https://repo.maven.apache.org/maven2/org/apache/maven/apache-maven/3.3.9/ Step-3: Download apache-ant-1.9.7-bin.zip file from below link.              https://archive.apache.org/dist/ant/binaries/ Step-4: Download apache-tomcat-9.0.0.M13.exe file from below link. https://archive.apache.org/dist/tomcat/tomcat-9/v9.0.0.M13/bin/ Step-5: Download postgresql-9.4.26-1-windows-x64.exe file from below link. https://www.enterprised...
Read more

Koha Plugin : In Out Management System

-
Image
  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 ...
Read more

Create Super Librarian by command line in koha LMS

-
   Create Super Librarian by command line in koha LMS Sometimes Librarians forget the login credentials (User ID and Password) in the koha or the koha system has blocked the patrons account because of several unauthorized (wrong password) attempts to log in. In that case, we can create a new user account with the superuser/admin rights by the command lines. Lets us know how to create a new Super Librarian account. 1. Activate environmental variables sudo su export PERL5LIB="/usr/share/koha/lib"  export KOHA_CONF="/etc/koha/sites/library/koha-conf. xml" 2. Change the super librarian script directory  cd /usr/share/koha/bin/devel/ 3. Executive the following command to create a patron with the super librarian rights ./create_superlibrarian.pl --userid  Librarian  --password  Librarian@12 3 --branchcode  MAIN  --categorycode  STA  --cardnumber  2000 In the above command following details have been used. you can change the details ...
Read more

Total views