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:20] – 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 135: Line 137:
 ===== Creating a Dedicated MySQL User and Granting Privileges ===== ===== Creating a Dedicated MySQL User and Granting Privileges =====
 <code MySQL> <code MySQL>
-mysql> create user 'username'@'host' identified with authentication_plugin by 'password';+mysql> create user 'user_name'@'host' identified with authentication_plugin by 'password';
 </code> </code>
-:!: Wrapping both the username and host in single quotes isn’t always necessary, but doing so can help to prevent errors.+:!: Wrapping both the user_name and host in single quotes isn’t always necessary, but doing so can help to prevent errors.
  
 create a user that authenticates with caching_sha2_password: create a user that authenticates with caching_sha2_password:
Line 155: Line 157:
 The general syntax for granting user privileges is as follows: The general syntax for granting user privileges is as follows:
 <code MySQL> <code MySQL>
-mysql> grant privilege on database.table to 'username'@'host';+mysql> grant privilege on database.table to 'user_name'@'host';
 </code> </code>
 <code MySQL> <code MySQL>
-mysql> create user 'wweb'@'localhost' identified with auth_socket;+mysql> create user 'user_name'@'localhost' identified with auth_socket;
   or   or
-mysql> create user 'wweb'@'localhost' identified with mysql_native_password; +mysql> create user 'user_name'@'localhost' identified with mysql_native_password; 
-mysql> alter user 'wweb'@'localhost' identified with auth_socket;+mysql> alter user 'user_name'@'localhost' identified with auth_socket;
 </code> </code>
 <code MySQL> <code MySQL>
-mysql> create user 'wweb'@'localhost' identified with auth_socket;+mysql> create user 'user_name'@'localhost' identified with auth_socket;
 Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.01 sec)
  
Line 183: Line 185:
 The general syntax for granting user privileges is as follows: The general syntax for granting user privileges is as follows:
 <code MySQL> <code MySQL>
-mysql> grant privilege on database.table to 'username'@'host';+mysql> grant privilege on database.table to 'user_name'@'host';
 </code> </code>
 <code MySQL> <code MySQL>
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> 
-<code MySQL> 
-mysql> sudo mysql --user=root --password 
  
-mysql> sudo mysql -u root -p 
-</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.1740133206.txt.gz · Last modified: 2025/02/21 19:20 by jianwu