Answers for "how to grant permission to access the database stored in my computer in mysql 5.5 to others"

SQL
13

mysql add user with all privileges

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
Posted by: Guest on January-02-2020
4

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;
Posted by: Guest on September-11-2020

Code answers related to "how to grant permission to access the database stored in my computer in mysql 5.5 to others"

Code answers related to "SQL"

Browse Popular Code Answers by Language