mac 命令行安装mysql_Mac命令安装mysql数据库过程

/usr/local/mysql

3.安装配置及启动命令如下：

(1)启动，路径不能错：

lijiayongdeMacBook-Air:bin

lijiayong$ /usr/local/mysql/support-files/mysql.server start

Starting MySQL

. ERROR! The server quit without updating PID file

(/usr/local/mysql/data/lijiayongdeMacBook-Air.local.pid).

报错

，第一次在mac环境下安装，遇到错误简直不知所措，细看提示，应该是初始化问题，先进行初始化。

(2)初始化，路径也不能错，一定要在bin文件下进行，可先查看当前路径是不是在bin下，如果不是需要进入到bin目录下：

lijiayongdeMacBook-Air:bin lijiayong$ ./mysqld --

initialize

mysqld: Can't change dir to '/usr/local/mysql/data/'

(Errcode: 2 - No such file or directory)

2016-08-13T08:00:16.231087Z 0 [Warning] TIMESTAMP with

implicit DEFAULT value is deprecated. Please use

--explicit_defaults_for_timestamp server option (see documentation

for more details).

2016-08-13T08:00:16.234789Z 0 [Warning] Insecure

configuration for --secure-file-priv: Current value does not

restrict location of generated files. Consider setting it to a

valid, non-empty path.

2016-08-13T08:00:16.235350Z 0 [Note] ./mysqld (mysqld

5.7.13) starting as process 10015 ...

2016-08-13T08:00:16.249175Z 0 [Warning] Can't create test

file

/usr/local/mysql/data/lijiayongdeMacBook-Air.lower-test

2016-08-13T08:00:16.249204Z 0 [Warning] Can't create test

file

/usr/local/mysql/data/lijiayongdeMacBook-Air.lower-test

2016-08-13T08:00:16.249269Z 0 [ERROR] failed to set

datadir to /usr/local/mysql/data/

2016-08-13T08:00:16.249281Z 0 [ERROR] Aborting

2016-08-13T08:00:16.249292Z 0 [Note] Binlog end

2016-08-13T08:00:16.250917Z 0 [Note] ./mysqld: Shutdown

complete

尼玛 ，又报错，原来命令搞错，mysql --

initialize中的--与initialize之间不能有空格，重新输入命令：

lijiayongdeMacBook-Air:bin lijiayong$ ./mysqld

--initialize

2016-08-13T08:01:09.656339Z 0 [Warning] TIMESTAMP with

implicit DEFAULT value is deprecated. Please use

--explicit_defaults_for_timestamp server option (see documentation

for more details).

2016-08-13T08:01:09.658470Z 0 [Warning] Setting

lower_case_table_names=2 because file system for

/usr/local/mysql/data/ is case insensitive

2016-08-13T08:01:09.817559Z 0 [Warning] InnoDB: New log

files created, LSN=45790

2016-08-13T08:01:09.848809Z 0 [Warning] InnoDB: Creating

foreign key constraint system tables.

2016-08-13T08:01:09.919715Z 0 [Warning] No existing UUID

has been found, so we assume that this is the first time that this

server has been started. Generating a new UUID:

1884e512-612c-11e6-9ae5-05b3711d3ee0.

2016-08-13T08:01:09.932824Z 0 [Warning] Gtid table is not

ready to be used. Table 'mysql.gtid_executed' cannot be

opened.

2016-08-13T08:01:09.941121Z 1 [Note] A temporary password is generated for root@localhost:

Ss(Fv(Ia)7tq

(4)初始化成功，请注意生成的一个临时密码Ss(Fv(Ia)7tq，后面需要用这个密码重新配置root密码，切记。

启动：

lijiayongdeMacBook-Air:bin lijiayong$

/usr/local/mysql/support-files/mysql.server start

Starting MySQL

. SUCCESS!

重启：

lijiayongdeMacBook-Air:bin lijiayong$

/usr/local/mysql/support-files/mysql.server restart

Shutting down MySQL

.. SUCCESS!

Starting MySQL

. SUCCESS!

停止：

lijiayongdeMacBook-Air:bin lijiayong$

/usr/local/mysql/support-files/mysql.server stop

Shutting down MySQL

. SUCCESS!

(5)使用以下命令修改root命令，同样需要在bin文件夹下执行命令，注意-p与临时密码没有空格，格式为：./mysqladmin

-u root -p临时密码 password 新密码

lijiayongdeMacBook-Air:bin lijiayong$

./mysqladmin -u root -pSs(Fv(Ia)7tq

password ljy123

改密码成功！

在bin文件夹下，登陆数据库：lijiayongdeMacBook-Air:bin

lijiayong$ ./mysql -u root -p

回车，输入新密码后，登陆数据库成功。

(6)每次都要走/usr/local/mysql/support-files/下启动数据库，太麻烦，为了方便，不用输那路径，可以在.bash_profile中配置路径，要回到根路径下的bash_profile添加命令，具体如下：

回到根路径：

lijiayongdeMacBook-Air:~ lijiayong$ cd ~

将/usr/local/mysql/bin/

加入系统PATH，在.bash_profile文件中(如果不存在就创建一个,创建方法可以通过执行vi .bash_profile命令创建)。编辑vi .bash_profile

回车后加入以下内容：

export PATH=$PATH:/usr/local/mysql/bin

export PATH=$PATH:/usr/local/mysql/support-files

保存:wq，然后执行生效命令：source .bash_profile

至此，可以中任意路径下启动关闭数据库了，不用再打路径：mysql.server start