server_configuration:mysql

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
server_configuration:mysql [2023/07/17 08:08] – davidserver_configuration:mysql [2023/07/17 08:26] (current) – david
Line 1: Line 1:
 +https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql
 +
 +<code mysql>
 +CREATE USER 'davidrh'@'localhost' IDENTIFIED BY 'password';
 +ALTER USER 'davidrh'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
 +CREATE DATABASE david;
 +GRANT ALL PRIVILEGES ON david.* TO 'davidrh'@'localhost' WITH GRANT OPTION;
 +FLUSH PRIVILEGES;
 +</code>
 +
 +<code mysql>
 +CREATE USER 'monica'@'localhost' IDENTIFIED BY 'password';
 +ALTER USER 'monica'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
 +CREATE DATABASE monica;
 +GRANT ALL PRIVILEGES ON monica.* TO 'monica'@'localhost' WITH GRANT OPTION;
 +FLUSH PRIVILEGES;
 +</code>
 +
 +
 +https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql
 +
 +https://support.microfocus.com/kb/doc.php?id=7013333
 +
 +https://sidu.roman-halliday.com/?id=1
 +
 +
 +https://medium.com/techvblogs/how-to-reset-mysql-root-password-in-ubuntu-53b05eadbad6
 +
 +
 +
 +https://www.pgadmin.org/docs/pgadmin4/7.4/server_deployment.html
 +
 +https://franchise.cloud/
 +
 +http://topnew.net/support/topic/201
 +
 +
 +https://wiki.postgresql.org/wiki/PostgreSQL_Clients#Open_Source_2
 +
 +https://www.phpmyadmin.net/
 +
  
  • server_configuration/mysql.txt
  • Last modified: 2023/07/17 08:26
  • by david