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:23] – [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 282: Line 284:
 ^performance_schema|aggregates performance-related data about the MySQL server’s operations and resource usage.| ^performance_schema|aggregates performance-related data about the MySQL server’s operations and resource usage.|
 ^sys|a group of stored procedures, functions, and views that are not only critical in providing insights into the MySQL server's performance but also provide a source of information as far as the server's configuration is concerned.| ^sys|a group of stored procedures, functions, and views that are not only critical in providing insights into the MySQL server's performance but also provide a source of information as far as the server's configuration is concerned.|
 +==== password change ====
 <code MySQL> <code MySQL>
 mysql> UPDATE mysql.user SET authentication_string=PASSWORD("password") WHERE User="root"; mysql> UPDATE mysql.user SET authentication_string=PASSWORD("password") WHERE User="root";
  
 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 Bash> 
-$ sudo service mysql stop 
-$ sudo mysqld_safe --skip-grant-tables --skip-networking 
 </code> </code>
  
mysql.1740133394.txt.gz · Last modified: 2025/02/21 19:23 by jianwu