database:mysql:manage_users

Differences

This shows you the differences between two versions of the page.


database:mysql:manage_users [2019/10/31 09:04] (current) – created - external edit 127.0.0.1
Line 1: Line 1:
 +====== Manage MySql users ======
 +<code sql Create user>
 +CREATE USER 'newuser'@'%' IDENTIFIED BY 'password';
 +</code>
 +<code sql Grant privileges>
 +-- Grant all privileges including the grant option (basically an additional root user)
 +GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'%' WITH GRANT OPTION;
  
 +-- Grant all privileges
 +GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'%';
 +
 +-- Grant read-only privileges
 +GRANT SELECT ON *.* TO 'newuser'@'%';
 +</code>
 +
 +<code sql Flush privileges>
 +FLUSH PRIVILEGES;
 +</code>
 +
 +<code sql Change password>
 +SET PASSWORD FOR 'user'@'localhost' = 'NewPassword';
 +</code>
 +
 +<WRAP center round important 60%>
 +If MySql server is accessible from network, limit users access from local lan by using 10.0.0.% instead of just %, or enter a specific IP address
 +</WRAP>
 +
 +
 +<code sql>ALTER USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'password';</code>
  • database/mysql/manage_users.txt
  • Last modified: 2019/10/31 09:04
  • by 127.0.0.1