database:mysql:manage_users [Eureka Moment]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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 bash>
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

in [mysqld] section, add:
mysql_native_password=ON
</code>
<code sql>ALTER USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'password';</code>