So I installed MySQL on my machine. How do I now connect to this to edit permissions and such? I'd like to use something like Navicat to do so, as my SQL is rather rusty. So what username/password ...

Create a connection object using the * mysql.connector.connect ()* method, by passing the user name, password, host (optional default: localhost) and, database (optional) as parameters to it.

mysql --user myuser --database mydatabase --port 53322 --host localhost --protocol TCP But using host localhost it will try to connect using socket, even if TCP/IP tab is used.

Jack Wallen walks you through the process of connecting the DBeaver GUI tool to a remote MySQL server.

LibreOffice Base can make working with remote MySQL databases a snap. Jack Wallen walks you through the steps to make this happen.