PCTResearch Wiki

User Tools

Site Tools

Trace:
mysql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
mysql [2025/02/21 19:24] – [MySQL has four default system databases:] jianwumysql [2025/02/26 03:55] (current) – jianwu
Line 1: Line 1:
 +[[https://pctresearch.com/|{{:wiki_banner.jpg?nolink&800|}}]]
 +
 ===== MySQL ===== ===== MySQL =====
  [[https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-22-04|How To Install MySQL on Ubuntu 22.04]]  [[https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-22-04|How To Install MySQL on Ubuntu 22.04]]
Line 287: Line 289:
  
 mysql> UPDATE mysql.user SET Password=PASSWORD("password") WHERE User="root"; mysql> UPDATE mysql.user SET Password=PASSWORD("password") WHERE User="root";
-</code> +
-You should obviously change your root password after installation: +
-<code MySQL>+
 mysql> mysqladmin -u root password [newpassword] mysql> mysqladmin -u root password [newpassword]
 </code> </code>
  
mysql.1740133459.txt.gz · Last modified: 2025/02/21 19:24 by jianwu