MySql 5.7.13 for Mac 免安装版安装教程

下载的免安装版文件为:mysql-5.7.13-osx10.11-x86_64.tar

进行解压:

FSdeMacBook-Pro:Downloads fs$ tar -zxvf mysql-5.7.13-osx10.11-x86_64.tar x mysql-5.7.13-osx10.11-x86_64.tar.gzx mysql-test-5.7.13-osx10.11-x86_64.tar.gz

解压后得到两个文件:

mysql-5.7.13-osx10.11-x86_64.tar.gz

mysql-test-5.7.13-osx10.11-x86_64.tar.gz

这里我们选择解压mysql-5.7.13-osx10.11-x86_64.tar.gz:

FSdeMacBook-Pro:Downloads fs$ tar -zxvf mysql-5.7.13-osx10.11-x86_64.tar.gz x mysql-5.7.13-osx10.11-x86_64/bin/myisam_ftdumpx mysql-5.7.13-osx10.11-x86_64/bin/myisamchkx mysql-5.7.13-osx10.11-x86_64/bin/myisamlogx mysql-5.7.13-osx10.11-x86_64/bin/myisampackx mysql-5.7.13-osx10.11-x86_64/bin/mysqlx mysql-5.7.13-osx10.11-x86_64/bin/mysql_client_test_embeddedx mysql-5.7.13-osx10.11-x86_64/bin/mysql_config_editorx mysql-5.7.13-osx10.11-x86_64/bin/mysql_embeddedx mysql-5.7.13-osx10.11-x86_64/bin/mysql_install_dbx mysql-5.7.13-osx10.11-x86_64/bin/mysql_pluginx mysql-5.7.13-osx10.11-x86_64/bin/mysql_secure_installationx mysql-5.7.13-osx10.11-x86_64/bin/mysql_ssl_rsa_setup.......

将文件夹移动到/usr/local:

FSdeMacBook-Pro:Downloads fs$ sudo mv mysql-5.7.13-osx10.11-x86_64 /usr/local/Password:FSdeMacBook-Pro:Downloads fs$ 

更名:

FSdeMacBook-Pro:local fs$ cd /usr/local/FSdeMacBook-Pro:local fs$ sudo mv mysql-5.7.13-osx10.11-x86_64/ mysql

初始化 MySql 的一些基本配置:

这里需要注意下,--user=(当前主机用户名),终端信息的末尾给出了

root@localhost: goaplSk2,f6%

--默认密码为
goaplSk2,f6%
FSdeMacBook-Pro:mysql fs$ bin/mysqld --initialize --user=fs2017-08-31T03:31:54.408663Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2017-08-31T03:31:54.411165Z 0 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive2017-08-31T03:31:54.685997Z 0 [Warning] InnoDB: New log files created, LSN=457902017-08-31T03:31:54.728260Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2017-08-31T03:31:54.787619Z 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: ef859ef0-8dfc-11e7-b62d-1e5d7946f5f8.2017-08-31T03:31:54.814072Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.2017-08-31T03:31:54.814933Z 1 [Note] A temporary password is generated for root@localhost: goaplSk2,f6
更改文件所属组:
FSdeMacBook-Pro:mysql fs$ cd ..FSdeMacBook-Pro:local fs$ sudo chown -R fs:wheel mysql

启动 MySql:
FSdeMacBook-Pro:mysql fs$ support-files/mysql.server startStarting MySQL. SUCCESS! FSdeMacBook-Pro:mysql fs$ 

注意:如果出现异常():
The server quit without updating PID file (/usr/local/mysql/data/

请终止服务,并启动 mysqld_safe 重新尝试:
FSdeMacBook-Pro:mysql fs$ sudo bin/mysqld_safe &[1] 3089FSdeMacBook-Pro:mysql fs$ 2017-08-31T01:35:46.6NZ mysqld_safe Logging to '/usr/local/mysql/data/FSdeMacBook-Pro.local.err'.2017-08-31T01:35:46.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data2017-08-31T01:35:47.6NZ mysqld_safe mysqld from pid file /usr/local/mysql/data/FSdeMacBook-Pro.local.pid ended[1]+  Done                    sudo bin/mysqld_safe

重新启动:
FSdeMacBook-Pro:mysql fs$ support-files/mysql.server startStarting MySQL SUCCESS!