#MySQL commands help from Main

1 messages · Page 1 of 1 (latest)

abstract spruceBOT
#

<@&987246399047479336> please have a look, thanks.

#

Here is an AI assisted attempt to answer your question 🤖. Maybe it helps! In any case, a human is on the way 👍. To continue talking to the AI, you can use </chatgpt:1108714622413963314>.

#
TJ-Bot
Need some help with showing databases in my MySQL from main. Think this command should work but doesnt get it to

show databases;

If you are not able to see any databases when using the "show databases;" command in MySQL, there could be a few reasons for this:

  1. Check your permissions: Ensure that the user you are logged in as has the necessary permissions to view databases. You may need to grant the appropriate permissions.

  2. Make sure you are connected to the correct server: Double-check that you are connected to the correct MySQL server where the databases are located.

  3. Check for typos: Ensure that there are no typos in your command, as even a small mistake can prevent it from working correctly.

  4. Refresh your view: Sometimes, databases may not show up immediately after they have been created. Try refreshing your view or reconnecting to see if they appear.

If none of these solutions work, you may want to try restarting your MySQL server or checking for any potential issues with your database setup. If you continue to experience problems, consider reaching out to a more experienced member of the community or seeking additional help online.

- AI generated response
light geyser
#

These are the databases in the MySQL

image.png
#

This is my code so far

image.png
#

What am trying to do it atleast show the databases so I can start working with them with methods and other stuff from the Main class

abstract spruceBOT
#
HuckerDuck's result

Could not find session for member HuckerDuck

livid owl
#

That should work? I don't see the issue

random palm
#

What do you mean with show the databases? Which issue are you encountering? At first glance you just haven't set up your database connection in IntelliJ and thus it's complaining that Book isn't known as it hasn't been introspected yet.

mystic grotto
#

Intellij connect to the db?

random palm
mystic grotto
#

I just use dbeaver-ce,

#

is the interface nice?

random palm
#

It's less context switching, but please open your own topic for this.