Unable to connect mysql

Having exactly the same problem, as I am on a dedicated server, when I login from my main site to the development it tells me I am logged in as root so I then log out and log back in, but when I tried to install joomla with the desktop installation, it cannot connect to mysql server and I am using database name eg develda_joomla1 and joomla1 is the database name, and also when I have to use username is that root or is that the user username and pword.
Hope this hasnt confused things as I am confused.

Also I have updated the cpanel to the new x3 but now all the database tables run in together in the cpanel, when I check them in the WHM they are in a nice neat row but in the cpanel both my development and live site have all the tables run across the page into each other.

Help

 

If you created the DB for the user develda you will use the same prefix for the username as for the db. You will also need to create that username and password and then assign them to the DB develda_Joomla1 before you can access.

 

This is a problem with the MySQL version that cPanel is using. MySQL 5.0.45 has a bug which won't allow Joomla 1.5 to install.

Look here: http://help.joomla.org/content/view/1938/310/

So, either cPanel needs to upgrade to 5.0.8 or downgrade to 5.0.2

 

I see nothing on that page that says there's a problem with mysql or I need my glasses changing?

 

/me offers to clean poolking's glasses

Scroll down...

 

Read again that says PHP you said MYSQL

 

Hi,

check the database user privilege. check whether you can access the database from shell.
----
mysql -u username -p
----

 

One of my clients is seeing a simular issue. This is our problem.

1) Created an addon domain (account has this ability)
2) used Fantastico to install Wordpress
3) After fantastico install completes sucessfully it produces an error when visiting the site. "Error establishing a database connection". Since fantastico setup the DB and the DB User and the password I can only assume they are right.

But I have also gone and removed the user DB user account and created it again with a shorter password and then edited the wordpress conf file to reflect this change. Still no access.

As suggested above I can connect to mysql from the command line with the username and password. I can even do a DB dump from the command line of the specific mysql database.

 

fix privileges

You want to try running the following script to correct any privileges problems:

/usr/bin/mysql_fix_privilege_tables

 

any advice on how to execute this script?

 

SSH into the server as the root user, then type the command exactly as listed above and press enter/return. Make sure you're doing this as root.


Most of the time the error in this thread is due to bad access credentials. It's likely that the user trying to access MySQL is not granted privileges to access the specific database you are trying to connect to.

Usually the following commands will fix this when logged into SSH as the cPanel user:

Code:

#mysql -u cpuser -p
#GRANT ALL on databasename.* TO 'user'@'hostname' IDENTIFIED BY 'password';

You need to replace the following variables:

cpuser - your cPanel username
databasename - name of the Joomla database
user - username to access the Joomla database (in Joomla configuration file)
hostname - typically 'localhost' unless MySQL is running on a remote server, if it is, the hostname of that remote server
password - password for user