読者です 読者をやめる 読者になる 読者になる

ユーザ追加方法

grant all privileges on *.* to monty@localhost identified by 'password' with grant option;

grant all privileges on *.* to monty@'%' identified by 'password' with grant option;
  • パスワード変更
# mysqladmin -u root -p12345 -hlocalhost password "56789"
mysql> SET PASSWORD FOR 'jeffrey'@'%' = PASSWORD('biscuit');