Show pageOld revisionsBacklinksExport to PDFBack to top 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 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:04by 127.0.0.1