/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

1 vote309 views1 answer
Mac show cocoapods version
Shell/Bash
9 votes297 views2 answers
Import password chrome csv
Shell/Bash
1 vote308 views1 answer
Git apply previous stash
Shell/Bash
1 vote288 views2 answers
Start ssh macos
Shell/Bash
0 vote277 views1 answer
Comprimir archivos con zip en linux
Shell/Bash
0 vote285 views1 answer
Upgrade php 8 ubuntu 20.04
Shell/Bash
0 vote292 views1 answer
Upload transfer.sh
Shell/Bash
2 votes232 views1 answer
Ubuntu unity
Shell/Bash
0 vote280 views1 answer
Download sublime merge in linux
Shell/Bash
0 vote291 views1 answer
Put all folders with specific name in git ignore
Shell/Bash