Skapa databas med tabeller i mysql, php

Här diskuteras programmering och utveckling
ekg
Inlägg: 8
Blev medlem: 09 okt 2009, 09:57
OS: Ubuntu
Utgåva: 12.04 Precise Pangolin LTS

Skapa databas med tabeller i mysql, php

Inlägg av ekg »

Jag har installerat PHP och mysql i min dator. Jag vill nu tillverka en databas med tabeller. Hur gör jag?
Användarvisningsbild
P.Forsberg
AVREGISTRERAD
Inlägg: 2573
Blev medlem: 17 jan 2008, 18:38
OS: Ubuntu
Utgåva: 23.04 Lunar Lobster
Ort: Kvarnsjön
Kontakt:

Re: Skapa databas med tabeller i mysql, php

Inlägg av P.Forsberg »

Hej och välkommen! :)
Det enklaste vore att installera phpmyadmin. ( finns i Synaptic )
Jag utgår ifrån att du har apache2 installerat.
Om så är fallet kommer du åt phpmyadmin under adressen http://localhost/phpmyadmin
Under installationen av phpmyadmin måste du ange lösenordet för root-konto. Kom ihåg den ! ;)

LJ
ekg
Inlägg: 8
Blev medlem: 09 okt 2009, 09:57
OS: Ubuntu
Utgåva: 12.04 Precise Pangolin LTS

Re: Skapa databas med tabeller i mysql, php

Inlägg av ekg »

Tack LJ!
Jag har installerat LAMP och mysql och PHP fungerar båda. När jag försöker köra http://lokalhost/phpmyadmin får jag svaret att deen inte hittas.
Apach2 är installerad.
ekg
Användarvisningsbild
Konservburk
Inlägg: 5919
Blev medlem: 07 apr 2007, 22:28

Re: Skapa databas med tabeller i mysql, php

Inlägg av Konservburk »

ekg skrev:När jag försöker köra http://lokalhost/phpmyadmin får jag svaret att deen inte hittas.
Du kanske ska försöka med localhost istället för lokalhost.
ekg
Inlägg: 8
Blev medlem: 09 okt 2009, 09:57
OS: Ubuntu
Utgåva: 12.04 Precise Pangolin LTS

Re: Skapa databas med tabeller i mysql, php

Inlägg av ekg »

Tack igen
Jag stavade fel, men när jag klickar på din länk får jag svaret:
Not Found

The requested URL /phpmyadmin was not found on this server.
Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.7 with Suhosin-Patch Server at localhost Port 80
EKG
Användarvisningsbild
micke_nordin
Inlägg: 1539
Blev medlem: 21 aug 2008, 17:03
OS: Ubuntu
Utgåva: 22.10 Kinetic Kudu
Kontakt:

Re: Skapa databas med tabeller i mysql, php

Inlägg av micke_nordin »

ekg skrev:Tack igen
Jag stavade fel, men när jag klickar på din länk får jag svaret:
Not Found

The requested URL /phpmyadmin was not found on this server.
Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.7 with Suhosin-Patch Server at localhost Port 80
EKG
Men har du installerat phpmyadmin då?

/Micke
ekg
Inlägg: 8
Blev medlem: 09 okt 2009, 09:57
OS: Ubuntu
Utgåva: 12.04 Precise Pangolin LTS

Re: Skapa databas med tabeller i mysql, php

Inlägg av ekg »

Tack Micke och LJ!
Jag har installerat phpmyadmin, men den startar inte ändå. Jag försökte installera phpmyadmin en gång till, men då får jag svaret att den redan är installerad.
EKG
Användarvisningsbild
P.Forsberg
AVREGISTRERAD
Inlägg: 2573
Blev medlem: 17 jan 2008, 18:38
OS: Ubuntu
Utgåva: 23.04 Lunar Lobster
Ort: Kvarnsjön
Kontakt:

Re: Skapa databas med tabeller i mysql, php

Inlägg av P.Forsberg »

Ok, om di skriver http://localhost kommer det uppe en bild som den här?
Bild
ekg
Inlägg: 8
Blev medlem: 09 okt 2009, 09:57
OS: Ubuntu
Utgåva: 12.04 Precise Pangolin LTS

Re: Skapa databas med tabeller i mysql, php

Inlägg av ekg »

HEJ1
Ja det stämmer. Det skrivs:
It works.
Filen index.html skapades då jag testade installationen.
Jag har försökt installera phpmyadmin mha terminalen. Resultatet blev:

ekg@ekg-laptop:~$ sudo apt-get install phpmyadmin
[sudo] password for ekg:
Reading package lists... Done
Building dependency tree
Reading state information... Done
phpmyadmin is already the newest version.
The following packages were automatically installed and are no longer required:
linux-headers-2.6.24-23-generic linux-headers-2.6.24-23
Use 'apt-get autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
ekg@ekg-laptop:~$

Det går fortfarande inte att köra
phpmyadmin

ekg
Användarvisningsbild
micke_nordin
Inlägg: 1539
Blev medlem: 21 aug 2008, 17:03
OS: Ubuntu
Utgåva: 22.10 Kinetic Kudu
Kontakt:

Re: Skapa databas med tabeller i mysql, php

Inlägg av micke_nordin »

ekg skrev: Det går fortfarande inte att köra
phpmyadmin

ekg
När du klickar här: http://localhost/phpmyadmin/ står det alltså: The requested URL /phpmyadmin/ was not found on this server. ???

Ett mysterium, sannerligen,

/Micke
ekg
Inlägg: 8
Blev medlem: 09 okt 2009, 09:57
OS: Ubuntu
Utgåva: 12.04 Precise Pangolin LTS

Re: Skapa databas med tabeller i mysql, php

Inlägg av ekg »

Tack Micke!
Jag klickade din länk och fick svaret:
Not Found

The requested URL /phpmyadmin/ was not found on this server.
Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.7 with Suhosin-Patch Server at localhost Port 80

Är du från Sandarne?
EKG
Användarvisningsbild
micke_nordin
Inlägg: 1539
Blev medlem: 21 aug 2008, 17:03
OS: Ubuntu
Utgåva: 22.10 Kinetic Kudu
Kontakt:

Re: Skapa databas med tabeller i mysql, php

Inlägg av micke_nordin »

Vad får du för svar om du kör locate phpmyadmin i terminalen?

Har du förövrigt testat att starta om apache efter att du installaerade phpmyadmin? sudo /etc/init.d/apache2 restart

Nej jag är inte från Sandarne ;)

/Micke
Användarvisningsbild
P.Forsberg
AVREGISTRERAD
Inlägg: 2573
Blev medlem: 17 jan 2008, 18:38
OS: Ubuntu
Utgåva: 23.04 Lunar Lobster
Ort: Kvarnsjön
Kontakt:

Re: Skapa databas med tabeller i mysql, php

Inlägg av P.Forsberg »

Något som gick fel där. Kommer det upp samma felmeddelande när du klicka på http://127.0.0.1/phpmyadmin/ ?

LJ
ekg
Inlägg: 8
Blev medlem: 09 okt 2009, 09:57
OS: Ubuntu
Utgåva: 12.04 Precise Pangolin LTS

Re: Skapa databas med tabeller i mysql, php

Inlägg av ekg »

Hej, när jag kör
locate phpmyamin i terminalen får jag svaret (bla annet):

/usr/share/phpmyadmin/libraries/transformations/image_jpeg__inline.inc.php
/usr/share/phpmyadmin/libraries/transformations/image_jpeg__link.inc.php
/usr/share/phpmyadmin/libraries/transformations/image_png__inline.inc.php
/usr/share/phpmyadmin/libraries/transformations/template_generator.sh
/usr/share/phpmyadmin/libraries/transformations/template_generator_mimetype.sh
/usr/share/phpmyadmin/libraries/transformations/text_plain__dateformat.inc.php
/usr/share/phpmyadmin/libraries/transformations/text_plain__external.inc.php
/usr/share/phpmyadmin/libraries/transformations/text_plain__formatted.inc.php
/usr/share/phpmyadmin/libraries/transformations/text_plain__imagelink.inc.php
/usr/share/phpmyadmin/libraries/transformations/text_plain__link.inc.php
/usr/share/phpmyadmin/libraries/transformations/text_plain__sql.inc.php
/usr/share/phpmyadmin/libraries/transformations/text_plain__substr.inc.php
/usr/share/phpmyadmin/pmd/images
/usr/share/phpmyadmin/pmd/scripts
/usr/share/phpmyadmin/pmd/styles
/usr/share/phpmyadmin/pmd/images/2leftarrow.png
/usr/share/phpmyadmin/pmd/images/2leftarrow_m.png
/usr/share/phpmyadmin/pmd/images/2rightarrow.png
/usr/share/phpmyadmin/pmd/images/2rightarrow_m.png
/usr/share/phpmyadmin/pmd/images/ang_direct.png
/usr/share/phpmyadmin/pmd/images/bord.png
/usr/share/phpmyadmin/pmd/images/bottom.png
/usr/share/phpmyadmin/pmd/images/def.png
/usr/share/phpmyadmin/pmd/images/display_field.png
/usr/share/phpmyadmin/pmd/images/downarrow1.png
/usr/share/phpmyadmin/pmd/images/downarrow2.png
/usr/share/phpmyadmin/pmd/images/downarrow2_m.png
/usr/share/phpmyadmin/pmd/images/exec.png
/usr/share/phpmyadmin/pmd/images/exec_small.png
/usr/share/phpmyadmin/pmd/images/favicon.ico
/usr/share/phpmyadmin/pmd/images/grid.png
/usr/share/phpmyadmin/pmd/images/help.png
/usr/share/phpmyadmin/pmd/images/help_relation.png
/usr/share/phpmyadmin/pmd/images/pdf.png
/usr/share/phpmyadmin/pmd/images/relation.png
/usr/share/phpmyadmin/pmd/images/reload.png
/usr/share/phpmyadmin/pmd/images/resize.png
/usr/share/phpmyadmin/pmd/images/rightarrow1.png
/usr/share/phpmyadmin/pmd/images/rightarrow2.png
/usr/share/phpmyadmin/pmd/images/save.png
/usr/share/phpmyadmin/pmd/images/table.png
/usr/share/phpmyadmin/pmd/images/uparrow2_m.png
/usr/share/phpmyadmin/pmd/scripts/ajax.js
/usr/share/phpmyadmin/pmd/scripts/iecanvas.js
/usr/share/phpmyadmin/pmd/scripts/move.js
/usr/share/phpmyadmin/pmd/styles/default
/usr/share/phpmyadmin/pmd/styles/default/images
/usr/share/phpmyadmin/pmd/styles/default/style1.css
/usr/share/phpmyadmin/pmd/styles/default/images/1.png
/usr/share/phpmyadmin/pmd/styles/default/images/2.png
/usr/share/phpmyadmin/pmd/styles/default/images/3.png
/usr/share/phpmyadmin/pmd/styles/default/images/4.png
/usr/share/phpmyadmin/pmd/styles/default/images/5.png
/usr/share/phpmyadmin/pmd/styles/default/images/6.png
/usr/share/phpmyadmin/pmd/styles/default/images/7.png
/usr/share/phpmyadmin/pmd/styles/default/images/8.png
/usr/share/phpmyadmin/pmd/styles/default/images/FieldKey_small.png
/usr/share/phpmyadmin/pmd/styles/default/images/Field_small.png
/usr/share/phpmyadmin/pmd/styles/default/images/Field_small_char.png
/usr/share/phpmyadmin/pmd/styles/default/images/Field_small_date.png
/usr/share/phpmyadmin/pmd/styles/default/images/Field_small_int.png
/usr/share/phpmyadmin/pmd/styles/default/images/Header.png
/usr/share/phpmyadmin/pmd/styles/default/images/Header_Linked.png
/usr/share/phpmyadmin/pmd/styles/default/images/left_panel_butt.png
/usr/share/phpmyadmin/pmd/styles/default/images/left_panel_tab.png
/usr/share/phpmyadmin/pmd/styles/default/images/small_tab.png
/usr/share/phpmyadmin/pmd/styles/default/images/top_panel.png
/usr/share/phpmyadmin/scripts/setup.php
/usr/share/phpmyadmin/themes/darkblue_orange
/usr/share/phpmyadmin/themes/original
/usr/share/phpmyadmin/themes/darkblue_orange/css
/usr/share/phpmyadmin/themes/darkblue_orange/img
/usr/share/phpmyadmin/themes/darkblue_orange/info.inc.php
/usr/share/phpmyadmin/themes/darkblue_orange/layout.inc.php
/usr/share/phpmyadmin/themes/darkblue_orange/screen.png
/usr/share/phpmyadmin/themes/darkblue_orange/css/theme_right.css.php
/usr/share/phpmyadmin/themes/darkblue_orange/img/arrow_ltr.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/arrow_rtl.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/asc_order.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_bookmark.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_browse.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_calendar.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_comment.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_dbstatistics.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_deltbl.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_docs.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_docsql.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_drop.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_edit.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_empty.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_engine.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_export.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_firstpage.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_ftext.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_help.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_home.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_import.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_index.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_info.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_insrow.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_lastpage.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_minus.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_newdb.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_newtbl.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_nextpage.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_pdfdoc.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_plus.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_prevpage.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_primary.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_print.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_props.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_relations.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_save.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_sbrowse.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_sdb.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_search.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_selboard.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_select.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_sql.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_sqldoc.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_sqlhelp.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_tblanalyse.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_tblexport.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_tblimport.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_tblops.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_tbloptimize.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_tipp.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_unique.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_usradd.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_usrcheck.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_usrdrop.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_usredit.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_usrlist.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_view.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/b_views.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/bd_browse.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/bd_deltbl.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/bd_drop.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/bd_empty.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/bd_firstpage.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/bd_ftext.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/bd_index.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/bd_insrow.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/bd_lastpage.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/bd_nextpage.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/bd_prevpage.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/bd_primary.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/bd_sbrowse.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/bd_select.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/bd_unique.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/error.ico
/usr/share/phpmyadmin/themes/darkblue_orange/img/item.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/item_ltr.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/item_rtl.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/logo_left.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/logo_right.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/php_sym.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/pma_logo2.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_asc.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_asci.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_attention.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_cancel.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_cancel2.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_db.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_desc.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_error.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_error2.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_fulltext.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_host.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_info.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_lang.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_loggoff.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_notice.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_okay.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_partialtext.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_passwd.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_process.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_really.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_reload.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_rights.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_status.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_tbl.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_theme.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_vars.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_views.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/s_warn.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/spacer.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/tbl_header.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/tbl_th.png
/usr/share/phpmyadmin/themes/darkblue_orange/img/window-new.png
/usr/share/phpmyadmin/themes/original/css
/usr/share/phpmyadmin/themes/original/img
/usr/share/phpmyadmin/themes/original/info.inc.php
/usr/share/phpmyadmin/themes/original/layout.inc.php
/usr/share/phpmyadmin/themes/original/screen.png
/usr/share/phpmyadmin/themes/original/css/theme_left.css.php
/usr/share/phpmyadmin/themes/original/css/theme_print.css.php
/usr/share/phpmyadmin/themes/original/css/theme_right.css.php
/usr/share/phpmyadmin/themes/original/img/arrow_ltr.png
/usr/share/phpmyadmin/themes/original/img/arrow_rtl.png
/usr/share/phpmyadmin/themes/original/img/asc_order.png
/usr/share/phpmyadmin/themes/original/img/b_bookmark.png
/usr/share/phpmyadmin/themes/original/img/b_browse.png
/usr/share/phpmyadmin/themes/original/img/b_calendar.png
/usr/share/phpmyadmin/themes/original/img/b_comment.png
/usr/share/phpmyadmin/themes/original/img/b_dbstatistics.png
/usr/share/phpmyadmin/themes/original/img/b_deltbl.png
/usr/share/phpmyadmin/themes/original/img/b_docs.png
/usr/share/phpmyadmin/themes/original/img/b_docsql.png
/usr/share/phpmyadmin/themes/original/img/b_drop.png
/usr/share/phpmyadmin/themes/original/img/b_edit.png
/usr/share/phpmyadmin/themes/original/img/b_empty.png
/usr/share/phpmyadmin/themes/original/img/b_engine.png
/usr/share/phpmyadmin/themes/original/img/b_export.png
/usr/share/phpmyadmin/themes/original/img/b_firstpage.png
/usr/share/phpmyadmin/themes/original/img/b_ftext.png
/usr/share/phpmyadmin/themes/original/img/b_help.png
/usr/share/phpmyadmin/themes/original/img/b_home.png
/usr/share/phpmyadmin/themes/original/img/b_import.png
/usr/share/phpmyadmin/themes/original/img/b_index.png
/usr/share/phpmyadmin/themes/original/img/b_info.png
/usr/share/phpmyadmin/themes/original/img/b_insrow.png
/usr/share/phpmyadmin/themes/original/img/b_lastpage.png
/usr/share/phpmyadmin/themes/original/img/b_minus.png
/usr/share/phpmyadmin/themes/original/img/b_newdb.png
/usr/share/phpmyadmin/themes/original/img/b_newtbl.png
/usr/share/phpmyadmin/themes/original/img/b_nextpage.png
/usr/share/phpmyadmin/themes/original/img/b_pdfdoc.png
/usr/share/phpmyadmin/themes/original/img/b_plus.png
/usr/share/phpmyadmin/themes/original/img/b_prevpage.png
/usr/share/phpmyadmin/themes/original/img/b_primary.png
/usr/share/phpmyadmin/themes/original/img/b_print.png
/usr/share/phpmyadmin/themes/original/img/b_props.png
/usr/share/phpmyadmin/themes/original/img/b_relations.png
/usr/share/phpmyadmin/themes/original/img/b_save.png
/usr/share/phpmyadmin/themes/original/img/b_sbrowse.png
/usr/share/phpmyadmin/themes/original/img/b_sdb.png
/usr/share/phpmyadmin/themes/original/img/b_search.png
/usr/share/phpmyadmin/themes/original/img/b_selboard.png
/usr/share/phpmyadmin/themes/original/img/b_select.png
/usr/share/phpmyadmin/themes/original/img/b_sql.png
/usr/share/phpmyadmin/themes/original/img/b_sqldoc.png
/usr/share/phpmyadmin/themes/original/img/b_sqlhelp.png
/usr/share/phpmyadmin/themes/original/img/b_tblanalyse.png
/usr/share/phpmyadmin/themes/original/img/b_tblexport.png
/usr/share/phpmyadmin/themes/original/img/b_tblimport.png
/usr/share/phpmyadmin/themes/original/img/b_tblops.png
/usr/share/phpmyadmin/themes/original/img/b_tbloptimize.png
/usr/share/phpmyadmin/themes/original/img/b_tipp.png
/usr/share/phpmyadmin/themes/original/img/b_unique.png
/usr/share/phpmyadmin/themes/original/img/b_usradd.png
/usr/share/phpmyadmin/themes/original/img/b_usrcheck.png
/usr/share/phpmyadmin/themes/original/img/b_usrdrop.png
/usr/share/phpmyadmin/themes/original/img/b_usredit.png
/usr/share/phpmyadmin/themes/original/img/b_usrlist.png
/usr/share/phpmyadmin/themes/original/img/b_view.png
/usr/share/phpmyadmin/themes/original/img/b_views.png
/usr/share/phpmyadmin/themes/original/img/bd_browse.png
/usr/share/phpmyadmin/themes/original/img/bd_deltbl.png
/usr/share/phpmyadmin/themes/original/img/bd_drop.png
/usr/share/phpmyadmin/themes/original/img/bd_empty.png
/usr/share/phpmyadmin/themes/original/img/bd_firstpage.png
/usr/share/phpmyadmin/themes/original/img/bd_ftext.png
/usr/share/phpmyadmin/themes/original/img/bd_index.png
/usr/share/phpmyadmin/themes/original/img/bd_insrow.png
/usr/share/phpmyadmin/themes/original/img/bd_lastpage.png
/usr/share/phpmyadmin/themes/original/img/bd_nextpage.png
/usr/share/phpmyadmin/themes/original/img/bd_prevpage.png
/usr/share/phpmyadmin/themes/original/img/bd_primary.png
/usr/share/phpmyadmin/themes/original/img/bd_sbrowse.png
/usr/share/phpmyadmin/themes/original/img/bd_select.png
/usr/share/phpmyadmin/themes/original/img/bd_unique.png
/usr/share/phpmyadmin/themes/original/img/error.ico
/usr/share/phpmyadmin/themes/original/img/item.png
/usr/share/phpmyadmin/themes/original/img/item_ltr.png
/usr/share/phpmyadmin/themes/original/img/item_rtl.png
/usr/share/phpmyadmin/themes/original/img/logo_left.png
/usr/share/phpmyadmin/themes/original/img/logo_right.png
/usr/share/phpmyadmin/themes/original/img/php_sym.png
/usr/share/phpmyadmin/themes/original/img/pma_logo2.png
/usr/share/phpmyadmin/themes/original/img/s_asc.png
/usr/share/phpmyadmin/themes/original/img/s_asci.png
/usr/share/phpmyadmin/themes/original/img/s_attention.png
/usr/share/phpmyadmin/themes/original/img/s_cancel.png
/usr/share/phpmyadmin/themes/original/img/s_cancel2.png
/usr/share/phpmyadmin/themes/original/img/s_db.png
/usr/share/phpmyadmin/themes/original/img/s_desc.png
/usr/share/phpmyadmin/themes/original/img/s_error.png
/usr/share/phpmyadmin/themes/original/img/s_error2.png
/usr/share/phpmyadmin/themes/original/img/s_fulltext.png
/usr/share/phpmyadmin/themes/original/img/s_host.png
/usr/share/phpmyadmin/themes/original/img/s_info.png
/usr/share/phpmyadmin/themes/original/img/s_lang.png
/usr/share/phpmyadmin/themes/original/img/s_loggoff.png
/usr/share/phpmyadmin/themes/original/img/s_notice.png
/usr/share/phpmyadmin/themes/original/img/s_okay.png
/usr/share/phpmyadmin/themes/original/img/s_partialtext.png
/usr/share/phpmyadmin/themes/original/img/s_passwd.png
/usr/share/phpmyadmin/themes/original/img/s_process.png
/usr/share/phpmyadmin/themes/original/img/s_really.png
/usr/share/phpmyadmin/themes/original/img/s_reload.png
/usr/share/phpmyadmin/themes/original/img/s_rights.png
/usr/share/phpmyadmin/themes/original/img/s_status.png
/usr/share/phpmyadmin/themes/original/img/s_tbl.png
/usr/share/phpmyadmin/themes/original/img/s_theme.png
/usr/share/phpmyadmin/themes/original/img/s_vars.png
/usr/share/phpmyadmin/themes/original/img/s_views.png
/usr/share/phpmyadmin/themes/original/img/s_warn.png
/usr/share/phpmyadmin/themes/original/img/spacer.png
/usr/share/phpmyadmin/themes/original/img/vertical_line.png
/usr/share/phpmyadmin/themes/original/img/window-new.png
/var/cache/apt/archives/phpmyadmin_4%3a2.11.3-1ubuntu1.2_all.deb
/var/lib/phpmyadmin
/var/lib/dpkg/info/phpmyadmin.conffiles
/var/lib/dpkg/info/phpmyadmin.config
/var/lib/dpkg/info/phpmyadmin.list
/var/lib/dpkg/info/phpmyadmin.md5sums
/var/lib/dpkg/info/phpmyadmin.postinst
/var/lib/dpkg/info/phpmyadmin.postrm
/var/lib/dpkg/info/phpmyadmin.preinst
/var/lib/dpkg/info/phpmyadmin.templates
/var/lib/phpmyadmin/blowfish_secret.inc.php
/var/lib/phpmyadmin/config.inc.php
ekg
ekg
Inlägg: 8
Blev medlem: 09 okt 2009, 09:57
OS: Ubuntu
Utgåva: 12.04 Precise Pangolin LTS

Re: Skapa databas med tabeller i mysql, php

Inlägg av ekg »

Hej!
Jag kör

http://localhost
http://127.0.0.1
0ch
http://127.0.1.1

alla ger svaret
It works
( filen index.html körs)

http://localhost/phpmyadmin
http://127.0.0.1/phpmyadmin
0ch
http://127.0.1.1/phpmyadmin

alla ger svaret:

Not Found

The requested URL /phpmyadmin was not found on this server.
Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.7 with Suhosin-Patch Server at 127.0.0.1 Port 80
suck
ekg
Användarvisningsbild
webaake
Inlägg: 3962
Blev medlem: 09 maj 2007, 09:46
OS: Xubuntu
Utgåva: 22.04 Jammy Jellyfish LTS

Re: Skapa databas med tabeller i mysql, php

Inlägg av webaake »

Ser ut som om du saknar denna fil: /etc/phpmyadmin/apache.conf

Hos mig har den detta innehåll:
# phpMyAdmin default Apache configuration

Alias /phpmyadmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin>
Options Indexes FollowSymLinks
DirectoryIndex index.php

# Authorize for setup
<Files setup.php>
# For Apache 1.3 and 2.0
<IfModule mod_auth.c>
AuthType Basic
AuthName "phpMyAdmin Setup"
AuthUserFile /etc/phpmyadmin/htpasswd.setup
</IfModule>
# For Apache 2.2
<IfModule mod_authn_file.c>
AuthType Basic
AuthName "phpMyAdmin Setup"
AuthUserFile /etc/phpmyadmin/htpasswd.setup
</IfModule>
Require valid-user
</Files>
<IfModule mod_php4.c>
AddType application/x-httpd-php .php

php_flag magic_quotes_gpc Off
php_flag track_vars On
php_flag register_globals Off
php_value include_path .
</IfModule>
<IfModule mod_php5.c>
AddType application/x-httpd-php .php

php_flag magic_quotes_gpc Off
php_flag track_vars On
php_flag register_globals Off
php_value include_path .
</IfModule>
</Directory>

Jag har även detta sist i /etc/apache2/apache2.conf:

Kod: Markera allt

Include /etc/phpmyadmin/apache.conf
# Blockera phpmyadmin från utsidan (WAN)
<Directory /usr/share/phpmyadmin/>
    Order deny,allow
    Allow from 192.168.0.0/24
        Deny from all
</Directory>
EDIT: mitt nätverk är 192.168.0.xxx ditt kanske är ett annat, t ex 192.168.1.xxx. Dessutom kanske du VILL komma åt phpmyadmin utifrån (WAN) och då behöver du inte blocket: <Directory ... </Directory> utan bara Include /etc/phpmyadmin/apache.conf (och ett förbannat bra lösenord)


Så testa att skapa filen /etc/phpmyadmin/apache.conf med innehållet ovan
samt lägg till sista koden precis här ovanför i /etc/apache2/apache2.conf.
Starta sedan om Apcahe med ; sudo /etc/init.d/apache2 force-reload

Hoppas det blir snurr på't nu.....
Senast redigerad av 1 webaake, redigerad totalt 14 gånger.
Xubuntu på flera maskiner. Men inte Unity!
Mer Terminalanvändande i Ubuntu vore bra. Och Xfce. Och Mate.
Användarvisningsbild
P.Forsberg
AVREGISTRERAD
Inlägg: 2573
Blev medlem: 17 jan 2008, 18:38
OS: Ubuntu
Utgåva: 23.04 Lunar Lobster
Ort: Kvarnsjön
Kontakt:

Re: Skapa databas med tabeller i mysql, php

Inlägg av P.Forsberg »

Just det. Min ser ut såhär: ( en nyinstallation )
# phpMyAdmin default Apache configuration

Alias /phpmyadmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin>
Options Indexes FollowSymLinks
DirectoryIndex index.php

<IfModule mod_php5.c>
AddType application/x-httpd-php .php

php_flag magic_quotes_gpc Off
php_flag track_vars On
php_flag register_globals Off
php_value include_path .
</IfModule>

</Directory>

# Authorize for setup
<Directory /usr/share/phpmyadmin/setup>
<IfModule mod_authn_file.c>
AuthType Basic
AuthName "phpMyAdmin Setup"
AuthUserFile /etc/phpmyadmin/htpasswd.setup
</IfModule>
Require valid-user
</Directory>

# Disallow web access to directories that don't need it
<Directory /usr/share/phpmyadmin/libraries>
Order Deny,Allow
Deny from All
</Directory>
<Directory /usr/share/phpmyadmin/setup/lib>
Order Deny,Allow
Deny from All
</Directory>
LJ
Användarvisningsbild
micke_nordin
Inlägg: 1539
Blev medlem: 21 aug 2008, 17:03
OS: Ubuntu
Utgåva: 22.10 Kinetic Kudu
Kontakt:

Re: Skapa databas med tabeller i mysql, php

Inlägg av micke_nordin »

Faktum är att det ser ut som om alla filer i /etc/ saknas. Jag har åtminstonne dessa filer som inte du har:

Kod: Markera allt

/etc/phpmyadmin
/etc/apache2/conf.d/phpmyadmin.conf
/etc/dbconfig-common/phpmyadmin.conf
/etc/phpmyadmin/apache.conf
/etc/phpmyadmin/config-db.php
/etc/phpmyadmin/config.footer.inc.php
/etc/phpmyadmin/config.header.inc.php
/etc/phpmyadmin/config.inc.php
/etc/phpmyadmin/htpasswd.setup
/etc/phpmyadmin/lighttpd.conf
/etc/phpmyadmin/phpmyadmin.service
/var/lib/ucf/cache/:etc:phpmyadmin:config-db.php
Jag föreslår att du testar att ominstallera för nått har uppenbarligen gått snett. Kör detta i terminalen:

Kod: Markera allt

sudo apt-get purge phpmyadmin && sudo apt-get autoremove && sudo apt-get install phpmydmin
/Micke
Skriv svar

Återgå till "Programmering och webbdesign"