Skip to content

Instantly share code, notes, and snippets.

@ulmaull

ulmaull/Setting Mysql Without sudo

Created September 18, 2020 00:22
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ulmaull/f73ceab9f4b2bc93f9a9688f5fe46085 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ulmaull/f73ceab9f4b2bc93f9a9688f5fe46085 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Setting Mysql Without sudo
```
$ > sudo mysql -uroot
```
```
mysql > SELECT User, Host FROM mysql.user;
```
```
mysql > DROP USER 'root'@'localhost';
```
```
mysql > CREATE USER 'root'@'localhost' IDENTIFIED BY 'STRING-PASSWORD-NYA';
```
```
mysql > GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
```
```
mysql > FLUSH PRIVILEGES;
```
```
mysql > exit
```
```
$ > mysql -uroot
```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment