Solved

Installing Joomla on Yahoo! Small Business Hosting - MySQL error

Posted on 2010-09-12
5
1,710 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
  • 3
  • 2
5 Comments
 
LVL 82

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 82

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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
The viewer will learn how to count occurrences of each item in an array.
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.

747 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now