mysql创建root账户_MySQL使用root权限创建用户并授权

MySql篇

1.下载并安装Mysql

(1)下载地址

MySQL-8.0下载地址

(2)Mysql配置

1.home目录下命令行执行：vi    .bash_profile来配置MySql绝对路径

2.MySql配置如下:

Setting PATH for MySql 8.0.15

# Setting PATH for Python 3.7

#The original version is saved in .bash_profile.pysave

PATH="/Library/Frameworks/Python.framework/Versions/3.7/bin:${PATH}"

#########################################

#mysql 环境变量如下

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

export PATH

#########################################

alias python="/Library/Frameworks/Python.framework/Versions/3.7/bin/python3.7"

if [ -f ~/.git-completion.bash ]; then

. ~/.git-completion.bash

fi

配置完毕后，保存并退出.

命令行执行:

#mysql -u root -p #使用root权限登陆mysql

#create user 'diting'@'localhost' identified by