阿里云 Ubuntu18.04安装mysql并远程访问

阿里云 Ubuntu18.04安装mysql并远程访问

安装

apt-get update
apt-get install mysql-server

进入mysql

mysel -u root -p
//直接进入不需要密码

设置密码

ALTER USER 'root'@'localhost' IDENTIFIED BY "123456"
flush privileges;

查看用户权限

select user,host from user;

我百度了半天也没找到root访问权限，就新建用户然后访问

进入mysql库

use mysql;		

在user表中创建账号

create user 'root'@'%' identified by '123456';

修改用户权限

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

给创建好的账号赋予远程权限

grant all privileges on *.* to 'root'@'%' with grant option;

刷新数据库

FLUSH PRIVILEGES;

重启数据库命令

service mysql restart

启动与关闭

service mysql start
service mysql stop

如果报错

ERROR 2003 (HY000): Can't connect to MySQL server on '175.24.28.148' (111)

则进入目录

cd /etc/mysql/mysql.conf.d		
vi mysqld.cnf

#或者
cd /etc/mysql
vi my.cnf

注释

#bind-address           = 127.0.0.1

保存之后，重启mysql。