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

javascript - Hide toolbar of pdf file opened inside iframe using firefox -

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

Copy range with conditional formatting -