• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 361
  • Last Modified:

why the machine name is appended with db user is mysql?

Hi,

I have created a database in mysql with user id "root" and pwd "xxx".

Now when the user from different machine access the database it gives error say
"root@machinename" does not exists.

every time i need to create user "root@machinename" and grant privileges to that then only db accessed.

why the machine name is appended with db user is mysql?
0
Rocking
Asked:
Rocking
  • 2
2 Solutions
 
jb1devCommented:
When creating users, you need to grant them access:

http://dev.mysql.com/doc/refman/5.5/en/adding-users.html

E.g.
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'

Open in new window


You can use the wildcare '%' for all hosts.

E.g.
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
0
 
jb1devCommented:
From the link I posted above

mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
    ->     WITH GRANT OPTION;

Open in new window



The 'monty'@'%' account uses the '%' wildcard for the host part, so it can be used to connect from any host.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now