THE IT IDEAS

  • Home

Thursday, 10 April 2014

How to edit fstab file in Read-Only Mode

 THE IT IDEAS     20:52     fstab, linux, mount, repair filesystem   

When you got Repair Filesystem error and you wants to edit /etc/fstab file in Read-only mode then follow below mentioned command to edit file 

#mount -w -o remount/
#vi /etc/fstab

Make changes which you need and save and restart once.

Its done Enjoy !!!!!:)
Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg

How to reset root password in MySQL

 THE IT IDEAS     20:44     mysql, password, reset password   

1 )  First we have to stop MySQL service.

:: Command to Stop MySQL :: 
For Ubuntu & Debian : "/etc/init.d/mysql stop"
& CentOS, Fedora, and RHEL : "/etc/init.d/mysqld stop"

2 ) Now we need to start MySQL service in safe mode, in safe mode MySQL will not load user privileges table. 
:: Command for safe mode :: 
"mysqld safe --skip-grant-tables"

Once you Execute above mentioned command mysql will start in safe mode.

Now, Follow below mentioned Commands to reset root password.

"mysql -u root"   (Login into MySQL)  

"use mysql;"   (for use mysql database in MySQL)

"update user set password=PASSWORD ("yournewpassword") where User='root';"  (Command for reset Password)

"flush privileges;"   (to save configuration)

"quit"   (for exit from MySQL) 

Just simply Execute command for stop and start 

"/etc/init.d/mysql stop"    (to stop MySQL)

"/etc/init.d/mysql start"   (to start MySQL)

Now, we need to check mysql password with login into MySQL.

"mysql -u root -p"

You will be prompted for your new password.


Its done Enjoy !!!! :)


Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Newer Posts Older Posts Home

Like Us !!!

Recent Posts

Blog Archive

  • ►  2016 (1)
    • ►  April (1)
  • ►  2015 (12)
    • ►  August (1)
    • ►  May (2)
    • ►  April (8)
    • ►  March (1)
  • ▼  2014 (23)
    • ►  December (8)
    • ►  November (12)
    • ▼  April (2)
      • How to edit fstab file in Read-Only Mode
      • How to reset root password in MySQL
    • ►  March (1)
  • ►  2013 (7)
    • ►  December (1)
    • ►  April (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (3)
  • ►  2012 (15)
    • ►  December (6)
    • ►  November (9)

Categories

apache2 EC2 error mysql php ubuntu aws aws rds browser github installation linux mount s3 AWS Bucket CentOS Computer DocumentRoot change How to Benchmarking Webserver IP LAMP Restart Computer SCP command SQL SERVER XRDP administrator amazon rds backup basic commands chat command line disable download drupal ec2.chroot environment external storage device fstab functions geoip gmail google home page iis instance internet java mod rewrite mongodb multiple login network password one password php5 php5-fpm php7 private browsing python repair filesystem repo reset password rhel sa password same computer script sftp share skype ssh tomcat ubuntu 16.04 ubuntu16 visudo windows 8 youtube
JobsMagBlogJobsMag.InThingsGuide

Popular Posts

  • Create SFTP User with chroot in AWS EC2
    Create User with below command #adduser --shell=/bin/false theitideas Provide permission of home directory #chown root:theitideas /ho...
  • Install apache2 Webserver, php5 and php module with script for beginner
    Install apache2 Webserver with script for beginner Find the script to install apache2 Webserver and php5 with php modules like cgi php5-m...
  • Use PHP5-FPM with Apache 2 on Ubuntu 14.04
    Install Apache by following command     #sudo apt-get update     #sudo apt-get install apache2-mpm-event To use PHP5-FPM with Apache, we ne...

Copyright © THE IT IDEAS | Powered by Blogger