官网下载连接:mysql
我的是ubuntu linux 20.4;mysql8.0
第一下载的捆绑包、一对报错;
改为下载的 Install Using APT
然后进行傻瓜式安装;
数据库连接
sudo mysql -u root -p
//然后输入用户名密码;进入mysql操作界面;
create database User
//完成User数据库的创建;
use User
//进入数据库
添加新用户使其可以从外部进行连接
//node为用户名;123456为密码
create user nodeidentified by '123456';
//查看多有用户;
select Host,User,authentication_string from mysql.user;
//分配权限
grant all privileges on *.* to 'node'@'%' identified by '123456' with grant option
//刷新权限;
FLUSH PRIVILEGES
//查看授权表是不是已经添加进去了
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user
//为了可以远程登陆,取消mysql本地ip绑定,一般都是在/etc/mysql目录,目录中有个文件mysql.cnf ; bind-address修改为0.0.0.0
bind-address = 0.0.0.0
//重启服务
service mysql restart
结果报错
//ER_NOT_SUPPORTED_AUTH_MODE
alter user 'root'@'localhost' identified with mysql_native_password by '123456';
//ER_DBACCESS_DENIED_ERROR
例:给 xiaogang 分配所有的权限
grant all on *.* to 'xiaogang'@'%';
//再刷新权限;终于成功了~