![]() ![]() Now, kill the user2 session with the following command: KILL 20 | 21 | root | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | | 20 | user2 | localhost | NULL | Sleep | 54 | | NULL | | 5 | event_scheduler | localhost | NULL | Daemon | 5129 | Waiting on empty queue | NULL | | Id | User | Host | db | Command | Time | State | Info | You will get the active user list with session ID: +-+-+-+-+-+-+-+-+ In this case, you will need to kill the user session and then remove the user account.įirst, get a list of all active MySQL users using the following command: SHOW PROCESSLIST Sometimes, the MySQL user that you try to delete is active. Next, run the following command to delete a user named user1: DROP USER delete multiple MySQL users, run the following command: DROP USER Delete an Active MySQL User You will get a list of all MySQL users in the following output: +-+-+ You can list all users with the following command: SELECT User, Host FROM er How to Check and Repair MySQL Delete a User in MySQLīefore deleting a user in MySQL, you will need to find the exact name of the user you want to remove. If you want to create a user that can connect from any machine, run the following command: CREATE USER IDENTIFIED WITH mysql_native_password BY 'password' Also Read If you are connecting to MySQL remotely, then you can replace the localhost with remote_ip_address as shown below: CREATE USER IDENTIFIED WITH mysql_native_password BY 'password' To create a new user named user1 and user2 for MySQL locally, use the following command: CREATE USER IDENTIFIED WITH mysql_native_password BY 'password' ĬREATE USER IDENTIFIED WITH mysql_native_password BY 'password' You can use the CREATE USER command by specifying the user and host for a new user account as shown below: CREATE USER IDENTIFED BY 'password' replace matomo by your chosen MySQL username (or simply use matomo).The basic syntax to create a user in MySQL is very simple.replace my-strong-password-here by a strong secure password.replace matomo_db_name_here with the name of your MySQL database (if possible, this database should only have the Matomo tables installed). ![]() (OPTIONAL) Grant this user matomo the FILE global privilege: (if enabled, reports will be archived faster thanks to the LOAD DATA INFILE feature) $ mysql> GRANT FILE ON *.* TO these instructions: Grant this user matomo the permission to access your matomo_db_name_here database $ mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON matomo_db_name_here.* TO is important to grant the user the following privileges: SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES Or if you are using an older version such as MySQL 5.1, MySQL 5.5, MySQL 5.6: $ mysql> CREATE USER IDENTIFIED BY 'my-strong-password-here' If you are installing Matomo (Piwik) on your own server and/or don’t have a tool available to manage your database, you can manually create the MySQL database user by following these steps:Ĭreate a database for Matomo: $ mysql> CREATE DATABASE matomo_db_name_here Ĭreate a user called matomo, if you are using MySQL 5.7 or MySQL 8 or newer: $ mysql> CREATE USER IDENTIFIED WITH mysql_native_password BY 'my-strong-password-here' To create your database and database user, you would typically use your web hosting provider interface which would let you add a new MySQL database and create a new user with permission to access this database, in just a few clicks. When installing Matomo you need to specify a MySQL (or MariaDB) database hostname, user and password. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |