russel053/ 8 月 7, 2018/ Linux, 網頁

sudo mysql -u root
MariaDB [mysql]>GRANT ALL PRIVILEGES ON *.* TO 'root'@'web.server.ip.address';
MariaDB [mysql]>GRANT USAGE ON *.* TO 'root'@'web.server.ip.address' WITH GRANT OPTION;
MariaDB [mysql]>use mysql;
MariaDB [mysql]>update user set plugin='' where User='root';
MariaDB [mysql]>flush privileges;
MariaDB [mysql]> exit
Share this Post