How Do I Create a User for MariaDB Remote Login?

To create a user for remote MariaDB login, you need to follow these steps:

Log in to your MariaDB server: Use the mysql command-line client or a tool like phpMyAdmin to connect to your MariaDB server.
Create the user: Use the CREATE USER statement to create the new user. Specify the username and password.
Grant remote access permissions: Use the GRANT statement to grant the user the necessary permissions to access the database remotely.
Specify the host: In the GRANT statement, use the HOST clause to specify the IP address or hostname from which the user can connect.

Example:

CREATE USER 'remoteuser'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'remoteuser'@'%';
FLUSH PRIVILEGES;

Explanation:

CREATE USER 'remoteuser'@'%' IDENTIFIED BY 'password'; creates a user named remoteuser with the password password that can connect from any host.
GRANT ALL PRIVILEGES ON *.* TO 'remoteuser'@'%'; grants all privileges on all databases to the user.
FLUSH PRIVILEGES; reloads the privilege tables, ensuring the new user and permissions are applied.

Important Notes:

Replace remoteuser, password, and % with your desired values.
Use specific IP addresses or hostnames instead of % for better security.
Grant only the necessary privileges to the user.
Consider using a strong password and enabling two-factor authentication for added security.

Practical Insights:

You can use the SHOW GRANTS FOR 'remoteuser'@'%'; command to view the permissions granted to the user.
For more complex scenarios, consider using different privilege levels or specific permissions.

A2oz