Accessing phpmyadmin database from terminal

Question

I have a database in phpmyadmin. How can I access database of phpmyadmin from ubuntu terminal?

clinton3141 · Accepted Answer · 2016-09-30 11:44:11Z

4

You can connect to a mysql server using the mysql command

mysql --user=USERNAME -p --host=HOSTNAME --database=DATABASENAME

This will then prompt you for the password for the specified user (because the password switch was -p instead of --password=PASSWORD). Press return without typing anything for no password.

You can find more information on how to use the command by typing man mysql or mysql --help into your terminal.

answered Sep 30, 2016 at 11:44

clinton3141

4,8423 gold badges36 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Parag Over a year ago

The problem is that i cannot find my phpmuadmin database from the terminal using the 'show databases' command

clinton3141 Over a year ago

@Parag are you using the same username and password in the terminal that you use for phpmyadmin?

midhun k · Accepted Answer · 2016-09-30 11:40:54Z

0

mysql -u <username> -p<password> <database_name>

Make sure no space between -p and password. Of course, this password will be visible in history.

To overcome this:

1.Leave it blank and it will ask you for it.
2.start the command with a space in front of mysql

answered Sep 30, 2016 at 11:40

midhun k

1,0581 gold badge15 silver badges43 bronze badges

1 Comment

Parag Over a year ago

I cannot find my phpmyadmin database from the mysql installed via terminal. Why? Any idea?

Collectives™ on Stack Overflow

Accessing phpmyadmin database from terminal

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related