Database info

[tostrye]

I am installing Magento and I need the Database conection information. I have a database "magento" on my domain "claszi" and user "claszi"

[cPanelJared]

I am not quite sure what you are asking. You can create a database in cPanel, and the database name, database username, and password are what you provide to the site script installer. Can you explain in more detail what piece of information you are missing?

[tostrye]

I am trying to install Magento, I cannot connect to the database. I created the database with the MySQL wizard. The database is with the domain claszi.com and so is the user.

Host: localhost
Databese: claszi_magento
User: (I own the server) root

Every other option is default, but I keep getting database connection error. What am I doing wrong?

[LinuxTechie]

Hey,

Please do the below given steps.

>> Enter mysql by typing the command mysql.
>> After that grant privileges for the database over the user.

Syntax : grant all privileges on database .* to user@localhost identified by 'password';

[tostrye]

I have all the priveledges, I still get the error.

[tostrye]

I'm not sure what I'm missing. I'm installing magento on the domain claszi.com
Host: localhost
Databese: claszi_magento
User: (I own the server) root

I have all privileges enabled and everything

[LinuxTechie]

Hey,

Do your configuration file have the username, password and database info?

One more thing, can you create another user than root from the cpanel and try again. I thinks it is causing the issue.

[cPanelJared]

I'm not sure what I'm missing. I'm installing magento on the domain claszi.com
Host: localhost
Databese: claszi_magento
User: (I own the server) root

Your site software should not be using the user root to connect to its database. You should instead be using the database user that you created in cPanel for the database. It appears you have already created a database; have you also created a user and assigned that user to the database? The user you create in cPanel is what you should be giving Magento to connect to its database, not root.

The following annotated image from the MySQL Databases page may help you:

http://i54.tinypic.com/332ry2p.png

Also, you may find the following section of our documentation helpful:

MySQL Databases

[cPanelJared]

I merged your two threads seeking assistance on the same issue into a single thread, to get more exposure for your questions and consolidate replies into a single thread.

[ntslik]

Hi, Having same issue, searching the web I have discovered a couple of possible issues, someone has mentioned for magento that the database name or password can not contain any characters, I think they are referring to the _ that appears to be tagged on the end, so first question, is there a way of removing this underscore??

[cPanelTristan]

You could try to connect using the cPanel username and password instead for the script if Magento won't accept any underscore for it. The cPanel username and password should have a MySQL granted connection for any of the databases on your account.