2003 - Can‘t connect to MySQL server on ‘127.0.0.1‘ (61 “Connection refused“)

1. navicat 连接不上mysql，可把我急坏了
2. 首先是说拒绝连接

错误原因：MySQL新版本（8以上版本）的用户登录账户加密方式是【caching_sha2_password】，Navicat不支持这种用户登录账户加密方式。

方法：不管什么系统，先进去你的mysql，然后输入一下命令，检查编码方式

show variables like 'default_authentication_plugin';

如果是：caching_sha2_password，则更改编码方式：

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

1.  然后我又出现了下面的问题：
2. 1045- Access denied for user 'root'@'localhost' (using password: YES)
3. 意思就是密码对了，就是拒绝你上去，然后就要改一下mysql的配置：

4. cd /usr/local/mysql/etc
   vim my.cnf
   

   #不能修改的话记得sudo一下
   #vim格式下:w 进入编辑模式

5. # Example MySQL config file for medium systems.  
     #  
     # This is for a system with little memory (32M - 64M) where MySQL plays  
     # an important part, or systems up to 128M where MySQL is used together with  
     # other programs (such as a web server)  
     #  
     # 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]
     character-set-server=utf8
     init_connect='SET NAMES utf8
     port        = 3306  
     socket      = /tmp/mysql.sock  
     skip-external-locking  
     key_buffer_size = 16M  
     max_allowed_packet = 1M  
     table_open_cache = 64  
     sort_buffer_size = 512K  
     net_buffer_length = 8K  
     read_buffer_size = 256K  
     read_rnd_buffer_size = 512K  
     myisam_sort_buffer_size = 8M  
     character-set-server=utf8  
     init_connect='SET NAMES utf8' 
   # 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  
   # (via the "enable-named-pipe" option) will render mysqld useless!  
   #   
   #skip-networking  
     
     # Replication Master Server (default)  
     # binary logging is required for replication  
     log-bin=mysql-bin  
       
       # binary logging format - mixed recommended  
       binlog_format=mixed  
         
         # required unique id between 1 and 2^32 - 1  
         # defaults to 1 if master-host is not set  
         # but will not function as a master if omitted  
         server-id   = 1  
           
       # Replication Slave (comment out master section to use this)  
       #  
       # To configure this host as a replication slave, you can choose between  
       # two methods :  
       #  
       # 1) Use the CHANGE MASTER TO command (fully described in our manual) -  
       #    the syntax is:  
       #  
       #    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,  
       #    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;  
       #  
       #    where you replace <host>, <user>, <password> by quoted strings and  
       #    <port> by the master's port number (3306 by default).  
       #  
       #    Example:  
       #  
       #    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,  
       #    MASTER_USER='joe', MASTER_PASSWORD='secret';  
       #  
       # OR  
       #  
       # 2) Set the variables below. However, in case you choose this method, then  
       #    start replication for the first time (even unsuccessfully, for example  
       #    if you mistyped the password in master-password and the slave fails to  
       #    connect), the slave will create a master.info file, and any later  
       #    change in this file to the variables' values below will be ignored and  
       #    overridden by the content of the master.info file, unless you shutdown  
       #    the slave server, delete master.info and restart the slaver server.  
       #    For that reason, you may want to leave the lines below untouched  
       #    (commented) and instead use CHANGE MASTER TO (see above)  
       #  
       # required unique id between 2 and 2^32 - 1  
       # (and different from the master)  
       # defaults to 2 if master-host is set  
       # but will not function as a slave if omitted  
       #server-id       = 2  
       #  
       # The replication master for this slave - required  
       #master-host     =   <hostname>  
       #  
       # The username the slave will use for authentication when connecting  
       # to the master - required  
       #master-user     =   <username>  
       #  
       # The password the slave will authenticate with when connecting to  
       # the master - required  
       #master-password =   <password>  
       #  
       # The port the master is listening on.  
       # optional - defaults to 3306  
       #master-port     =  <port>  
       #  
       # binary logging - not required for slaves, but recommended  
       #log-bin=mysql-bin  
         
         # 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  
             default-character-set=utf8   
               
           [myisamchk]  
           key_buffer_size = 20M  
           sort_buffer_size = 20M  
           read_buffer = 2M  
           write_buffer = 2M  
             
             [mysqlhotcopy]  
             interactive-timeout
   
   		[mysqld]
   		skip-grant-tables
   		default_authentication_plugin=mysql_native_password

   然而我又出现了下面的问题，配置可以了，但是2003 - Can't connect to MySQL server on ……(61 "Connection refused")， 密码对了，配置也对了，但是mysql就是不放行呢！！！

6. 检查navicat的配置是否有问题，主要是编辑连接--高级--使用套连字：

   /tmp/mysql.sock

    希望对你有帮助，终于连上去了