adminを作り全権限を与える
# mysql -u root -p MariaDB [(none)]> CREATE USER 'admin'@'localhost' IDENTIFIED BY 'パスワード'; MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION; MariaDB [(none)]> FLUSH PRIVILEGES; MariaDB [(none)]> EXIT;
コメント