SitePoint Sponsor

User Tag List

Results 1 to 7 of 7

Thread: Help with MySQL

  1. #1
    SitePoint Member
    Join Date
    Dec 2007
    Posts
    15
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help with MySQL

    Hi,

    Just testing an ecommerce shopping cart on a free hosting site.... I've got all the files uploaded and have just created a database and username with the site's basic control panel...

    now as I am trying to install the Shopping cart, the only problem I have is with the entry for "Database Hostname"

    Where do I find what I am supposed to put in for that entry? I have tried putting just "localhost" but that still gives me an error:

    Code:
    The database details you entered are incorrect: Access denied for user 'deevius_store'@'layeredpaneltest1.free-site-host.com' (using password: YES)
    I have PHPMyAdmin available, can someone please tell me how I find what exactly I am supposed to put for the "Database Hostname"?

    The free hosting site I am using by the way is: http://www.free-site-host.com/

  2. #2
    SitePoint Member
    Join Date
    Dec 2007
    Posts
    15
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    meh wrong section, sorry

  3. #3
    SitePoint Member
    Join Date
    Dec 2007
    Posts
    15
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help with MySQL please: Very basic problem

    Hi,

    Just testing an ecommerce shopping cart on a free hosting site.... I've got all the files uploaded and have just created a database and username with the site's basic control panel...

    now as I am trying to install the Shopping cart, the only problem I have is with the entry for "Database Hostname"

    Where do I find what I am supposed to put in for that entry? I have tried putting just "localhost" but that still gives me an error:

    The database details you entered are incorrect: Access denied for user 'deevius_store'@'layeredpaneltest1.free-site-host.com' (using password: YES)
    I have PHPMyAdmin available, can someone please tell me how I find what exactly I am supposed to put for the "Database Hostname"?

    The free hosting site I am using by the way is: http://www.free-site-host.com/

  4. #4
    Guru in training bronze trophy SoulScratch's Avatar
    Join Date
    Apr 2006
    Location
    Maryland
    Posts
    1,838
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Usually it's localhost unless they're using a remote database IP which only the host would know. Have you tried emailing them?
    Cross browser css bugs

    Dan Schulz you will be missed

  5. #5
    SitePoint Addict
    Join Date
    Oct 2008
    Posts
    224
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The error you receive is :

    user 'deevius_store'@'layeredpaneltest1.free-site-host.com'

    The db server should be localhost itself, that is the normal format for the database servers.Make sure that you have added the user store to the db created with full privileges as well.
    ------------
    hzSari | HostingZoom.com
    ModVPS.com | ResellerZoom.com
    Power Speed Reliability

  6. #6
    Use The Cloud
    Join Date
    Jan 2006
    Location
    Boise, ID
    Posts
    556
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    http://www.free-site-host.com/faq.jsp#52

    5.2 How do i create a MYSQL database?

    Please login to your panel and then click the create/delete mysql database button

    1. First type a database name in the create database section and click create database.
    2. Then create a username and password in the create user section. (note these do not have to be the same as your account username and password)
    3. Then assign full privlidges to this user for this database in the create privlidges section by clicking assign privlidges

    your database name should look like: abcabc_abc
    your database username should look like: abcabc_abc
    your database password should be whatever you set it to

    NOTE: you MUST assign privilidges for the database to work.

    5.3 How do i connect to MYSQL?

    To connect to mysql you must use the following details

    database name = username_dbname
    database user = username_dbuser
    host = localhost
    port = default
    database password = dbpassword

    NOTE: replace the values dbname, dbuser and dbpassword with their real values, you must have created this database and assigned privlidges, see the article above for more information on this.
    Brad Hanson, Web Applications & Scalability Specialist
    ► Is your website outgrowing its current hosting solution?
    ► PM me for a FREE scalability consult!
    ► USA Based: Available by Phone, Skype, AIM, and E-mail.

  7. #7
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,215
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Electrix View Post
    meh wrong section, sorry
    should this ever happen again, please contact a moderator for the forum you posted in, and ask that the thread be moved

    otherwise we will merge the threads, like this time, which sometimes results in weird effects when the posts are interleaved
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •