Comment 1 for bug 1800189

Revision history for this message
Robie Basak (racb) wrote :

Thank you for taking the time to report this bug and helping to make Ubuntu better.

It's a reasonable point that the guide doesn't currently cover how users can connect an SQL monitor to the default installed MySQL server package, and I welcome the addition you suggest, with one minor modification: "sudo mysql" is all that is required; "-u root" and "-p" are unnecessary.

It's not that the user must use a blank password. It's that no password is required when the user is running the client as Unix root because the server is able to detect that and doesn't require a password prompt to authenticate in that case. This is why there is no default password set by default now. And "root" is the default since the sudo means that the mysql client is running as root.

If we add this section, it might be wise to also add a section explaining how to create a database and a user to access this database - so that users don't get misled into thinking that regular database access should be done via "sudo". I wonder whether we should add the "Accessing" part without also adding this "Setting up manually for regular use" part to ensure this.