Home编程实践踩坑重置mysql密码遇到问题:mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists

重置mysql密码遇到问题:mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists

2018 年 8 月 30 日

重置mysql密码遇到问题:mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists

问题背景

今天准备在服务器搭建sonar+jenkins做代码审查。跟着操作，需要安装mysql数据库。
结果安装的时候发现已经安装了，问了圈人，也不知道谁装的。不知道有没有用做它途。记得可以改密码的。操作了一番

  1. stop mysql

    systemctl stop mysql

  2. 跳过安全检查

    /usr/bin/mysqld_safe –skip-grant-tables &

呃。报错了。
mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists

解决办法

说没有就创建一个试试。

mkdir -p /var/run/mysqld
chown mysql:mysql /var/run/mysqld

然后再试下

/usr/bin/mysqld_safe –skip-grant-tables &

好了

接着修改密码去。

  1. 登陆

    mysql -u root mysql

  2. 更新密码

    update user set Password = PASSWORD(‘root’) where User =’root’; //5.6
    update user set authentication_string = PASSWORD(‘root’) where User =’root’; //5.7

  3. 刷新权限

    FLUSH PRIVILEGES;

搞定。

Tags:,

Related Posts

About The Author

bjmayor

程序员，码农，php,python,ios,android,go，产品经理，创业。

10 Comments
  1. Randlob

    Alcohol Cephalexin Toddler Amoxicillin Hives Venta De Cialis Professional [url=http://realviaonline.com]generic cialis from india[/url] Priligy Bugiardino Propecia Ayuda Stendra 100mg Drugs

  2. KelCysfuh

    Amoxicillin For Ear Infection Zithromax Before Ivf Buy Valacyclovir Dosage For Shingles [url=http://4nrxuk.com]generic viagra[/url] Propecia Ville Canadian Generica Viagra Amoxicillin For Pets

  3. Randlob

    Viagra Pille Mann Allergic To Keflex Kamagra Suppliers [url=http://genericvia.com]viagra[/url] Secure Zentel 400mg Ups In Canada Pharmacy Buy 2.5mg Cialis Online

  4. KelCysfuh

    Buy Viagra In Person [url=http://ciali20mg.com]cialis prices[/url] Daly Cialis Canada

  5. Randlob

    Zithromax 3 Day Dose Cialis 20mg 12 Stuck Preisvergleich [url=http://viaapill.com]viagra[/url] Cialis Costi Buy Alli In Canada

  6. KelCysfuh

    Cialis 10 Mg Preis Priligy Tablets [url=http://gaprap.com]viagra prescription[/url] Tamsulosin For Sale Cheap Kamagra Oral Jelly Cailas

  7. Randlob

    Erythromycin No Prescription [url=http://mpphr.com]priligy en pharmacie en france[/url] Cialis Comprar Venta

  8. KelCysfuh

    Order Amoxicillin Without Prescription Amoxil Chew Tabs Recall Pill price levitra [url=http://cure-rx.com]online pharmacy[/url] Tadalafil viagra levitra Viagra Levitra Ou Cialis Paroxetine 20mg No Prescription

  9. Randlob

    Actualite Propecia No Script Levitra Where Can I Buy Dutasteride Quick Shipping [url=http://4nrxuk.com]ou acheter du viagra paris[/url] discount free shipping cheapeast isotretinoin worldwide amex

  10. KelCysfuh

    Buy Clomid And Nolvadex Online Amoxicillin Clav And Dosage [url=http://curerxshop.com]order cialis online[/url] Viagra 100 Forum