database - Command for granting Access on MySQL -


what command granting access mysql database new users want connect?

consider statement:

create user 'java'@'localhost' identified 'password'; grant on javabase.* 'java'@'localhost' identified 'password'; 

here localhost able connect database. can write '*' instead of 'localhost'?

grant on javabase.* 'java'@'%' identified 'password'; work hosts


Comments

Popular posts from this blog

Ansible - ERROR! the field 'hosts' is required but was not set -

customize file_field button ruby on rails -

SoapUI on windows 10 - high DPI/4K scaling issue -