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
Post a Comment