SyntaxFix

[mysql] How do I set the default schema for a user in MySQL

There is no default database for user. There is default database for current session.

You can get it using DATABASE() function -

SELECT DATABASE();

And you can set it using USE statement -

USE database1;

You should set it manually - USE db_name, or in the connection string.

Examples related to mysql

• Implement specialization in ER diagram • How to post query parameters with Axios? • PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client • Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver' • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' is not supported • How to resolve Unable to load authentication plugin 'caching_sha2_password' issue • Connection Java-MySql : Public Key Retrieval is not allowed • How to grant all privileges to root user in MySQL 8.0 • MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Examples related to default

• Why Is `Export Default Const` invalid? • Default Values to Stored Procedure in Oracle • How do I change the default index page in Apache? • Angularjs Template Default Value if Binding Null / Undefined (With Filter) • Google Chrome default opening position and size • new DateTime() vs default(DateTime) • Using an attribute of the current class instance as a default value for method's parameter • How do I set the default schema for a user in MySQL • In NetBeans how do I change the Default JDK? • PHP sessions default timeout

Examples related to database-schema

• How can I initialize a MySQL database with schema in a Docker container? • What are OLTP and OLAP. What is the difference between them? • How to store arrays in MySQL? • When to use MyISAM and InnoDB? • How to SELECT in Oracle using a DBLINK located in a different schema? • How do I set the default schema for a user in MySQL • Difference Between Schema / Database in MySQL • Differences between key, superkey, minimal superkey, candidate key and primary key • How to get all columns' names for all the tables in MySQL? • Difference between database and schema