Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Installing Joomla on Yahoo! Small Business Hosting - MySQL error

Posted on 2010-09-12
5
Medium Priority
?
1,828 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 84

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 84

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 expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

564 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