database:mysql:manage_users

Differences

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

Link to this comparison view

database:mysql:manage_users [2019/10/31 09:04] – created - external edit 127.0.0.1database:mysql:manage_users [2026/10/09 10:30] (current) – tplecko
Line 26: Line 26:
 </WRAP> </WRAP>
  
 +<code bash>
 +sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
  
 +in [mysqld] section, add:
 +mysql_native_password=ON
 +</code>
 <code sql>ALTER USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'password';</code> <code sql>ALTER USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'password';</code>
  • database/mysql/manage_users.txt
  • Last modified: 2026/10/09 10:30
  • by tplecko