You can also create other users to do that click on Add user. MySQL Root account is a default sysadmin account, and it must be disabled. On Accounts and Roles screen, you can specify the MySQL root account password. We are going to use Strong password Encryption for Authentication. Note: If you are using Strong Password Encryption for Authentication, then make sure that all the connectors must be updated to the latest version. On the Authentication Method screen, choose the option to use the Legacy authentication method or Strong password for authentication. In MySQL 8.0 version, we can use SHA256 based strong passwords. You can also choose to allow the port number specified in Port textbox in the firewall. You can also specify the default port to connect to the database server. If you want to configure Named Pipe / Shared Memory, we must provide the Pipe Name and Memory Name. We can use TCP/IP protocol or Named Pipe or Shared Memory. In this section, we can control how clients can connect to MySQL databases. We would configure the server with minimal resources hence select “Development computer” from the Config Type drop-down box. The configuration allocates a high amount of resources to MySQL Service
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |