0

I install mysql 5.7 on ubuntu 16.04 . I grant user complete. But client not connect database on server. How to configuration Msql 5.7 to client connect and access to the database on mysql-server.

1
  • what is the error of mysql-server when you connect to it? do the mysql client exist on same server of mysql-server? Jun 3, 2016 at 12:01

1 Answer 1

0

if the user with the password can login locally but cannot remotely due to Access denied for user 'user'@'his_ip' then GRANT ALL ON dbname.* TO 'user'@'his_ip';

If he can't even connect then check firewall and if mysql listen that interface: netstat -plnt | grep 3306

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .