Welcome Guest!

If you do not have an account yet on The Web Squeeze forums, please Register! It’s FREE and there are many benefits:

  • Receive Fast Advice
  • Learn Programming Languages
  • Get Professional Website Reviews
  • Quick Troubleshooting Assistance

> Help Setting Up A Data Base (installing Magento)

This is a discussion on Help Setting Up A Data Base (installing Magento), within the MySQL section. This forum and the thread "Help Setting Up A Data Base (installing Magento)" are both part of the Programming Your Website category.

2 Pages V   1 2 >  
Reply to this topicStart new topic
> Help Setting Up A Data Base (installing Magento)
Jacob.R
post Oct 30 2008, 05:11 AM
Post #1


Rapid Squeezer
****

Posts: 146
Joined: 30-May 08
From: London


In phpmyadmin, 'No Privileges' is showing, does this mean I have to contact the host company to allow privileges before creating a data base?

This post has been edited by Jacob.R: Oct 30 2008, 05:12 AM
Go to the top of the page
 
+Quote Post
japh
post Oct 30 2008, 05:26 AM
Post #2


Squeeze Machine
Group Icon

Posts: 508
Joined: 7-October 08
From: Australia


Jacob, what sort of control panel do you use with your hosting company? Plesk, or cPanel, or something else?

It sounds like you may need to ask your hosting company for some assistance getting the database going.


--------------------
The more you visit, the more I'll post: http://japheththomson.com/
Go to the top of the page
 
+Quote Post
Rakuli
post Oct 30 2008, 05:37 AM
Post #3


Squeeze Machine
Group Icon

Posts: 766
Joined: 13-February 08
From: Catching the squeezed drips downunder.


QUOTE (Jacob.R @ Oct 30 2008, 09:11 PM) *
In phpmyadmin, 'No Privileges' is showing, does this mean I have to contact the host company to allow privileges before creating a data base?


Generally through cPanel, when you log into phpmyadmin, your cpanel user id does not have any privileges. You need to go in through cPanel -> databases and create a database and database user.

This, of course, is assuming you are using cPanel.


--------------------
Luke Dingle . com

Turn Over a Playful Leaf on Web Design -- read about the javascript cat
Go to the top of the page
 
+Quote Post
Jacob.R
post Oct 30 2008, 05:43 AM
Post #4


Rapid Squeezer
****

Posts: 146
Joined: 30-May 08
From: London


My host says, "You should use your current database for it - capoeiracanal and it should create all the needed tables there.. "

This post has been edited by Jacob.R: Oct 30 2008, 05:43 AM
Go to the top of the page
 
+Quote Post
Rakuli
post Oct 30 2008, 05:46 AM
Post #5


Squeeze Machine
Group Icon

Posts: 766
Joined: 13-February 08
From: Catching the squeezed drips downunder.


So it is cPanel you're using or another hosting control panel?

If you're trying to get Magento to install, have you entered your hosting username and password in as database user and password? Then use capoeiracanal as the database name.


--------------------
Luke Dingle . com

Turn Over a Playful Leaf on Web Design -- read about the javascript cat
Go to the top of the page
 
+Quote Post
Jacob.R
post Oct 30 2008, 05:55 AM
Post #6


Rapid Squeezer
****

Posts: 146
Joined: 30-May 08
From: London


Does this help?
Attached File(s)
Attached File  phpmyadmin.gif ( 33.69K ) Number of downloads: 9
 
Go to the top of the page
 
+Quote Post
Rakuli
post Oct 30 2008, 06:00 AM
Post #7


Squeeze Machine
Group Icon

Posts: 766
Joined: 13-February 08
From: Catching the squeezed drips downunder.


It helps a little. It doesn't say what hosting CP you're using but it does say that your hosting account is only allowed one database. You would have full privileges on the capoeiracanal database.

All you need to do is use whatever username and password you used to log into phpmyadmin as the username and password for the database details in Magento.


--------------------
Luke Dingle . com

Turn Over a Playful Leaf on Web Design -- read about the javascript cat
Go to the top of the page
 
+Quote Post
Jacob.R
post Oct 30 2008, 06:06 AM
Post #8


Rapid Squeezer
****

Posts: 146
Joined: 30-May 08
From: London


Hi Rakuli, I have not downloaded Magento yet, I will do so, then try and set the permissions. After that I will go to the the Magento installation wizard located here: www.mysite/magento/

Does this seem right?

This post has been edited by Jacob.R: Oct 30 2008, 06:08 AM
Go to the top of the page
 
+Quote Post
Rakuli
post Oct 30 2008, 06:20 AM
Post #9


Squeeze Machine
Group Icon

Posts: 766
Joined: 13-February 08
From: Catching the squeezed drips downunder.


I haven't used Magento myself but that sounds like a good plan. biggrin.gif


--------------------
Luke Dingle . com

Turn Over a Playful Leaf on Web Design -- read about the javascript cat
Go to the top of the page
 
+Quote Post
Jacob.R
post Oct 30 2008, 06:32 AM
Post #10


Rapid Squeezer
****

Posts: 146
Joined: 30-May 08
From: London


Host says, "we are not using any web based administrative panel for server services at the moment"
Go to the top of the page
 
+Quote Post
japh
post Oct 30 2008, 07:08 AM
Post #11


Squeeze Machine
Group Icon

Posts: 508
Joined: 7-October 08
From: Australia


Jacob, just loked at your screenshot. You will need to click on your capoeiracanal database (listed on the left side), then select all the tables it already has there from the osCommerce install and delete them, otherwise you may get conflicts when installing Magento (maybe not, but better to be safe).


--------------------
The more you visit, the more I'll post: http://japheththomson.com/
Go to the top of the page
 
+Quote Post
Jacob.R
post Oct 30 2008, 07:56 AM
Post #12


Rapid Squeezer
****

Posts: 146
Joined: 30-May 08
From: London


Thanks japh, that's done.
Go to the top of the page
 
+Quote Post
japh
post Oct 30 2008, 08:05 AM
Post #13


Squeeze Machine
Group Icon

Posts: 508
Joined: 7-October 08
From: Australia


Great work! Now I'd recommend you download a copy of Magento, and follow the user installation guide carefully smile.gif


--------------------
The more you visit, the more I'll post: http://japheththomson.com/
Go to the top of the page
 
+Quote Post
Jacob.R
post Oct 30 2008, 09:55 AM
Post #14


Rapid Squeezer
****

Posts: 146
Joined: 30-May 08
From: London


It's Taking ages to upload!


I am confused about the permissions. Should my host's server set them or should I do that in the files?

Taken from Magento install:

4. The top-level Magento directory (the one you uploaded the decompressed files to) must have the correct permissions in order for the installer to proceed. To do so, navigate to the directory with your FTP client. Then locate the function “Change Permissions” or “Change Mode” in your FTP client and select it. Once you find the function, you must set the permissions so the web server can write to this file. There are two typical ways of representing file permissions in Linux:

*
As a number (eg, 755)
*
As a series of permissions categorized into user, group, and other

If your FTP client uses the first representation, set the permissions on the directory to be 777, or 0777.

This post has been edited by Jacob.R: Oct 30 2008, 09:56 AM
Go to the top of the page
 
+Quote Post
Jacob.R
post Oct 30 2008, 12:25 PM
Post #15


Rapid Squeezer
****

Posts: 146
Joined: 30-May 08
From: London


QUOTE
If you're trying to get Magento to install, have you entered your hosting username and password in as database user and password? Then use capoeiracanal as the database name.


Please explain more, where do I enter the hosting username and password?
Go to the top of the page
 
+Quote Post
Jacob.R
post Oct 30 2008, 12:39 PM
Post #16


Rapid Squeezer
****

Posts: 146
Joined: 30-May 08
From: London


Magento is uploaded on the server

Permissions are set

I have a database created for it but it is empty, where do I go from here?

Go to the top of the page
 
+Quote Post
Mark
post Oct 30 2008, 02:08 PM
Post #17


Don deluzione
Group Icon

Posts: 1,175
Joined: 13-February 08
From: Canada eh?


I always wanted to say this: Read the manual! smile.gif

There has to be a document or a link to an online manual for Magento.. Follow the steps on installing Magento in there and your database should be filled after the install..

Oh, look what I found!


--------------------
Go to the top of the page
 
+Quote Post
japh
post Oct 30 2008, 05:12 PM
Post #18


Squeeze Machine
Group Icon

Posts: 508
Joined: 7-October 08
From: Australia


Jacob, it looks to me like you're up to step 6 of this part of the guide: Default Install


--------------------
The more you visit, the more I'll post: http://japheththomson.com/
Go to the top of the page
 
+Quote Post
Jacob.R
post Oct 30 2008, 06:50 PM
Post #19


Rapid Squeezer
****

Posts: 146
Joined: 30-May 08
From: London


japh, no I am stuck on step 4, I see the directories that are meant to be given new permissions, but can't locate the function “Change Permissions” or “Change Mode” in Macromedia.

This post has been edited by Jacob.R: Oct 30 2008, 06:51 PM
Go to the top of the page
 
+Quote Post
japh
post Oct 30 2008, 07:03 PM
Post #20


Squeeze Machine
Group Icon

Posts: 508
Joined: 7-October 08
From: Australia


Go to remote view, and right-click on the appropriate directory, then you want "Set permissions...", I believe


--------------------
The more you visit, the more I'll post: http://japheththomson.com/
Go to the top of the page
 
+Quote Post
If you found The Web Squeeze to be helpful, please donate so we can keep this site FREE, FRESH, and fortified with Web Design & Development info!
2 Pages V   1 2 >