Mac 环境下mysql忘记密码

小编在mac环境下安装mysql之后忘记了密码，导致数据库无法登录使用。于是开始尝试如何修改密码。在这个过程中遇到了一些问题，最终一一解决。

问题概要：Mac下的mysql没有配置文件，需要自己添加；mac下的mysql无法正常执行‘mysql’命令，原因是路径不匹配；mysql安装后会默认给一个初始化密码，然后要自己修改。

作为一个Mac新手，首先遇到的问题居然是不知道哪里打开终端（命令行）和如何找到mysql文件目录（Mac对用户隐藏了目录结构），这里顺便提一下（主要是为了小编自己记忆），终端的快捷打开方式：command+空格 打开应用搜索，然后输入ter确定，即可打开终端。mysql目录：command+shift+g 打开目录搜索，输入/usr/local/mysql/bin 即可到达mysql的bin目录。

顺便提一下，Mac的mysql启动在系统偏好设置里面可以看到。

在顺利打开命令行并cd到mysql的bin目录后，常规操作是：mysql -u root -p 然后输密码进入数据库，这里小编遇到一个问题，命令行提示：

-bash:mysql:command not found

在网上搜了一下原因是mysql路径不匹配，然后去找了解决方法

alias mysql=/usr/local/mysql/bin/mysql

aliasmysqladmin=/usr/local/mysql/bin/mysqladmin

然后就可以正常使用mysql命令了。

然后就是对密码进行修改的操作：

首先关闭mysql服务器

然后cd进入到mysql bin目录

sudo su获取权限

./mysqld_safe --skip-grant-tables (重启服务器)

重新开一个终端

配置短命令 alias mysql=/usr/local/mysql/bin/mysql

输入mysql 进入mysql命令模式

use mysql进入mysql数据库

flush privileges;(获取权限)

set password for 'root'@'localhost'=password('新密码')；完成修改。

之后就可以正常登录数据库了。

补充一下配置文件的问题：

在Mac的mysql是没有my.cnf文件的，所以我们要自己创建my.cnf

首先在/etc新建my.cnf文件

sudo vim 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 = 128K  

 

# 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 

保存文件即可，这里提一下，命令行编辑文件，i是insert指编辑，esc退出编辑状态，：进入命令，输入wq退出。