Christopher Juckins

SysAdmin Tips, Tricks and other Software Tools

User Tools

Site Tools

Trace:
ubuntu_notes

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
ubuntu_notes [2019/01/26 11:59] – juckinsubuntu_notes [2019/01/26 12:12] – juckins
Line 54: Line 54:
 See notes at [[https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-18-04]] for setting up a new user See notes at [[https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-18-04]] for setting up a new user
  
 +Other SQL commands/testing:
 +
 +
 +  CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
 +  GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password';
 +  CREATE DATABASE dbname;
 +  SET PASSWORD FOR 'username'@'localhost' = PASSWORD('password');
 ---- ----
  
ubuntu_notes.txt · Last modified: 2021/02/21 11:09 by juckins