{"id":155,"date":"2016-11-01T10:40:58","date_gmt":"2016-11-01T10:40:58","guid":{"rendered":"http:\/\/siteblog.tuc.gr\/emmanuel\/?p=155"},"modified":"2016-11-02T09:47:45","modified_gmt":"2016-11-02T09:47:45","slug":"reset-mysql-root-password","status":"publish","type":"post","link":"https:\/\/siteblog.tuc.gr\/emmanuel\/reset-mysql-root-password\/","title":{"rendered":"Reset MySQL root password"},"content":{"rendered":"

How can I reset my MySQL password?<\/strong>
\nFollowing this procedure, you will disable access control on the MySQL server. All connexions will have a root access. It is a good thing to unplug your server from the network or at least disable remote access.<\/p>\n

To reset your mysqld password just follow these instructions :<\/p>\n

    \n
  1. Stop the mysql demon process using this command :
    \nsudo \/etc\/init.d\/mysql stop<\/span><\/li>\n
  2. \u00a0Start the mysqld demon process using the –skip-grant-tables option with this command
    \nsudo \/usr\/sbin\/mysqld –skip-grant-tables –skip-networking &<\/span><\/li>\n<\/ol>\n

    Because you are not checking user privs at this point, it’s safest to disable networking. In Dapper, \/usr\/bin\/mysqld… did not work. However, mysqld –skip-grant-tables did.<\/p>\n

      \n
    1. start the mysql client process using this command
      \nmysql -u root<\/span><\/li>\n
    2. from the mysql prompt execute this command to be able to change any password
      \nFLUSH PRIVILEGES;<\/span><\/li>\n
    3. Then reset\/update your password
      \nSET PASSWORD FOR root@’localhost’ = PASSWORD(‘password’);<\/span><\/li>\n
    4. If you have a mysql root account that can connect from everywhere, you should also do:
      \nUPDATE mysql.user SET Password=PASSWORD(‘newpwd’) WHERE User=’root’;<\/span><\/li>\n
    5. Alternate Method:
      \nUSE mysql<\/span>
      \n UPDATE user SET Password = PASSWORD(‘newpwd’)<\/span>
      \n WHERE Host = ‘localhost’ AND User = ‘root’;<\/span><\/li>\n
    6. And if you have a root account that can access from everywhere:
      \nUSE mysql<\/span>
      \n UPDATE user SET Password = PASSWORD(‘newpwd’)<\/span>
      \n WHERE Host = ‘%’ AND User = ‘root’;<\/span><\/li>\n<\/ol>\n

      For either method, once have received a message indicating a successful query (one or more rows affected), flush privileges:<\/p>\n

      FLUSH PRIVILEGES;<\/span>
      \nThen stop the mysqld process and relaunch it with the classical way:<\/p>\n

      sudo \/etc\/init.d\/mysql stop<\/span>
      \n sudo \/etc\/init.d\/mysql start<\/span>
      \nWhen you have completed all this steps ,you can easily access to your mysql server with the password you have set in the step before. An easy way to have a full control of your mysql server is phpmyadmin (www.phpmyadmin.net), software made in php that can give you a web interface that can be very usefull to people that havent got a lot of confidence with bash .To install phpmyadmin on you server you will need to have 4 things:<\/p>\n

        \n
      1. web server apache<\/li>\n
      2. php<\/li>\n
      3. mysql server\/mysql client installed<\/li>\n
      4. php_mysql support for apache<\/li>\n<\/ol>\n

        All packages can be found browsing synaptic.<\/p>\n

        \n

        Another way, purge<\/strong>
        \nI also had some problems with mysql just not accepting my password. I tried the other way as well and it just ended up being difficult. I had not been able to use mysql so it was empty anyway. If this is also your case you may opt for the PURGE way. This removes every file related to mysql. Depending on your installation the packages might be diffrent, mysql-server in 6.10 is called mysql-server-5.0 as an example.<\/p>\n

        USE THIS AS A LAST RESORT METHOD, YOU WILL LOSE ALL YOUR MYSQL DATA<\/p>\n

        sudo apt-get –purge remove mysql-server mysql-common mysql-client<\/span><\/p>\n

        sudo apt-get install mysql-server mysql-common mysql-client<\/span>
        \nIn the next step be sure to chance the your-new-password with the password you want!<\/p>\n

        mysqladmin -u root password your-new-password<\/span>
        \n sudo \/etc\/init.d\/mysql restart<\/span><\/p>\n

        mysql -u root -p<\/span>
        \nYou should now be logged in as root. Make sure to notedown your password! Thanks to Illuvator for posting this method in the ubuntu forum.<\/p>\n

        The Easiest Method<\/p>\n

        sudo dpkg-reconfigure mysql-server-N.N<\/span><\/p>\n

        \n

        https:\/\/help.ubuntu.com\/community\/MysqlPasswordReset<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

        How can I reset my MySQL password? Following this procedure, you will disable access control on the MySQL server. All connexions will have a root access. It is a good thing to unplug your server from the network or at least disable remote access. To reset your mysqld password just follow these instructions : Stop […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-155","post","type-post","status-publish","format-standard","hentry","category-php-mysql-apache"],"_links":{"self":[{"href":"https:\/\/siteblog.tuc.gr\/emmanuel\/wp-json\/wp\/v2\/posts\/155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/siteblog.tuc.gr\/emmanuel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/siteblog.tuc.gr\/emmanuel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/siteblog.tuc.gr\/emmanuel\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/siteblog.tuc.gr\/emmanuel\/wp-json\/wp\/v2\/comments?post=155"}],"version-history":[{"count":3,"href":"https:\/\/siteblog.tuc.gr\/emmanuel\/wp-json\/wp\/v2\/posts\/155\/revisions"}],"predecessor-version":[{"id":159,"href":"https:\/\/siteblog.tuc.gr\/emmanuel\/wp-json\/wp\/v2\/posts\/155\/revisions\/159"}],"wp:attachment":[{"href":"https:\/\/siteblog.tuc.gr\/emmanuel\/wp-json\/wp\/v2\/media?parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/siteblog.tuc.gr\/emmanuel\/wp-json\/wp\/v2\/categories?post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/siteblog.tuc.gr\/emmanuel\/wp-json\/wp\/v2\/tags?post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}