Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

After the mysql database is populated, it should show up in SHOW DATABASES if you have permission to see it #4081

Closed
timsehn opened this issue Aug 15, 2022 · 0 comments
Assignees
Labels
bug Something isn't working

Comments

@timsehn
Copy link
Contributor

timsehn commented Aug 15, 2022

On a fresh sql-server with no databases:

MySQL [(none)]> CREATE USER 'timsehn'@'localhost' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.002 sec)
MySQL [(none)]> select user from mysql.user;
+---------+
| User    |
+---------+
| root    |
| timsehn |
+---------+
2 rows in set (0.001 sec)
ySQL [(none)]> select user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.001 sec)
MySQL [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.000 sec)

mysql should show in the last query.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants