Cannot see all Databases

Tom_Tees

I have several MySQL databases on my MacBook that I created in phpMyAdmin.

No I'm trying to get more familiar with command-line and using the app mysql.

When I type "show databases;" in mysql I only see two databases and not the ten I was expecting?!

Any idea what is going on?

Also, when I typed in "show tshirtshop" I get...

[FONT="Courier New"]mysql> use tshirtshop;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'tshirtshop'[/FONT]

TomTees

bradgrafelman

Sounds like you're using an account that doesn't have permission to view the database(s).

Are you logging into the MySQL server via the CLI using the same credentials as you are in phpMyAdmin?

Tom_Tees

bradgrafelman;10958196 wrote:
Sounds like you're using an account that doesn't have permission to view the database(s).

Are you logging into the MySQL server via the CLI using the same credentials as you are in phpMyAdmin?

I opened up the mysql app here...

/Applications/MAMP/Library/bin

When it opens up I just typed "show tables;".

I have no clue what I am logged in, but assumed it is as "root"?!

TomTees

bradgrafelman

Access denied for user ''@'localhost'

suggests that you're logging in as a no-name account (probably the default, like 'ODBC' on Windows).

Do "mysql --help" from the CLI to see the list of options (or look in the MySQL manual). For example, normally you'd want to do "mysql --user=<USERNAME> -p" and enter the password when prompted.

Tom_Tees

bradgrafelman;10958199 wrote:
suggests that you're logging in as a no-name account (probably the default, like 'ODBC' on Windows).

Do "mysql --help" from the CLI to see the list of options (or look in the MySQL manual). For example, normally you'd want to do "mysql --user=<USERNAME> -p" and enter the password when prompted.

When I double-click on the mysql app (or my shortcut) it launches a command line type window and I see a "mysql>" prompt.

I Google logging in as "root" but the commands don't seem to work.

They seem to be written like you are in DOS.

I'm on a MacBook.

TomTees

Tom_Tees

I could use some help navigation around in OS X Terminal.

I don't know how to navigate my hard-drive, and I don't know how to log in as "root" in MySQL using Terminal.

TomTees

bradgrafelman

Tom Tees wrote:
They seem to be written like you are in DOS.

Well DOS is analogous to bash or whatever OS X uses for its terminal.

Tom Tees wrote:
I don't know how to navigate my hard-drive

The commands are actually the same as in DOS as they are on the *nix equivalent. "cd <dir>" to change directories, and you can do "./file" to execute a file in the current directory.

Then again, the "mysql" client executable is normally placed somewhere within your system's PATH environment variable so that you can execute it from anywhere.

Tom Tees wrote:
I don't know how to log in as "root" in MySQL using Terminal.

Same syntax as I listed above. If typing "mysql" at a Terminal prompt says file not found or something of that nature, then you'll have to either change to the directory where the client executable is located or simply type the full path to the executable instead of just "mysql" (e.g. "/Applications/MAMP/Library/bin/mysql --user=root -p").

Tom_Tees

bradgrafelman;10958203 wrote:
Same syntax as I listed above. If typing "mysql" at a Terminal prompt says file not found or something of that nature, then you'll have to either change to the directory where the client executable is located or simply type the full path to the executable instead of just "mysql" (e.g. "/Applications/MAMP/Library/bin/mysql --user=root -p").

So by clicking on mysql it doesn't let me log in as root?

And I have to open up mysql from the command line?

Well, if so, then that is the problem...

I seem to be stuck in my "home directory" here:

user1s-macbook:~ user1$

But the "Applications" folder is one level higher than that from what I can see, and I can't get out of my home fodler to get to the Applications folder to get to where mysql is at?!

TomTees

bradgrafelman

Tom Tees wrote:
So by clicking on mysql it doesn't let me log in as root?

Don't know what you're clicking on, but it sounds like it's a shortcut to the mysql CLI. So either modify the shortcut to pass the extra parameters, or just launch the CLI from Terminal instead.

Tom Tees wrote:
I seem to be stuck in my "home directory" here:

Er... basic relative path syntax; ".." means parent directory, so "cd .." will change to the parent directory. Or, you could instead simply use an absolute path to go directly to the directory you want.

Tom_Tees

bradgrafelman;10958211 wrote:
Don't know what you're clicking on, but it sounds like it's a shortcut to the mysql CLI. So either modify the shortcut to pass the extra parameters, or just launch the CLI from Terminal instead.

What is "CLI"??

Er... basic relative path syntax; ".." means parent directory, so "cd .." will change to the parent directory.

But you can't go above your "home" directory which in my case is "user1".

Macintosh HD > Users > user1
Macintosh HD > Applications

Follow me now?

Or, you could instead simply use an absolute path to go directly to the directory you want.

That actually worked, but I don't see how you can back out of your home directory and then back into another directory.

It worked nontheless, although I don't see why I couldn't cd.. out of my home directory.

I guess it is for security, but that doesn't makes sense since I can get to the "Macintosh HD" root-level in Finder which is like Windows Explorer.

TomTees

bradgrafelman

Why would you think that you can't navigate to directories above your home directory?

Tom_Tees

bradgrafelman;10958215 wrote:
Why would you think that you can't navigate to directories above your home directory?

Because you told me to access the mysql app and that isn't in my home directory and you have to go above your home directory into the Applications directory to do that...

TomTees

bradgrafelman

Right, so either "cd ../" to get to the directory above your Home directory, or "cd /" to change to the root of your drive, or "cd /Applications" to change to the Applications folder, or.... etc. etc.

Tom_Tees

bradgrafelman;10958262 wrote:
Right, so either "cd ../" to get to the directory above your Home directory, or "cd /" to change to the root of your drive, or "cd /Applications" to change to the Applications folder, or.... etc. etc.

I just realized I was typing "cd.." and not "cd .."

(I think in Windows it doesn't matter?!)

Not sure what Iw as doing yesterday, because using "cd" was working up to my home directory, but that syntax error fixed things this a.m.

Also, just typing "/Applications" (i.e. a direct path) seems to also be a nice short-cut.

Using "pwd" also seems to help you figure out where you are at.

Told you I didn't remember command line very well!

TomTees