Resetting Mysql Root Password

  1. Kill the running mysql process
    1. sudo service mysql stop
  2. Start mysql in safe mode and skip grant tables
    1. sudo mysqld_safe --skip-grant-tables --skip-networking &
  3. Log in with root
    1. mysql -u root
  4. Initial privilege flush
    1. flush privileges;
  5. Use mysql database
    1. use mysql;
  6. Set a new mysql root password
    1. update user set authentication_string=PASSWORD("newPassword") where user='root';
  7.  Final privilege flush
    1. flush privileges;
  8. Exit mysql
    1. exit;
  9. Stop mysql service
    1. sudo /etc/init.d/mysql stop
  10. Start mysql service
    1. sudo /etc/init.d/mysql start
  11. Log in to database to test it
    1. mysql -u root -p

Comments

Post a Comment

Popular posts from this blog

Intro to OpenFlow Tutorial with Ryu Controller

Image
Part 1: Design and Setup In this tutorial we are going to use Open vSwitch (OVS) as an OpenFlow switch connected to three hosts. OVS is a software switch running on a compute resource. The other three hosts can only communicate through the OVS switch. The experiment will need (the rspecs for this exercise are provided later in this section): 1 Xen VM with a public IP to run an OpenFlow controller 1 Xen VM to be the OpenFlow switch 3 Xen VMs as hosts   Step 1: Reserve Resources Go to add resources and add RSpec using the URL option a)  Reserve a VM that runs your OpenFlow controller. b) Reserve your network, that includes a VM with OVS installed. Step 2: Configure and Initialize Services Overview: Although OVS is installed and initialized on the host that is meant to act as a software switch, it has not been configured yet. There are two main things that need to be configured: (1) configure your software switch with the interfaces a...
Read more

Snap Assists on Ubuntu 16

Snap Assists on Ubuntu 16 Resource Link sudo apt-get install compizconfig-settings-manager -y Search for application CompizConfig Click WindowManagement Now Change the following Upper Left Corner - Top Left Corner   Upper Right Corner - Top Right Corner   Bottom Left Corner - Bottom Left Corner   Bottom Right Corner - Bottom Right Corner  
Read more