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 [2020/07/29 09:45] – juckinsubuntu_notes [2020/11/29 09:26] – juckins
Line 125: Line 125:
   SET PASSWORD FOR 'username'@'localhost' = PASSWORD('password');   SET PASSWORD FOR 'username'@'localhost' = PASSWORD('password');
      
 +To allow logins to mysql via adminer:
 +
 +https://serverfault.com/questions/1001274/adminer-denied-acces-for-user
 +
 +  # su -
 +  # mysql -u root -p 
 +  > ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password
 +BY 'YOUR_PASSWORD';
 +  # systemctl restart mysql
 +  # systemctl restart apache2.service
      
 To fix this locale error upon login: To fix this locale error upon login:
ubuntu_notes.txt · Last modified: 2021/02/21 11:09 by juckins