Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Installing Joomla on Yahoo! Small Business Hosting - MySQL error

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

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. . .
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Suggested Courses

972 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