/Shell/Bash/Add a user to my myql database

Add a user to my myql database

Mysql add user with all privileges

# First Login mysql shell..
sudo mysql -u root -p 
CREATE USER 'username'@'localhost' IDENTIFIED BY 'P4ssW0rd';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';
FLUSH PRIVILEGES;

Create mysql user

CREATE USER 'newuser'@'%' IDENTIFIED BY 'user_password';
GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'%';
SHOW GRANTS FOR 'newuser'@'%';
FLUSH PRIVILEGES;

Add a user to my myql database

// login try ==> sudo mysql   
CREATE USER 'mizan_username'@'localhost' IDENTIFIED BY 'password_here';
// give all privilieges
GRANT ALL PRIVILEGES ON * . * TO 'mizan_username'@'localhost';

Similar codes

5 votes344 views1 answer
Add all files in directory to git
Shell/Bash
2 votes427 views2 answers
Github insert gif
Shell/Bash
0 vote353 views1 answer
How to check pia checksum
Shell/Bash
3 votes333 views1 answer
Firebase only hosting command
Shell/Bash
0 vote346 views1 answer
Ubuntu check permissions of file
Shell/Bash
0 vote325 views1 answer
Should: vs or: elasticsearch
Shell/Bash
2 votes361 views1 answer
How to rename files with mv in linux
Shell/Bash
0 vote340 views1 answer
Debian user create encypt a passwd
Shell/Bash
1 vote343 views1 answer
Intall mondg brew
Shell/Bash
1 vote363 views2 answers
Ubuntu kill process for user
Shell/Bash