Db and table name

**Rachel** · 11-10-2009

Hey,

I want to create a DB called 'asterisk' and table called 'Client_details'. Where I have a PHP page with few details to fill in, once hit submit, I want the contents to be copied to the db (using PHP) and table I have created earlier in MySql .

So long I've been in practice with phpmyadmin GUI for creating Db, Table name and column names. With Linux, I find it kinda struck coz I didn't know where to start.

All I know to do on terminal without any gui:
mysql -u root -p
Enter password: ( I'll enter the password I created during the installation of LAMP server )

Is there any gui like phpmyadmin to work with Karmic Koala?

Any help!

**Rubberman** · 11-10-2009

This is not a question for the Ubuntu forum. Please move this to the Linux Applications forum.

**Kieren** · 11-10-2009

You can install phpmyadmin:

Code:

sudo apt-get install phpmyadmin

You can then access it by going to http://localhost/phpmyadmin

**Rachel** · 11-10-2009

I thought I should post coz I'm currently using Ubuntu-9.10 with LAMP server.

No problem, If I still need to move, I'll.

**Rachel** · 11-10-2009

Hey,

I tried to install using:

Code:

 sudo apt-get install phpmyadmin

I configured to work with apache2, entered my LAMP server password for MySql app and same password for phpmyadmin too, confirmed the password.

My terminal message was this :

Code:

Setting up phpmyadmin (4:3.2.2.1-1) ...
dbconfig-common: writing config to /etc/dbconfig-common/phpmyadmin.conf
unable to read input file /etc/dbconfig-common/phpmyadmin.conf
dpkg: error processing phpmyadmin (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 phpmyadmin
E: Sub-process /usr/bin/dpkg returned an error code (1)

Then when I checked to see the permissions in /etc/dbconfig-common/
phpmyadmin.conf file appeared to be using the emblem for No read ( an into mark ) Hope, this emblem is giving the above error problem.

How can I solve this?

**Kieren** · 11-10-2009

It's not meant to be readable as it contains your passwords. To make sure it has the correct permissions try:

Code:

sudo chmod 600 /etc/dbconfig-common/phpmyadmin.conf

**Rachel** · 11-10-2009

So how can I solve this to see my GUI

When I issued the command:

Code:

 chmos: command not found

***elija*** · 11-10-2009

chmos should be chmod.

I prefer the Mysql GUI Tools to phpmyadmin. They are easily installable via synaptic

**Kieren** · 11-10-2009

Oops, my mistake. The command above has been fixed

**Rachel** · 11-10-2009

I tried Synaptic package manager:

It displayed the below error after downloading:

Code:

E: phpmyadmin: subprocess installed post-installation script returned error exit status 1

Still not sure, what I might be missing

Thread Tools

Display

Db and table name

Posting Permissions