How do I access the mysql command line?

[tpg]

How do I access the mysql command line?

I have a virtual account on a server that uses cpanel and mysql

I can create the dbase in cpanel but the phpadmin has limitations and I want to access the command line.

Can anyone help?

Thanks

[SprintSlash]

Use SSH to login, then type: mysql -p

[dgbaker]

That's for accessing as root, not as a user.

This is for a user

mysql -u user -pPASSWORD

[SprintSlash]

No. =) It works for both root and your normal clients. mysql automatically uses the username you used to login to SSH.

[Mad Cow]

Sounds easy enough, but where do I find this SSH?

[supportbytes]

Hi,

If your host has enabled it for you, you can connect using an SSH client like Putty.

http://www.chiark.greenend.org.uk/~s.../download.html

[Mad Cow]

I actually already had putty, but wasn't sure if that was even the right thing to use.

Alright, it tells me I don't have shell access enabled. How might I get cPanel to enable that? Is that something I'd have to pay for or something?

[chirpy]

You do that in WHM. If you're not the server administrator, you really ought to ask your hosting provider for this information and have them setup shell access for you.