- 首先登陆Linux下的mysql
1 | mysql -uroot -p(密码) |
- 创建用户
1 | GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION; |
‘%’代表在任何一台电脑都可以登陆
- 使更改立即生效
1 | flush privileges; |
- 查看数据库用户
1 | SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user; |
用
exit
退出mysql修改mysql
1 | vim /etc/mysql/mysql.conf.d/mysqld.cnf |
bind-address 127.0.0.1
改为bind-address 0.0.0.0
- 重启mysql
1 | /etc/init.d/mysql restart |
- 查看端口
1 | show global variables like 'port'; |
- 然后使用navicat连接