phpmyadmin

Have a question and don't want to sift through Wiki?
Ask away!
LRW
Banned
Posts: 6708
Joined: 28 Mar 11, 11:33
Favourite Driver: H.A.M
Favourite Team: AMG P-Dog
Location: in a glass case of emotion

phpmyadmin

Postby LRW »

I dont get it.

Im trying to play with a new energy monitoring system at work, and one of the steps has me stumped. it says:

Create a MYSQL database - The easiest way to do this via a GUI is through a program called phpmyadmin. The default login is username root with no password. If you have a shared server you may need to do this through another mysql database setup program before you can access the database through phpmyadmin.

To create a database in phpmyadmin, click on Databases at the top, then enter 'emoncms' in the text input box and click create.

When, in phpmyadmin, the database has been created, a new user must also be created on host "localhost" (not "%") and have a password set. When the user has been created, the user needs to have "all" privileges over the new database that has just been created (scroll down for Database-specific privileges). Those 4 items - the new user name, password, "localhost" and database name are the values that go into the settings.php file.

Note: this user isn't necessarily the same as one of the users who are allowed to register in emoncms once it's running.


Ive downloaded the 'phpmyadmin' zip file. But there seems to be no GUI for it. I dont know how to access it to create the database.

Please someone spray me with you geek juice, and help me understand. Otherwise this laptop is going out the window.
Image
CookinFlat6
Banned
Posts: 7206
Joined: 21 Apr 12, 21:22
Favourite Driver: Hamiltonian
Favourite Team: HDL
Location: Banned

Re: phpmyadmin

Postby CookinFlat6 »

from what I know the phpadmin is a Gui for a server based mysql database, but you gotta have a full web install to access it. You can access from a pc, only through the isps management console

i found that out the hard way recently when I accidently deleted the admin user on a site and couldnt get back on it

but i am a an amatuer so you probably know that part already
Image
2014 Monster 26x Bookie Mugger
2015, 2016 WDC: LH44
LRW
Banned
Posts: 6708
Joined: 28 Mar 11, 11:33
Favourite Driver: H.A.M
Favourite Team: AMG P-Dog
Location: in a glass case of emotion

Re: phpmyadmin

Postby LRW »

Nope. I am in no way IT based, and am in way over my head.
Image
User avatar
myownalias
Mod
Posts: 9445
Joined: 27 May 09, 23:16
Favourite Driver: Jenson Button
Favourite Team: Williams
Location: Wichita, KS

Re: phpmyadmin

Postby myownalias »

phpmyadmin runs as a web service, you need a working webserver such as apache and php installed before you can install phpmyadmin.

The quickest way to set all this up is to install WAMP, http://www.wampserver.com/en/ for Windows, or MAMP, http://www.mamp.info/en/ for Mac OS.

This process installs phpmyadmin for you!
myownaliasThe Englishman in KansasTwitter: @myownalias
What's Burning?
Banned
Posts: 21486
Joined: 24 Feb 10, 00:09
Favourite Driver: Lewis Hamilton, Nico Hulkenberg
Favourite Team: Porsche North America, Porsche LMP1
Location: PULL IN CASE OF FIRE

Re: phpmyadmin

Postby What's Burning? »

energy monitoring system?
"I don't want to be part of a forum where everyone has differing opinions." Boom...
LRW
Banned
Posts: 6708
Joined: 28 Mar 11, 11:33
Favourite Driver: H.A.M
Favourite Team: AMG P-Dog
Location: in a glass case of emotion

Re: phpmyadmin

Postby LRW »

So Ive installed WAMPSERVER.

I just dont get how I create the database as requested in that step above

Im sorry. I feel like RC now.

Im following this guide - http://emoncms.org/site/docs/installwindows - Ivbe got to the end of step 3, and im just stumped.
Last edited by LRW on 30 Jul 14, 15:20, edited 1 time in total.
Image
LRW
Banned
Posts: 6708
Joined: 28 Mar 11, 11:33
Favourite Driver: H.A.M
Favourite Team: AMG P-Dog
Location: in a glass case of emotion

Re: phpmyadmin

Postby LRW »

What's Burning? wrote:energy monitoring system?


building metering
Image
User avatar
myownalias
Mod
Posts: 9445
Joined: 27 May 09, 23:16
Favourite Driver: Jenson Button
Favourite Team: Williams
Location: Wichita, KS

Re: phpmyadmin

Postby myownalias »

I don't have wamp installed on this machine currently so I can't check, but from memory, type "localhost" into your browser which should bring up the wamp page, from there you should see a link to phpmyadmin...

Image
myownaliasThe Englishman in KansasTwitter: @myownalias
User avatar
racechick
Missing Mod
Posts: 23581
Joined: 03 Aug 07, 11:08
Favourite Driver: Lewis Hamilton
Favourite Team: Mercedes AMG Petronas
Location: Nottinghham UK

Re: phpmyadmin

Postby racechick »

Don't worry LRW, you're nowhere near my level. I thought Gui were those really nice desserts you get at Sainsburys and Tesco!
You can fool all the people some of the time, and some of the people all the time, but you cannot fool all the people all the time.
Abe Lincoln


Nearly all men can stand adversity, but if you want to test a man's character, give him power. Abe Lincoln
User avatar
Jabberwocky
Mod
Posts: 16412
Joined: 31 Jul 07, 19:51
Favourite Driver: 5 Iron
Favourite Team: Williams
Location: Oxford

Re: phpmyadmin

Postby Jabberwocky »

have you installed WAMP onto the machine you are using or a remote server?
Image
A racing car that does not win, is just art
RyRy
Posts: 1115
Joined: 30 Aug 09, 11:53

Re: phpmyadmin

Postby RyRy »

racechick wrote:Don't worry LRW, you're nowhere near my level. I thought Gui were those really nice desserts you get at Sainsburys and Tesco!

RC you my dear are so cute.

Also LRW, don't feel too bad it's not a common thing to do so not many know about sql and phpmyadmin

Sent from my Nexus 4
LRW
Banned
Posts: 6708
Joined: 28 Mar 11, 11:33
Favourite Driver: H.A.M
Favourite Team: AMG P-Dog
Location: in a glass case of emotion

Re: phpmyadmin

Postby LRW »

Jabberwocky wrote:have you installed WAMP onto the machine you are using or a remote server?


Im just trying to get it all working on my local machine first - just to test the functionality of it -but I believe for the end client it will be on one of their central servers.

myownalias wrote:I don't have wamp installed on this machine currently so I can't check, but from memory, type "localhost" into your browser which should bring up the wamp page, from there you should see a link to phpmyadmin...


Ok - i'll give that a go. A lot of applications I use, have a web interface, using the 'localhost' command. As default Vmware occupies that, and I have to stop the Vmware services via task manager, to release it. I'll give it a go and report back.

EDIT: Nope - Once I stop the Vmware services, and restart the wampserver services (via wampserver icon in the system tray), the localhost in my webbrowser just comes up with.......

localhost.jpg


There is a shortcut from the wampserver icon in the sytem tray that tries to take me to 'localhost/phpmyadmin/' - but that also takes me to'web page not available' screen.

Is there a way to ensure 'localhost' or 'localhost/phpmyadmin/' is redirecting to the right place? I always thought you assigned 'localhost' in hosts file (C:\Windows\System32\drivers\etc), but I dont know - now Im thinking thats for network addresses only? Im drowning.
You do not have the required permissions to view the files attached to this post.
Image
User avatar
Stephen
Site Admin
Posts: 2199
Joined: 24 Sep 05, 12:47
Favourite Driver: Kimi Raikkonen
Favourite Team: McLaren

Re: phpmyadmin

Postby Stephen »

Try other ports like localhost:80/phpmyadmin.

I use IIS for Windows based test environments and it's just a case of putting phpmyadmin in the /inetpub directory (in a sub-directory) and running the install. phpmyadmin will need something to connect to (ie mysql) before you can do anything with it.

There's a great guide here which shows how easy IIS is to configure (it also features mysql):
[youtube]6PRq7CmiWhM[/youtube]
User avatar
myownalias
Mod
Posts: 9445
Joined: 27 May 09, 23:16
Favourite Driver: Jenson Button
Favourite Team: Williams
Location: Wichita, KS

Re: phpmyadmin

Postby myownalias »

Try changing Apache's port number in httpd conf; see link:

http://httpd.apache.org/docs/2.2/bind.html

You should see a link to httpd conf in the system tray menu.
myownaliasThe Englishman in KansasTwitter: @myownalias