Welcome Guest!
Please login
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.
![]() ![]() |
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 |
|
|
Oct 30 2008, 05:26 AM
Post
#2
|
|
![]() Squeeze Machine ![]() 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/
|
|
|
Oct 30 2008, 05:37 AM
Post
#3
|
|
![]() Squeeze Machine ![]() Posts: 766 Joined: 13-February 08 From: Catching the squeezed drips downunder. |
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. -------------------- |
|
|
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 |
|
|
Oct 30 2008, 05:46 AM
Post
#5
|
|
![]() Squeeze Machine ![]() 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. -------------------- |
|
|
Oct 30 2008, 05:55 AM
Post
#6
|
|
|
Rapid Squeezer ![]() ![]() ![]() ![]() Posts: 146 Joined: 30-May 08 From: London |
|
|
|
Oct 30 2008, 06:00 AM
Post
#7
|
|
![]() Squeeze Machine ![]() 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. -------------------- |
|
|
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 |
|
|
Oct 30 2008, 06:20 AM
Post
#9
|
|
![]() Squeeze Machine ![]() 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.
-------------------- |
|
|
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"
|
|
|
Oct 30 2008, 07:08 AM
Post
#11
|
|
![]() Squeeze Machine ![]() 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/
|
|
|
Oct 30 2008, 07:56 AM
Post
#12
|
|
|
Rapid Squeezer ![]() ![]() ![]() ![]() Posts: 146 Joined: 30-May 08 From: London |
Thanks japh, that's done.
|
|
|
Oct 30 2008, 08:05 AM
Post
#13
|
|
![]() Squeeze Machine ![]() 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
-------------------- The more you visit, the more I'll post: http://japheththomson.com/
|
|
|
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 |
|
|
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? |
|
|
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? |
|
|
Oct 30 2008, 02:08 PM
Post
#17
|
|
![]() Don deluzione ![]() Posts: 1,175 Joined: 13-February 08 From: Canada eh? |
I always wanted to say this: Read the manual!
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! -------------------- |
|
|
Oct 30 2008, 05:12 PM
Post
#18
|
|
![]() Squeeze Machine ![]() 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/
|
|
|
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 |
|
|
Oct 30 2008, 07:03 PM
Post
#20
|
|
![]() Squeeze Machine ![]() 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/
|
|
|
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!






Oct 30 2008, 05:11 AM










