phpmyadmin question

[Fiveohhh]

I'm starting to get into some mysql and php programming, and have a question. most of the tuts I've read for mysql use a command line interface. I'm wondering if theres a place I can just get the command line from. so I can access it from home, also how flexible is phpmyadmin, should I basically be able to everything from phpmy admin and not touch the command line?
thanks

 

[Crusty]

If your MySQL server has ssh access then that is what you are looking for, if it doesn't then you should contact the admin.

I have no experience with phpmyadmin, but from what I have heard it works just fine.

 

[spyordie007]

I use PHPMyAdmin, it works well. I'm not sure to what you are referring to doing at the command line but phpmyadmin can do most of it (creating databases/users, assigning permissions, dumping/importing, etc.)

Is there some specific feature you're looking to know if phpmyadmin supports?

 

[Fiveohhh]

nah nothing in particuliar, I'm just starting and curious if I should get familiar with athe command prompt ui, but seems that phpmyadmin will do just as much and easier on the eyes.

 

[timswim78]

you can write commands in phpmyadmin
you click on the tab that says "MySQL" and you can write in whatever MySQL commands you would like to run

 

[spyordie007]

Originally posted by: timswim78
you can write commands in phpmyadmin
you click on the tab that says "MySQL" and you can write in whatever MySQL commands you would like to run

I think you're thinking of the "SQL" tab that appears when you are viewing a database. That tab will allow you to process SQL queries however it does not give you "whatever mysql commands you would like to run"; it gives you "whatever SQL queries you would like to run."

 

[kamper]

is the mysql server on your personal machine or somewhere far away? MCrusty was talking about ssh for remote stuff but if it's on your machine go to the installation directory => bin directory and execute "mysql"

possible args:
-u <username> (root to start probably, if you haven't added any new users yet)
-p (prompt for password, don't put the password on the command line)

I do this on my machine lots, hope that's how you have it; it's nice and easy