![]() The query results are similar to the following: 1Īs you can see, the new root user has been added to the MariaDB system. ![]() SELECT User, Host FROM er WHERE Host 'localhost' Replace “192.168.1.%” with your IP, and set the password to your password.Īfter execution, you can use the following SQL statement to view the results 1 GRANT ALL PRIVILEGES ON *.* TO '192.168.1.%' IDENTIFIED BY '' WITH GRANT OPTION Type '\c' to clear the current input statement.Įxecute the following SQL statement to add a root account that can be accessed remotely. Server version: 10.3.21-MariaDB Source distributionĬopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. After the login is successful, the system displays the MariaDB prompt, similar to the following: 1 Execute mysql to start the client: 1Įnter the root password set on the web management interface of the NAS. You will see the client application-mysql in this directory. The default should be /usr/local/mariadb10 (MariaDB 10 is installed). Log in to the NAS remotely via SSH and find the Mariadb installation directory. Select “Control Pannel” in the web management interface of the NAS, find the “Terminal
0 Comments
Leave a Reply. |