Category: Database

if you're using docker and connect to the database server that resides on the host you'll need to use %.

If you've created a mysql user as YOUR-USER@localhost you won't be able to connect.

the solution is to update the mysql.user table but not directly.

RENAME USER 'YOUR-USER'@'localhost' TO 'YOUR-USER'@'%';

Sometimes you've host to use : 172.17.0.1 instead of host.docker.internal if you can't connect

Related

https://serverfault.com/questions/483339/changing-host-permissions-for-mysql-users

Join our mailing list

Get important news about cool products we release and invitations to beta test new products

Find out the Social networks we're on

Black and Cyber Monday Deal: Use BF24 code at checkout for 40% off