User Tools

Site Tools


web_services:mysql_notes

MySQL Notes

Change root password

use mysql;
UPDATE user SET Password=PASSWORD('<PASSWORD>') WHERE User='root'; FLUSH PRIVILEGES; exit;
flush privileges;

Create User

CREATE USER '<USERNAME>'@'%' IDENTIFIED BY '<PASSWORD>';
flush privileges;

Grant Full Access to a Database

GRANT ALL PRIVILEGES ON <DBNAME>.* TO '<USERNAME>'@'%' WITH GRANT OPTION;
flush privileges;

Check Grants for a User

SHOW GRANTS FOR '<USERNAME>'@'%'
web_services/mysql_notes.txt · Last modified: 2016/12/19 14:25 by tschulz