how to change default program to unknown application

For example, the following command connects to the classicmodels database with the user account root: If you know which database you want to work with before you log in, you can use the -D flag. +-+ | Database | +-+ | information_schema | | mysql | | performance_schema | | sys | +-+ 4 rows in set (0.02 sec) Code language: Shell Session ( shell ) Selecting a database when you login

In this case, you need to find which databases are available on your server by using the show databases statement: If the classicmodels database doesn't exist, you'll get the following error after executing the USE statement:ĮRROR 1049 (42000): Unknown database 'classicmodels' Code language: Shell Session ( shell ) +-+ | database() | +-+ | classicmodels | +-+ 1 row in set (0.00 sec) Code language: Shell Session ( shell ) To verify it, you can use the select database() statement: If you see the following message, it means that you have changed the database to classicmodels successfully:ĭatabase changed Code language: Shell Session ( shell ) USE classicmodels Code language: SQL (Structured Query Language) ( sql ) USE database_name Code language: SQL (Structured Query Language) ( sql )įor example, the following statement uses the USE statement to set the current database to classicmodels: To select a database to work with, you use the USE statement: SELECT * FROM t Code language: SQL (Structured Query Language) ( sql )ĮRROR 1046 (3D000): No database selected Code language: plaintext ( plaintext ) If you issue a statement, MySQL will issue an error. It means the current database is not set. +-+ | database() | +-+ | NULL | +-+ 1 row in set (0.00 sec) Code language: Shell Session ( shell ) SELECT database() Code language: SQL (Structured Query Language) ( sql ) To display the current database, you use the following statement: To log in, you need to provide the correct password of the root user account and press Enter. Mysql -u root -p Code language: SQL (Structured Query Language) ( sql )Įnter password: Code language: Shell Session ( shell ) When you log in to a MySQL database server using the mysql client tool without specifying a database name, MySQL server will set the current database to NULL.įirst, log in to MySQL using the root user account: Selecting a MySQL database using the mysql client tool

Summary: in this tutorial, you will learn how to select a database in the mysql program and MySQL Workbench by using the USE statement.

How to change default program to unknown application