https://dev.mysql.com/downloads/mysql/
本例使用 macOS10.15(x86, 64-bit),Compressed TAR Archive,8.0.19,159.0M。
下载链接 https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.19-macos10.15-x86_64.tar.gz
1.初始化mysql
1 2 3 4 5 6 |
$ mysqld --initialize --user=root --basedir=/Users/moonmen/appspace/mysql-8.0.19-macos10.15 --datadir=/Users/moonmen/appspace/mysql-8.0.19-macos10.15/data [System] [MY-013169] [Server] /Users/moonmen/appspace/mysql-8.0.19-macos10.15/bin/mysqld (mysqld 8.0.19) initializing of server in progress as process 26476 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /Users/moonmen/appspace/mysql-8.0.19-macos10.15/data/ is case insensitive [Warning] [MY-010122] [Server] One can only use the --user switch if running as root [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 7YdUpnGfbH/t $ |
如上,设定用户名是root,basedir是解压后的程序目录,datadir是程序目录内新建的data文件夹。初始化完毕生成了一个临时密码7YdUpnGfbH/t。
2.修改服务指令配置
打开文件/Users/moonmen/appspace/mysql-8.0.19-macos10.15/support-files/mysql.server,大约46行和47行,将仅声明的basedir和datadir设定对应目录。
1 2 3 4 |
# If you change base dir, you must also change datadir. These may get # overwritten by settings in the MySQL configuration files. 46行 basedir=/Users/moonmen/appspace/mysql-8.0.19-macos10.15 47行 datadir=/Users/moonmen/appspace/mysql-8.0.19-macos10.15/data |
3.启动mysql服务
1 |
$ mysql.server start |
4.使用临时密码登录mysql
1 |
$ mysql -uroot -p7YdUpnGfbH/t |
5.在mysql的shell内修改登录密码
1 |
> ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码'; |
6.退出mysql
1 |
> exit |
再次登录可以隐式输入密码
1 |
$ mysql -uroot -p |
回车根据提示输入新密码
7.停止mysql服务
1 |
$ mysql.server stop |
8.环境变量
注意将必要的目录加人Path文件中,如/Users/moonmen/.bash_profile。
/Users/moonmen/appspace/mysql-8.0.19-macos10.15/bin/
/Users/moonmen/appspace/mysql-8.0.19-macos10.15/support-files/
然后重新加载
1 |
$ source .bash_profile |
-end
本文由崔维友 威格灵 cuiweiyou vigiles cuiweiyou 原创,转载请注明出处:http://www.gaohaiyan.com/2472.html
承接App定制、企业web站点、办公系统软件 设计开发,外包项目,毕设