To work with with MySQL databases in VS Code, try the MySQL extension. To delete a database, enter: DROP DATABASE database_name įor more about working with MySQL databases, see the MySQL docs. To create a new database, enter: CREATE DATABASE database_name To see what databases you have available, in the MySQL prompt, enter: SHOW DATABASES To open the MySQL prompt, enter: sudo mysql You will then set a password for the MySQL root user, decide whether or not to remove anonymous users, decide whether to allow the root user to login both locally and remotely, decide whether to remove the test database, and, lastly, decide whether to reload the privilege tables immediately.
0 Comments
Leave a Reply. |