database management in Unix

Question

I am trying to use Unix for the first time and i don't fully understand how i control the database. I have used PHP Admin to edit my DB on a windows machine and it is very easy to use the GUI or hard code my tables.

How can i find the user and password and make tables using Unix? I just need to set up mysql and run a command like this:

mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
    -> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);

I have goggled this but i have found out that i am going about this wrong. please, i am very new and just need some guidance in the right direction.

Alexander L. Belikoff · Accepted Answer · 2013-11-21 04:45:04Z

1

phpMyAdmin is nothing more than an [excellent] GUI shell on top of raw MySQL commands. Assuming you are using MySQL, you use mysqladmin command line tool to manage (create/drop etc) databases and mysql tool to enter SQL commands interactively. MySQL documentation is pretty good and there are plenty of tutorials to get you started.

answered Nov 21, 2013 at 4:45

Alexander L. Belikoff

5,7331 gold badge27 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

database management in Unix

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related