![]() ![]() caching_sha2_password uses a stronger password encryption than prior versions of MySQL and some applications (such as PHP based applications using PHP 7.1 or older) have trouble connecting to MySQL 8 databases. Password EncryptionĭigitalOcean Managed Databases using MySQL 8 are automatically configured to use caching_sha2_password authentication by default. Similarly, to reset a user’s password, open the user’s More menu and select Reset password. You can also delete a user here by opening the user’s More menu, clicking Delete, and then confirming the deletion. New users will receive the permissions of the doadmin user by default these can be changed by following the instructions at How to Modify User Privileges in MySQL Databases. ![]() You can also delete a database here by opening its More menu, clicking Delete, and then confirming the deletion.Ĭreate new users in the Users section by entering a name in the Add new user field, selecting a Password encryption option, and clicking Save. ![]() To add or delete users or databases to a database cluster, click the name of the database to go to its Overview page, then select the Users
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |