› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
yijiecaoming
V2EX  ›  MySQL

Mysql 登录,修改密码问题?

  •  
  •   yijiecaoming · Jan 1, 2016 · 3296 views
    This topic created in 3945 days ago, the information mentioned may be changed or developed.

    官网下载的 mysql-5.7.10-osx10.10-x86_64.dmg 文件,安装好之后。
    在.zshrc 中配置了环境变量。
    输入这个命令
    ➜ /Users/gang >mysql -u root -p password 123456

    mysql Ver 14.14 Distrib 5.7.10, for osx10.9 (x86_64) using EditLine wrapper
    Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.

    Usage: mysql [OPTIONS] [database]
    ...

    输入
    mysql -u root -p password 123
    也能也出来

    mysql Ver 14.14 Distrib 5.7.10, for osx10.9 (x86_64) using EditLine wrapper
    Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

    执行
    mysqladmin -u root -p

    也是同样的

    修改密码
    mysqladmin -u root -p password 123456

    Enter password:
    mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

    刚安装的,不默认没有密码么?
    baidu,google 都解决不了。
    求解决,感谢🙏

    2 replies  •  2016-01-05 13:34:24 +08:00
    cassia
        1
    cassia  
       Jan 1, 2016
    按照步骤一步一步来喽,今天新机刚做开发环境,和 mariadb 差不多,给你参考下 https://goo.gl/PX8bhc
    julyclyde
        2
    julyclyde  
       Jan 5, 2016
    你所谓的“能出来”是指能出来 mysql 的提示符还是 usage 啊?
    我觉得你都没启动 mysql 后台服务
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   5623 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 28ms · UTC 01:39 · PVG 09:39 · LAX 18:39 · JFK 21:39
    ♥ Do have faith in what you're doing.