mac安装mysql5.7.25并连接本地Sequel pro（踩坑日记系列）

阳光穿透心脏的1/2处 2022-03-22 11:41 571阅读 0赞

### x ###

### 1、下载mysql5.7.25安装包 ###

[下载链接][Link 1]

默认是最新版本，点击查看以前的版本，选择5.7.25版本的dmg文件进行下载。

**事实证明最新版安装时候会有很多问题！所以尽量选择比较稳定的版本。**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdsaW5qaWU_size_16_color_FFFFFF_t_70][]

## 2、点击dmg文件安装 ##

## 注意记住最后一步的随机密码（或者截图）！以后改密码要用！ ##

mac系统会有通知

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdsaW5qaWU_size_16_color_FFFFFF_t_70 1][]

## 3、更改mysql默认密码 ##

检查mysql服务是否启动，默认安装后自动启动。在系统偏好设置->点击mysql服务->启动服务

进入mysql bin目录下

默认地址：

cd /usr/local/mysql-5.7.25xxx/bin

修改密码：

mysql -u root -p password newpass

新密码登录：

mysql -u root -p

## 4、连接本地 Sequel pro ##

**如果standard方式无法连接就试一下3307端口号；**

**获者Socket方式连接。**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdsaW5qaWU_size_16_color_FFFFFF_t_70 2][]

## 5、MySQL server PID file could not be found! ##

类似于mysql server PID的报错：

参考文章：[https://blog.csdn.net/u010098331/article/details/50752667/][https_blog.csdn.net_u010098331_article_details_50752667]

## 6、mysql服务无法开启(自定义mysql配置文件) ##

因为mysql5.7.25没有在本地生成配置文件，我在/etc/建立my.cnf文件时数据木留设置错误，把这个文件删除即可

为了解决接下来的问题，最好在/etc/新建my.cnf配置文件，mysql会优先读取（需要先修改文件权限）

my.cnf

# Example MySQL config file for small systems.  
    #  
    # This is for a system with little memory (<= 64M) where MySQL is only used  
    # from time to time and it's important that the mysqld daemon  
    # doesn't use much resources.  
    #  
    # MySQL programs look for option files in a set of  
    # locations which depend on the deployment platform.  
    # You can copy this option file to one of those  
    # locations. For information about these locations, see:  
    # http://dev.mysql.com/doc/mysql/en/option-files.html  
    #  
    # In this file, you can use all long options that a program supports.  
    # If you want to know which options a program supports, run the program  
    # with the "--help" option.  
    
    # The following options will be passed to all MySQL clients  
    [client]  
    default-character-set=utf8  
    #password   = your_password  
    port        = 3306 
    socket      = /tmp/mysql.sock  
    
    # Here follows entries for some specific programs  
    
    # The MySQL server   
    [mysqld]  
    default-storage-engine=INNODB  
    character-set-server=utf8  
    collation-server=utf8_general_ci  
    port        = 3306 
    socket      = /tmp/mysql.sock  
    skip-external-locking  
    key_buffer_size = 16K  
    max_allowed_packet = 1M  
    table_open_cache = 4 
    sort_buffer_size = 64K  
    read_buffer_size = 256K  
    read_rnd_buffer_size = 256K  
    net_buffer_length = 2K  
    thread_stack = 512K  
    # Don't listen on a TCP/IP port at all. This can be a security enhancement,  
    # if all processes that need to connect to mysqld run on the same host.  
    # All interaction with mysqld must be made via Unix sockets or named pipes.  
    # Note that using this option without enabling named pipes on Windows  
    # (using the "enable-named-pipe" option) will render mysqld useless!  
    #   
    #skip-networking  
    server-id   = 1
    
    # Uncomment the following if you want to log updates  
    log-bin=mysql-bin  
    
    # binary logging format - mixed recommended  
    #binlog_format=mixed  
    
    # Causes updates to non-transactional engines using statement format to be  
    # written directly to binary log. Before using this option make sure that  
    # there are no dependencies between transactional and non-transactional  
    # tables such as in the statement INSERT INTO t_myisam SELECT * FROM  
    # t_innodb; otherwise, slaves may diverge from the master.  
    #binlog_direct_non_transactional_updates=TRUE  
    
    # Uncomment the following if you are using InnoDB tables  
    #innodb_data_home_dir = /usr/local/mysql/data  
    #innodb_data_file_path = ibdata1:10M:autoextend  
    #innodb_log_group_home_dir = /usr/local/mysql/data  
    # You can set .._buffer_pool_size up to 50 - 80 %  
    # of RAM but beware of setting memory usage too high  
    #innodb_buffer_pool_size = 16M  
    #innodb_additional_mem_pool_size = 2M  
    # Set .._log_file_size to 25 % of buffer pool size  
    #innodb_log_file_size = 5M  
    #innodb_log_buffer_size = 8M  
    #innodb_flush_log_at_trx_commit = 1 
    #innodb_lock_wait_timeout = 50 
    
    [mysqldump]  
    quick  
    max_allowed_packet = 16M  
    
    [mysql]  
    no-auto-rehash  
    # Remove the next comment character if you are not familiar with SQL  
    #safe-updates  
    
    [myisamchk]  
    key_buffer_size = 8M  
    sort_buffer_size = 8M  
    
    [mysqlhotcopy]  
    interactive-timeout
    
    [mysqld] 
    transaction-isolation=READ-COMMITTED
    sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

## 7、MySQL无法重启报错Warning: World-writable config file ‘/etc/my.cnf’ is ignored的解决方法 ##

修改文件权限，不能是777，mysql会启动保护措施忽略此文件

chmod 644 /etc/my.cnf

## 8、mac命令行下启动、重启、关闭mysql服务 ##

#启动MySQL服务
    sudo /usr/local/MySQL/support-files/mysql.server start
    
    #停止MySQL服务
    sudo /usr/local/mysql/support-files/mysql.server stop
    
    #重启MySQL服务
    sudo /usr/local/mysql/support-files/mysql.server restart

## 9、mysql5.7.25与mysql5.6.XX版本问题 ##

[mysql命令gruop by报错this is incompatible with sql\_mode=only\_full\_group\_by][mysql_gruop by_this is incompatible with sql_mode_only_full_group_by]

查看sql\_model参数命令：

SELECT @@GLOBAL.sql\_mode;

SELECT @@SESSION.sql\_mode;

发现：

ONLY\_FULL\_GROUP\_BY,STRICT\_TRANS\_TABLES,NO\_ZERO\_IN\_DATE,NO\_ZERO\_DATE,ERROR\_FOR\_DIVISION\_BY\_ZERO,NO\_AUTO\_CREATE\_USER,NO\_ENGINE\_SUBSTITUTION

第一项默认开启ONLY\_FULL\_GROUP\_BY

在/etc/my.cnf下添加：

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

重启服务生效！

## 10、mac下彻底卸载mysql(上述办法都无法解决问题时！) ##

打开终端窗口
    使用mysqldump备份你的数据库将文本文件!
    停止数据库服务器
    sudo rm /usr/local/mysql
    sudo rm -rf /usr/local/mysql*
    sudo rm -rf /Library/StartupItems/MySQLCOM
    sudo rm -rf /Library/PreferencePanes/My*
    edit /etc/hostconfig and remove the line MYSQLCOM=-YES-
    rm -rf ~/Library/PreferencePanes/My*
    sudo rm -rf /Library/Receipts/mysql*
    sudo rm -rf /Library/Receipts/MySQL*
    sudo rm -rf /private/var/db/receipts/*mysql*

[Link 1]: https://dev.mysql.com/downloads/mysql/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdsaW5qaWU_size_16_color_FFFFFF_t_70]: /images/20220322/638a81d5f21d4e0d9067645cc52a7a60.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdsaW5qaWU_size_16_color_FFFFFF_t_70 1]: /images/20220322/db148d1d403f48a7a2b49c6055bef45e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdsaW5qaWU_size_16_color_FFFFFF_t_70 2]: /images/20220322/7985935524564b18992cd340c985c8bd.png
[https_blog.csdn.net_u010098331_article_details_50752667]: https://blog.csdn.net/u010098331/article/details/50752667/
[mysql_gruop by_this is incompatible with sql_mode_only_full_group_by]: https://www.cnblogs.com/jim2016/p/6322703.html