Now that the database is created, you can start with a nonadmin user with the CREATE USER MySQL statement. ![]() It then makes a new user in the MySQL service and grants that user all privileges for the new database schema (testdb.*). This SQL code creates a new database named testdb. ![]() Replace the placeholder value testdb with your database name. Replace the placeholder value db_user with your intended new user name. Subscribe to TechRepublic’s How To Make Tech Work on YouTube for all the latest tech advice for business pros from Jack Wallen.If you're not sure how to connect, see connect and query data for Single Server or connect and query data for Flexible Server.Įdit and run the following SQL code. Now that you’ve learned how to set up remote connections for MySQL 8, here’s how you can connect the MySQL database with LibreOffice, DBeaver and Grafana. Time to don your database admin hat and get to work. Finally, click Connect, and the GUI should successfully connect to your remote database ( Figure B).įigure B Beekeeper Studio has successfully connected to a remote database.Ĭongratulations, not only have you configured MySQL 8 for remote connections, you’ve created a user with access to all databases and connected to the remote server with both the command line and a GUI. After getting the OK, give the connection a name and click Save. Once you’ve filled out the details, click Test to make sure the connection works.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |