{"id":5552,"date":"2018-05-27T07:43:22","date_gmt":"2018-05-27T07:43:22","guid":{"rendered":"https:\/\/www.buymobile.com.bd\/blog\/?p=5552"},"modified":"2018-05-27T07:43:22","modified_gmt":"2018-05-27T07:43:22","slug":"resetting-adminer-database-password-with-ovh","status":"publish","type":"post","link":"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/","title":{"rendered":"Resetting Database Password of VPS OVH"},"content":{"rendered":"

Last tutorial discuss about Resetting VPS Root Password. Now in this tutorial showing how to resetting MySQL Password or MariaDB. While updating the Adminer MySQl Password, Forgetting password reaalllyyy so much irritating part while working on it. And It happens to the most of us. If you forget or lose the root password to your MySQL or MariaDB database, you can still access and reset the password if you have access to the server and a sudo-enabled user account.<\/p>\n

In this article I am going to cover how to reset the root password for older and newer versions of MySQL and MariaDB<\/p>\n

At First run the PuTTY and follow the bellow command carefully<\/p>\n

Step 1<\/u> \u2014 First Identify the Running Database Version<\/h3>\n

Depending on the database used and its version, you’ll need to use different commands to recover the root password. Here is the command, You can check your version with the following command:<\/p>\n

mysql \u2013version<\/em><\/p>\n

Output for \u00a0MySQL:<\/strong><\/p>\n

mysql\u00a0 Ver 14.14 Distrib 5.7.16, for Linux (x86_64) using\u00a0 EditLine wrapper\u00a0<\/em><\/p>\n

Output for MariaDB:<\/strong><\/p>\n

mysql\u00a0 Ver 15.1 Distrib 5.5.52-MariaDB, for Linux (x86_64) using readline 5.1<\/em><\/p>\n

 <\/p>\n

Step 2<\/u> \u2014 Stopping the Database Server<\/h3>\n

To change the root password, first you have to shut down the database server beforehand. You can do that for MySQL with:<\/p>\n

sudo systemctl stop mysql<\/em><\/p>\n

And for MariaDB wtih:<\/strong><\/p>\n

sudo systemctl stop mariadb<\/em><\/p>\n

 <\/p>\n

Step 3<\/u> \u2014 Restarting the Database Server<\/h3>\n

If you run MySQL and MariaDB without loading information about user privileges, it will allow you to access the database command line with root privileges without providing a password. This will allow you to gain access to the database without knowing it.<\/p>\n

To do this, you need to stop the database from loading the grant tables, which store user privilege information. Because this is a bit of a security risk, you should also skip networking as well to prevent other clients from connecting.<\/p>\n

Start the database without loading the grant tables or enabling networking:<\/p>\n

sudo mysqld_safe –skip-grant-tables –skip-networking &<\/em><\/p>\n

 <\/p>\n

here The ampersand(&) at the end of this command will make this process run in the background so you can continue to use your terminal.<\/p>\n

For me when I run this command it shows \u201cmysqld_safe Directory ‘\/var\/run\/mysqld’ for UNIX socket file don’t exists<\/strong>\u201d. In that case you just need to run those command and the \u201cmysqld\u201d directory will automatically create.<\/p>\n

 <\/p>\n

mkdir -p \/var\/run\/mysqld<\/em><\/p>\n

chown mysql:mysql \/var\/run\/mysqld<\/em><\/p>\n

Now you can connect to the database as the root user, which will not asked for a password. Now use this Command:<\/p>\n

mysql -u root<\/em><\/p>\n

Now this MySQL Prompt Will Promt<\/strong><\/p>\n

Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement<\/em><\/p>\n

For MariaDB<\/strong><\/p>\n

Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/em><\/p>\n

MariaDB [(none)]><\/em><\/p>\n

Now that you have root access, you can change the root password.<\/p>\n

Step 4<\/u> \u2014 Changing the Root Password<\/h3>\n

For modern versions of MySQL One simple way to change the root password is using the ALTER USER command. However, this command won’t work right now because the grant tables aren’t loaded.<\/p>\n

Let’s tell the database server to reload the grant tables by issuing the FLUSH PRIVILEGES command.<\/p>\n

FLUSH PRIVILEGES;<\/em><\/p>\n

 <\/p>\n

Now we can actually change the root password.<\/strong><\/p>\n

For MySQL 5.7.6 and newer as well as MariaDB 10.1.20 and newer, use the following command<\/em><\/p>\n

ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘new_password’;<\/em><\/p>\n

For\u00a0MySQL 5.7.5 and older<\/strong>\u00a0as well as\u00a0MariaDB 10.1.20<\/strong>\u00a0and older, use:<\/p>\n

SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘new_password’);<\/em><\/p>\n

 <\/p>\n

Make sure to replace new_password with your new password of choice.<\/p>\n

But sometimes the ALTER USER command does not work. Then it’s usually indicative of a bigger problem. However, you can try UPDATE … SET to reset the root password instead.<\/p>\n

 <\/p>\n

UPDATE mysql.user SET authentication_string = PASSWORD(‘new_password’) WHERE User = ‘root’ AND Host = ‘localhost’;<\/em><\/p>\n

The password has been changed, so you can now stop the manual instance of the database server and restart it as it was before.<\/p>\n

Step 5<\/u> \u2014 Restart the Database Server Normally<\/h3>\n

First, stop the instance of the database server. For stopping the instance Database Server run the command that run in Step 2. \u00a0This command searches for the PID, or process ID, of MySQL or MariaDB process and sends SIGTERM to tell it to exit smoothly after performing clean-up operations. You can learn more in this Linux process management tutorial.<\/p>\n

sudo systemctl stop mysql<\/em><\/p>\n

Then run below command, For MySQL use:<\/strong><\/p>\n

sudo kill cat \/var\/run\/mysqld\/mysqld.pid<\/code><\/em><\/p>\n

For MariaDB, use:<\/strong><\/p>\n

sudo kill \/var\/run\/mariadb\/mariadb.pid<\/code><\/em><\/p>\n

Then, restart the service using\u00a0systemctl<\/strong>.<\/p>\n

For MySQL, use:<\/strong><\/p>\n

sudo systemctl start mysql<\/em><\/p>\n

For MariaDB, use:<\/strong><\/p>\n

sudo systemctl start mariadb<\/em><\/p>\n

Now you can confirm that the new password has been applied correctly by running:<\/p>\n

mysql -u root \u2013p<\/strong><\/p>\n

After running this command the password will reset automatically. You just need to check. Hope so it will work Perfectly..<\/p>\n

Here is the overall Screenshot to clear the idea<\/p>\n

\"database\"<\/p>\n","protected":false},"excerpt":{"rendered":"

Last tutorial discuss about Resetting VPS Root Password. Now in this tutorial showing how to resetting MySQL Password or MariaDB. While updating the Adminer MySQl Password, Forgetting password reaalllyyy so much irritating part while working on it. And It happens to the most of us. If you forget or lose the root password to your … Continue reading “Resetting Database Password of VPS OVH”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":5553,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[14549],"tags":[],"jetpack_publicize_connections":[],"yoast_head":"\nResetting Database Password of VPS OVH<\/title>\n<meta name=\"description\" content=\"Resetting Database Password of VPS OVH.While updating the Adminer MySQl Password, Forgetting password reaalllyyy so much irritating part while working on it. And It happens to the most of us. If you forget or lose the root password to your MySQL or MariaDB database, you can still access and reset the password if you have access to the server and a sudo-enabled user account.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Resetting Database Password of VPS OVH\" \/>\n<meta property=\"og:description\" content=\"Resetting Database Password of VPS OVH.While updating the Adminer MySQl Password, Forgetting password reaalllyyy so much irritating part while working on it. And It happens to the most of us. If you forget or lose the root password to your MySQL or MariaDB database, you can still access and reset the password if you have access to the server and a sudo-enabled user account.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/\" \/>\n<meta property=\"og:site_name\" content=\"buy mobile only mobile technology\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/buymobilebd\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-27T07:43:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.buymobile.com.bd\/blog\/wp-content\/uploads\/2018\/05\/mysql-mariadb.png?fit=500%2C285&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"285\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"blogbd\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@buymobilebd\" \/>\n<meta name=\"twitter:site\" content=\"@buymobilebd\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"blogbd\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/\"},\"author\":{\"name\":\"blogbd\",\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/#\/schema\/person\/74f68ec51f1085dca1bb7c038973c793\"},\"headline\":\"Resetting Database Password of VPS OVH\",\"datePublished\":\"2018-05-27T07:43:22+00:00\",\"dateModified\":\"2018-05-27T07:43:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/\"},\"wordCount\":826,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/#organization\"},\"articleSection\":[\"Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/\",\"url\":\"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/\",\"name\":\"Resetting Database Password of VPS OVH\",\"isPartOf\":{\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/#website\"},\"datePublished\":\"2018-05-27T07:43:22+00:00\",\"dateModified\":\"2018-05-27T07:43:22+00:00\",\"description\":\"Resetting Database Password of VPS OVH.While updating the Adminer MySQl Password, Forgetting password reaalllyyy so much irritating part while working on it. And It happens to the most of us. If you forget or lose the root password to your MySQL or MariaDB database, you can still access and reset the password if you have access to the server and a sudo-enabled user account.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.buymobile.com.bd\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resetting Database Password of VPS OVH\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/#website\",\"url\":\"https:\/\/www.buymobile.com.bd\/blog\/\",\"name\":\"buy mobile only mobile technology\",\"description\":\"online shopping site bangladesh\",\"publisher\":{\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.buymobile.com.bd\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/#organization\",\"name\":\"buymobile\",\"url\":\"https:\/\/www.buymobile.com.bd\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.buymobile.com.bd\/blog\/wp-content\/uploads\/2016\/11\/cropped-buymobile.png?fit=240%2C47&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.buymobile.com.bd\/blog\/wp-content\/uploads\/2016\/11\/cropped-buymobile.png?fit=240%2C47&ssl=1\",\"width\":240,\"height\":47,\"caption\":\"buymobile\"},\"image\":{\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.instagram.com\/buymobilebd\/\",\"https:\/\/www.linkedin.com\/company\/buymobile\",\"https:\/\/www.pinterest.com\/buymobilebd\/\",\"https:\/\/www.youtube.com\/c\/BuymobileBdOnline\",\"https:\/\/www.facebook.com\/buymobilebd\/\",\"https:\/\/twitter.com\/buymobilebd\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/#\/schema\/person\/74f68ec51f1085dca1bb7c038973c793\",\"name\":\"blogbd\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.buymobile.com.bd\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/db6526c1076b28352722e04f4a391f14?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/db6526c1076b28352722e04f4a391f14?s=96&d=mm&r=g\",\"caption\":\"blogbd\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Resetting Database Password of VPS OVH","description":"Resetting Database Password of VPS OVH.While updating the Adminer MySQl Password, Forgetting password reaalllyyy so much irritating part while working on it. And It happens to the most of us. If you forget or lose the root password to your MySQL or MariaDB database, you can still access and reset the password if you have access to the server and a sudo-enabled user account.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/","og_locale":"en_US","og_type":"article","og_title":"Resetting Database Password of VPS OVH","og_description":"Resetting Database Password of VPS OVH.While updating the Adminer MySQl Password, Forgetting password reaalllyyy so much irritating part while working on it. And It happens to the most of us. If you forget or lose the root password to your MySQL or MariaDB database, you can still access and reset the password if you have access to the server and a sudo-enabled user account.","og_url":"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/","og_site_name":"buy mobile only mobile technology","article_publisher":"https:\/\/www.facebook.com\/buymobilebd\/","article_published_time":"2018-05-27T07:43:22+00:00","og_image":[{"width":500,"height":285,"url":"https:\/\/i0.wp.com\/www.buymobile.com.bd\/blog\/wp-content\/uploads\/2018\/05\/mysql-mariadb.png?fit=500%2C285&ssl=1","type":"image\/png"}],"author":"blogbd","twitter_card":"summary_large_image","twitter_creator":"@buymobilebd","twitter_site":"@buymobilebd","twitter_misc":{"Written by":"blogbd","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/#article","isPartOf":{"@id":"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/"},"author":{"name":"blogbd","@id":"https:\/\/www.buymobile.com.bd\/blog\/#\/schema\/person\/74f68ec51f1085dca1bb7c038973c793"},"headline":"Resetting Database Password of VPS OVH","datePublished":"2018-05-27T07:43:22+00:00","dateModified":"2018-05-27T07:43:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/"},"wordCount":826,"commentCount":0,"publisher":{"@id":"https:\/\/www.buymobile.com.bd\/blog\/#organization"},"articleSection":["Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/","url":"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/","name":"Resetting Database Password of VPS OVH","isPartOf":{"@id":"https:\/\/www.buymobile.com.bd\/blog\/#website"},"datePublished":"2018-05-27T07:43:22+00:00","dateModified":"2018-05-27T07:43:22+00:00","description":"Resetting Database Password of VPS OVH.While updating the Adminer MySQl Password, Forgetting password reaalllyyy so much irritating part while working on it. And It happens to the most of us. If you forget or lose the root password to your MySQL or MariaDB database, you can still access and reset the password if you have access to the server and a sudo-enabled user account.","breadcrumb":{"@id":"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-adminer-database-password-with-ovh\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.buymobile.com.bd\/blog\/"},{"@type":"ListItem","position":2,"name":"Resetting Database Password of VPS OVH"}]},{"@type":"WebSite","@id":"https:\/\/www.buymobile.com.bd\/blog\/#website","url":"https:\/\/www.buymobile.com.bd\/blog\/","name":"buy mobile only mobile technology","description":"online shopping site bangladesh","publisher":{"@id":"https:\/\/www.buymobile.com.bd\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.buymobile.com.bd\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.buymobile.com.bd\/blog\/#organization","name":"buymobile","url":"https:\/\/www.buymobile.com.bd\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.buymobile.com.bd\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/www.buymobile.com.bd\/blog\/wp-content\/uploads\/2016\/11\/cropped-buymobile.png?fit=240%2C47&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.buymobile.com.bd\/blog\/wp-content\/uploads\/2016\/11\/cropped-buymobile.png?fit=240%2C47&ssl=1","width":240,"height":47,"caption":"buymobile"},"image":{"@id":"https:\/\/www.buymobile.com.bd\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.instagram.com\/buymobilebd\/","https:\/\/www.linkedin.com\/company\/buymobile","https:\/\/www.pinterest.com\/buymobilebd\/","https:\/\/www.youtube.com\/c\/BuymobileBdOnline","https:\/\/www.facebook.com\/buymobilebd\/","https:\/\/twitter.com\/buymobilebd"]},{"@type":"Person","@id":"https:\/\/www.buymobile.com.bd\/blog\/#\/schema\/person\/74f68ec51f1085dca1bb7c038973c793","name":"blogbd","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.buymobile.com.bd\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/db6526c1076b28352722e04f4a391f14?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/db6526c1076b28352722e04f4a391f14?s=96&d=mm&r=g","caption":"blogbd"}}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.buymobile.com.bd\/blog\/wp-content\/uploads\/2018\/05\/mysql-mariadb.png?fit=500%2C285&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p8FaMD-1ry","jetpack-related-posts":[{"id":5564,"url":"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/mysqld-safe-directory-var-run-mysqld-unix-socket-file-dont-exists-mean\/","url_meta":{"origin":5552,"position":0},"title":"mysqld_safe Directory ‘\/var\/run\/mysqld’ for UNIX socket file don’t exists what this Mean?","date":"May 27, 2018","format":false,"excerpt":"While Resetting the Database Password of VPS this message shows when running command. While restarting the database server you need to run this command \u00a0 sudo mysqld_safe --skip-grant-tables --skip-networking & here The ampersand(&) at the end of this command will make this process run in the background so you can\u2026","rel":"","context":"In "Tutorial"","img":{"alt_text":"mysql","src":"https:\/\/i0.wp.com\/www.buymobile.com.bd\/blog\/wp-content\/uploads\/2018\/05\/mysql-reset.jpg?fit=700%2C350&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":5548,"url":"https:\/\/www.buymobile.com.bd\/blog\/2018\/05\/27\/resetting-vps-password-with-ovh\/","url_meta":{"origin":5552,"position":1},"title":"Resetting VPS\u00a0Password with OVH","date":"May 27, 2018","format":false,"excerpt":"In this article explaining the useful steps to Resetting VPS\u00a0 Password with OVH Step 1: First need to open the SSH session on your VPS. In Windows, the SSH client does not exist by default so you will need an additional software. The Additional Software is PuTTY. That can be\u2026","rel":"","context":"In "Tutorial"","img":{"alt_text":"Resetting VPS\u00a0Password with OVH","src":"https:\/\/i0.wp.com\/www.buymobile.com.bd\/blog\/wp-content\/uploads\/2018\/05\/ovh.jpg?fit=700%2C350&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1006,"url":"https:\/\/www.buymobile.com.bd\/blog\/2017\/02\/05\/stop-someone-from-using-my-wifi\/","url_meta":{"origin":5552,"position":2},"title":"Stop someone from using my wifi","date":"February 5, 2017","format":false,"excerpt":"\u0987\u09a8\u09cd\u099f\u09be\u09b0\u09a8\u09c7\u099f \u09b8\u0982\u09af\u09cb\u0997\u09c7\u09b0 \u09aa\u09cd\u09b0\u09a5\u09ae \u09a6\u09bf\u0995\u09c7 \u09b8\u09cd\u09aa\u09c0\u09a1 \u09ad\u09be\u09b2 \u09a5\u09be\u0995\u09b2\u09c7\u0993, \u0995\u09bf\u099b\u09c1\u09a6\u09bf\u09a8 \u09aa\u09b0 \u09a5\u09c7\u0995\u09c7 \u09a6\u09c7\u0996\u09be \u09af\u09be\u09df \u09b8\u09cd\u09aa\u09c0\u09a1 \u0986\u0997\u09c7\u09b0 \u09ae\u09a4 \u09aa\u09be\u0993\u09df\u09be \u09af\u09be\u099a\u09cd\u099b\u09c7 \u09a8\u09be\u0964 \u098f\u09b0 \u0995\u09be\u09b0\u09a8 \u09b9\u099a\u09cd\u099b\u09c7, \u0986\u09aa\u09a8\u09bf \u099b\u09be\u09dc\u09be\u0993 \u0985\u09a8\u09cd\u09af\u09be\u09a8\u09cd\u09af\u09b0\u09be \u0986\u09aa\u09a8\u09be\u09b0 Wifi \u0995\u09be\u09a8\u09c7\u0995\u09b6\u09a8 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u099b\u09c7\u0964 \u098f\u099f\u09be \u0986\u09aa\u09a8\u09be\u09b0 \u0985\u09a8\u09b2\u09be\u0987\u09a8 \u09a8\u09bf\u09b0\u09be\u09aa\u09a4\u09cd\u09a4\u09be\u09b0 \u099c\u09a8\u09cd\u09af\u0993 \u099d\u09c1\u0981\u0995\u09bf\u09aa\u09c2\u09b0\u09cd\u09a8\u0964 \u098f\u0987 \u09a7\u09b0\u09a8\u09c7\u09b0 \u09b8\u09ae\u09b8\u09cd\u09af\u09be\u09df \u0986\u09aa\u09a8\u09be\u0995\u09c7 \u0995\u09df\u09c7\u0995\u099f\u09bf \u099c\u09bf\u09a8\u09bf\u09b8 \u0996\u09c7\u09df\u09be\u09b2 \u09b0\u09be\u0996\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964 \u0986\u09b0 \u098f\u09b0 \u099c\u09a8\u09cd\u09af \u0986\u09aa\u09a8\u09be\u0995\u09c7 \u0986\u0997\u09c7 \u09a5\u09c7\u0995\u09c7\u0987\u2026","rel":"","context":"In "tips and tricks"","img":{"alt_text":"wifi | buymobile","src":"https:\/\/i0.wp.com\/www.buymobile.com.bd\/blog\/wp-content\/uploads\/2017\/02\/wifi.jpg?fit=773%2C340&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":7185,"url":"https:\/\/www.buymobile.com.bd\/blog\/2019\/05\/06\/walton-olvio-ml15-price-bangladesh\/","url_meta":{"origin":5552,"position":3},"title":"Walton Olvio ML15 Price in Bangladesh","date":"May 6, 2019","format":false,"excerpt":"The New Olvio ML15 Upcoming Walton Features Phone. Olvio ML15\u00a0Price in Bangladesh Not Confirm Yet. Walton Olvio ML15 Come With some special Feature like that\u00a0Big Torch, Keypad Notification Light, Privacy Protection with password keypad lock, Facebook.\u00a0Olvio ML15 2.4 inch QVGA Display with\u00a0320*240 pixels regulation.\u00a01000mAh Li-ion Battery. Walton Olvio ML15 Specification\u2026","rel":"","context":"In "Walton"","img":{"alt_text":"Walton Olvio ML15 Price in Bangladesh","src":"https:\/\/i0.wp.com\/www.buymobile.com.bd\/blog\/wp-content\/uploads\/2019\/05\/olivo.jpg?fit=400%2C400&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":244,"url":"https:\/\/www.buymobile.com.bd\/blog\/2016\/12\/05\/specification-oneplus-3t\/","url_meta":{"origin":5552,"position":4},"title":"Specification of OnePlus 3T","date":"December 5, 2016","format":false,"excerpt":"The device OnePlus 3T has design similar to OnePlus 3 and the front of those phones partially visible in a mirror.OnePlus company has managed to make a mark on the smartphone industry.OnePlus 3T comes with version 3.5 but marshmallow \u00a06.0.1 instead of this device. In this smartphone has OxygenOS sees\u2026","rel":"","context":"In "One Plus"","img":{"alt_text":"OnePlus 3T","src":"https:\/\/i0.wp.com\/www.buymobile.com.bd\/blog\/wp-content\/uploads\/2016\/12\/OnePlus_3T-1.jpg?fit=800%2C800&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":4922,"url":"https:\/\/www.buymobile.com.bd\/blog\/2018\/02\/27\/full-specification-walton-olvio-mm16-price-bangladesh\/","url_meta":{"origin":5552,"position":5},"title":"Full Specification Walton Olvio MM16 Price Bangladesh","date":"February 27, 2018","format":false,"excerpt":"Walton Olvio MM16 specification said that it comes with QVGA display and the size of display is 2.4 inches. Olvio MM16 included 2 GB RAM and 16 GB ROM. 1800 mAh is the battery capacity of this Walton phone. Walton Olvio MM16 price In Bangladesh Mobile Phone Walton Olvio MM16\u2026","rel":"","context":"In "Walton"","img":{"alt_text":"Walton Olvio MM16 Price Bangladesh","src":"https:\/\/i0.wp.com\/www.buymobile.com.bd\/blog\/wp-content\/uploads\/2018\/02\/walton-olvio-mm16.jpg?fit=700%2C350&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.buymobile.com.bd\/blog\/wp-json\/wp\/v2\/posts\/5552"}],"collection":[{"href":"https:\/\/www.buymobile.com.bd\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.buymobile.com.bd\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.buymobile.com.bd\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.buymobile.com.bd\/blog\/wp-json\/wp\/v2\/comments?post=5552"}],"version-history":[{"count":6,"href":"https:\/\/www.buymobile.com.bd\/blog\/wp-json\/wp\/v2\/posts\/5552\/revisions"}],"predecessor-version":[{"id":5569,"href":"https:\/\/www.buymobile.com.bd\/blog\/wp-json\/wp\/v2\/posts\/5552\/revisions\/5569"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.buymobile.com.bd\/blog\/wp-json\/wp\/v2\/media\/5553"}],"wp:attachment":[{"href":"https:\/\/www.buymobile.com.bd\/blog\/wp-json\/wp\/v2\/media?parent=5552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.buymobile.com.bd\/blog\/wp-json\/wp\/v2\/categories?post=5552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.buymobile.com.bd\/blog\/wp-json\/wp\/v2\/tags?post=5552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}