Solved

Installing Joomla on Yahoo! Small Business Hosting - MySQL error

Posted on 2010-09-12
5
1,749 Views
Last Modified: 2013-12-13
Hello!

I'm in the process of installing Joomla on a Yahoo! Small Business Hosting service that my client has.  I created a user and password for the database and installed phpMyAdmin to manage the databases.  When I get to the part of the installation script for Joomla that requires the script connect with the database i get the following code (snippet attached).

I know this means that the script is actually connecting with the database but i'm unclear as to what is happening now.  Has anyone ever encountered this before?  Please offer any assistance you can.  

Thank you.


Access denied for user 'adminaka1919'@'localhost' to database 'mysql' SQL=CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(30) NOT NULL default 'banner', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `date` datetime default NULL, `showBanner` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `custombannercode` text, `catid` INTEGER UNSIGNED NOT NULL DEFAULT 0, `description` TEXT NOT NULL DEFAULT '', `sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `ordering` INTEGER NOT NULL DEFAULT 0, `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `tags` TEXT NOT NULL DEFAULT '', `params` TEXT NOT NULL DEFAULT '', PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), INDEX `idx_banner_catid`(`catid`) ) TYPE=MyISAM CHARACTER SET `utf8`

Open in new window

0
Comment
Question by:vfleary
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 33658808
Probably wrong database name.  Unlikely that your database is named 'mysql'.
0
 

Author Comment

by:vfleary
ID: 33658918
It actually is.  Changed it from localhost on the config document AND the auto install.  No dice.
0
 

Author Comment

by:vfleary
ID: 33658923
Sorry - on Yahoo - both the host name and the default database name are "mysql"  I even created a separate db with phpmyAdmin with a different name and tried that.  Still nothing.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 33658977
Here's an article about the database problem: http://groups.google.com/group/joomlaug/browse_thread/thread/3a9e6e21ea6874c0/c5b7c7765b3461fb

There are many articles about problems with Joomla and Yahoo hosting.  No '.htaccess' or FTP thru PHP allowed.  Business hosting may be different.  ??
0
 

Accepted Solution

by:
vfleary earned 0 total points
ID: 33659035
Thank you so much for that DaveBaldwin - the issue was based in the lack of permissions given to the user I created in phpMyAdmin for yahoo's databases.  I found this solution which looks like it worked:

In the phpMyAdmin Privileges page, on the same row as the yroot user, click on the symbol of a human with a pencil.
Scroll down and change the password to another memorable password. Keep this password for future reference.
Now log out of phpMyAdmin.
Log back in again, but this time with the username yroot.
Use the password that you just changed for yroot.
Go to the Privileges page.
On the same row as cms_user, click on the symbol of a human with a pencil.
In the 'Edit Privileges' section, Check All Global Privileges.
Press the Go button.

Worked great!
0

Featured Post

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses four methods for overlaying images in a container on a web page
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question