WalkerWiki - wiki.alanwalker.uk

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

====== View Create and Delete MySQL Users ======
\\ 
\\ 
Here we will look at how to View Create and Delete MySQL Users.\\ 
\\ 
Before you can do any of these tasks, you need to login with an admin user:
\\ 
    mysql -u root -p --- (the 'root' part assumes root is your mysql username)
    
    mysql -u root -pPassword (no space between -p and your password)
\\ 
Once logged in you can do the following:
\\ 
\\ 
==== To View Users ====
    
    SELECT user, host FROM mysql.user;
\\ 
==== To Create a User ====
    
    CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
    
    Once created, the user requires permissions
    
    GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
    
    If you want to be able to access the server from anywhere, replace localhost with %
    
    GRANT ALL PRIVILEGES ON * . * TO 'admin'@'%';
\\ 
==== To Create a New User with all Privileges and a Password ====
    GRANT ALL PRIVILEGES ON mydb.* TO 'username'@'%' IDENTIFIED BY 'password';
\\ 
==== To Delete a User ====
    
    DROP USER 'jeffrey'@'localhost';
\\ 
\\