This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision |
| server_configuration:mysql [2023/07/17 08:08] – david | server_configuration:mysql [2025/03/27 15:42] (current) – external edit 127.0.0.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/ |
| | |
| |