Horje
add a user to my myql database Code Example
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;
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';
create mysql user
CREATE USER 'newuser'@'%' IDENTIFIED BY 'user_password';
GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'%';
SHOW GRANTS FOR 'newuser'@'%';
FLUSH PRIVILEGES;




Shell

Related
Install Peer Dependencies Code Example Install Peer Dependencies Code Example
uninstall lightdm Code Example uninstall lightdm Code Example
How do I show the changes which have been staged Code Example How do I show the changes which have been staged Code Example
install material ui icons Code Example install material ui icons Code Example
install rclone Code Example install rclone Code Example

Type:
Code Example
Category:
Coding
Sub Category:
Code Example
Uploaded by:
Admin
Views:
13