#1 show databases #2 use mysql #3 select user, host, plugin from er #4 create user identified by 'password' #5 grant all privileges on *.* to #6 update user set plugin="caching_sha2_password" where User="your_user_name" #. # Creating new user and giving permissions. # Also check if you are unable to login in mysql without sudo. Example 2: how to install mysql in ubuntu 20.04 # ADD user in mysql & have problem with root user # First Login mysql shell. # Enter password which you add in configurations # Now you are all done. enter you password # For removing user NO or n # For disallow login NO or n # For remove database NO or n # Reload table YES or y # DONE configurations. ![]() ![]() Example 1: how to install mysql in ubuntu 20.04 # To install mysql in Ubuntu #
0 Comments
Leave a Reply. |