V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member  Sign In
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
autung
V2EX  ›  MySQL

大家帮我看看 my.ini 配置有没有问题,为什么无法登入 mysql 用户

  •  1
     
  •   autung · Dec 4, 2016 · 3592 views
    This topic created in 3434 days ago, the information mentioned may be changed or developed.
    [mysqld]
    skip-grant-tables
    
    # Remove leading # and set to the amount of RAM for the most important data
    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    # innodb_buffer_pool_size = 128M
    
    # Remove leading # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    # log_bin
    
    # These are commonly set, remove the # and set as required.
    # basedir = E:\mysql-5.7.16-winx64
    # datadir = E:\mysql-5.7.16-winx64\data
    # port = 3306
    # server_id = .....
    
    2 replies    2016-12-05 14:00:00 +08:00
    nyanyh
        1
    nyanyh  
       Dec 5, 2016
    你这个 basedir datadir 虽然改了,但是前面注释的#号没删除啊
    autung
        2
    autung  
    OP
       Dec 5, 2016
    @nyanyh 已经解决问题了,谢谢
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   2669 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 70ms · UTC 11:21 · PVG 19:21 · LAX 04:21 · JFK 07:21
    ♥ Do have faith in what you're doing.