Set / Change / Reset the MySQL root password on Ubuntu Linux




1. Stop the MySQL Server.

            
         sudo /etc/init.d/mysql stop


2.  Stop the MySQL Server.


         sudo /etc/init.d/mysql stop


3.   Start the mysqld configuration.     


         sudo mysqld --skip-grant-tables &

4.  Login to MySQL as root.

         mysql -u root mysql

5.  Replace YOUR NEWP ASSWORD with your new password!

UPDATE user SET Password=PASSWORD('your password') WHERE User='root'; FLUSH PRIVILEGES; exit;



Note: This method is not regarded as the securest way of resetting the password. However it works.

Comments

Post a Comment

Popular posts from this blog

how to customize dashboard in active admin gem in rails 4

Installation Active Admin is a Ruby Gem. gem 'activeadmin' More accurately, it's a  Rails Engine  that can be injected into your existing Ruby on Rails application. Setting up Active Admin After installing the gem, you need to run the generator. By default we use Devise, and the generator creates an AdminUser  model. If you want to create a different model (or modify an existing one for use with Devise) you can pass it as an argument. If you want to skip Devise configuration entirely, you can pass  --skip-users . rails g active_admin:install # creates the AdminUser class rails g active_admin:install User # creates / edits the class for use with Devise rails g active_admin:install --skip-users # skips Devise install The generator adds these core files, among others: app/admin/dashboard.rb app/assets/javascripts/active_admin.js.coffee app/assets/stylesheets/active_admin.css.scss config/initializers/active_admin.rb Now, migrate
Read more

fibonacci series in Ruby

The Fibonacci Sequence is the series of numbers: 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, ... The next number is found by adding up the two numbers before it. The 2 is found by adding the two numbers before it (1+1) Similarly, the 3 is found by adding the two numbers before it (1+2), And the 5 is (2+3), and so on! Fibonacci series in Ruby class Fibonacci   def series     puts "Enter the Fibonacci value"     n=gets.to_i     f1=0     f2=1     f3=0         while f3<n do            f3=f1+f2           puts f3           f1=f2           f2=f3          end     end end obj1=Fibonacci.new obj1.series
Read more

Write a program to Sum of Digits in JQuery?

Write a program to accept a no. from user and display Sum of Digits. (example: 214= 2+1+4 =  7) < !DOCTYPE html> <html> <head>   <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" type="text/css" href="style.css"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js"></script>   <script src="http://ajax.aspnetcdn.com/ajax/jquery.validate/1.9/jquery.validate.min.js"></script>    <script type="text/javascript"> $(document).ready(function(){ $("#btn").click(function(){ var x = 0; var y = parseInt($("#sum").val()); while(y>0) { x = x + y % 10; y = Math.floor(y/10); } alert("sum of digits " + x); }); }); </script> </head> <body> <div> <h2>Su
Read more