What does the '@' symbol and hostname mean in the context of 'Access Denied' errors?

Question

Grade: Education Subject: Support
What does the '@' symbol and hostname mean in the context of 'Access Denied' errors?
Asked by:
84 Viewed 84 Answers

Answer (84)

Best Answer
(342)
In MySQL/MariaDB, user accounts are defined as 'username'@'hostname'. The '@' separates the username from the hostname from which the user is allowed to connect. For example, 'myuser'@'localhost' means 'myuser' can only connect from the same machine where the database server is running. 'myuser'@'%' means 'myuser' can connect from any host.