Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. Server version: 8.0.23 MySQL Community Server - GPLĬopyright (c) 2000, 2021, Oracle and/or its affiliates.
After you input the correct password ( the root password which you set during the MySQL installation ), you can enter the MySQL interactive console. You can run the command /usr/local/mysql/bin/mysql -u root -p to connect to the MySQL database server as below.
After you install the MySQL database server, it is installed in the directory /usr/local/mysql.
How To Connect MySQL Server In Command-Line. ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 6. `email` varchar(100) COLLATE utf8_bin NOT NULL, `password` varchar(100) COLLATE utf8_bin NOT NULL, `user_name` varchar(100) COLLATE utf8_bin NOT NULL,
Then click execute button(the first lightning icon ) at the top toolbar of the SQL window to execute the code.
To execute the below DDL code, just click Create a new SQL tab for executing queries button ( ) at MySQL workbench toolbar top left corner to open a SQL command execute window, and then copy below code into it. Below is the table DDL SQL code, you can also run it to create this table. In our MySQL JDBC examples, we always use a table user_account, so we should create this table use MySQL workbench.
Click Apply button to create the database.