Installing Joomla on Yahoo! Small Business Hosting - MySQL error

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

vflearyAsked:
Who is Participating?
 
vflearyConnect With a Mentor Author Commented:
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
 
Dave BaldwinFixer of ProblemsCommented:
Probably wrong database name.  Unlikely that your database is named 'mysql'.
0
 
vflearyAuthor Commented:
It actually is.  Changed it from localhost on the config document AND the auto install.  No dice.
0
 
vflearyAuthor Commented:
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
 
Dave BaldwinFixer of ProblemsCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.