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

mysql default database-schema
Robert Louis Murphy picture Robert Louis Murphy · Sep 14, 2012 · Viewed 113.4k times · Source

Is there a way to set a default schema for each user in MySQL and if so how? Where user x would default to schema y and user z would default to schema a.

Answer

Devart picture Devart · Sep 14, 2012

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.

Related questions

How to change MySQL data directory?

Is it possible to change my default MySQL data directory to another path? Will I be able to access the databases from the old location?

Read More
Return a default value if single row is not found

I have the following select statement to grab the next scheduled item for a stream. If there is no matching row, I want it to return a default value. Here's the SQL that I'm using: SELECT `file` FROM `show`, `schedule` …

Read More
mysql set field default value to other column

How to set default value for a field to other column in Mysql I have done it oracle with virtual field but I do not know how to do it in Mysql this is my table: create table TSM_TRANSACTION_…

Read More