/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

10 votes196 views4 answers
Error: Node Sass does not yet support your current environment: Windows 64-bit with Unsupported runtime
Shell/Bash
0 vote197 views1 answer
Grep Matching options
Shell/Bash
0 vote195 views1 answer
Debian sudo without password
Shell/Bash
0 vote206 views1 answer
Too many security failures vnc
Shell/Bash
0 vote193 views1 answer
Ubuntu time tracker
Shell/Bash
0 vote215 views1 answer
Pip install geoip2
Shell/Bash
0 vote208 views1 answer
Vscode tab not working ubuntu windows
Shell/Bash
4 votes217 views2 answers
Ionic publish
Shell/Bash
36 votes198 views2 answers
No module named 'sklearn'
Shell/Bash
34 votes198 views6 answers
Git store credentials
Shell/Bash