How to create database? phpMyAdmin Error 1044.

**iggyboy** · September 3rd, 2004, 7:42 AM

please somebody tell me how to get rid of this 1044 error in phpMyAdmin. Below is the full error list

Code:

Error

SQL-query : 

CREATE DATABASE `mambo_mysql` ;

MySQL said:
#1044 - Access denied for user: 'iggyboy[at]localhost' to database 'mambo_mysql'

i have spent almost half a day trying to understand the database thingy, but hardly got a single thing right.

I also uploaded and set all the files/folder to correct CHMOD for Mambo Ver4.5 Stable1.0.9 and PHP-Nuke Ver7.4, but both fail to create database automatically.

PHP-Nuke ver7.4 gives below error

Code:

There seems to be a problem with the MySQL server, sorry for the inconvenience.

I know scripta includes both PHP-Nuke and Mambo, i have installed PHP-Nuke using scripta and tested, found okey, but got few tiny annoying bugs, guess it resultant from my own module upgrading.

Btw... is it legal and okey to upload both mambo and PHP-Nuke in my site for mostly testing and tweeking purposes. I ask this question because scripta already included the programs.

Anyway, can somebody guide me to undo the error message, i have search through the forum but not really can get any solution yet.

thank you in advance.

**sam** · September 3rd, 2004, 2:07 PM

iggyboy - you can create database through the mysqladmin tool on the front page of cPanel.

phpMyAdmin doesn't pass the right permissions to the MySQLServer to create databases - it's not anything wrong with your account - but that's why it's failing.

after you create the database - you need to add a user to it. you can do this from mySQL admin as well.

hope that helps.

**iggyboy** · September 3rd, 2004, 8:30 PM

thankx for the reply Sam, it works... really great

Regards,
iggyboy

**sam** · September 3rd, 2004, 9:49 PM

thanks for the followup iggyboy

good luck with your site / dbs.

September 3rd, 2004, 7:42 AM	#1 (permalink)
iggyboy Surpass Fan Seasoned Poster Joined in Jul 2004 30 posts Gave thanks: 0 Thanked 0 times	How to create database? phpMyAdmin Error 1044. please somebody tell me how to get rid of this 1044 error in phpMyAdmin. Below is the full error list Code: Error SQL-query : CREATE DATABASE `mambo_mysql` ; MySQL said: #1044 - Access denied for user: 'iggyboy[at]localhost' to database 'mambo_mysql' i have spent almost half a day trying to understand the database thingy, but hardly got a single thing right. I also uploaded and set all the files/folder to correct CHMOD for Mambo Ver4.5 Stable1.0.9 and PHP-Nuke Ver7.4, but both fail to create database automatically. PHP-Nuke ver7.4 gives below error Code: There seems to be a problem with the MySQL server, sorry for the inconvenience. I know scripta includes both PHP-Nuke and Mambo, i have installed PHP-Nuke using scripta and tested, found okey, but got few tiny annoying bugs, guess it resultant from my own module upgrading. Btw... is it legal and okey to upload both mambo and PHP-Nuke in my site for mostly testing and tweeking purposes. I ask this question because scripta already included the programs. Anyway, can somebody guide me to undo the error message, i have search through the forum but not really can get any solution yet. thank you in advance.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

September 3rd, 2004, 2:07 PM	#2 (permalink)
sam Surpass Fan Super #1 Joined in Dec 2003 Lives in NJ 5,057 posts Gave thanks: 0 Thanked 4 times	iggyboy - you can create database through the mysqladmin tool on the front page of cPanel. phpMyAdmin doesn't pass the right permissions to the MySQLServer to create databases - it's not anything wrong with your account - but that's why it's failing. after you create the database - you need to add a user to it. you can do this from mySQL admin as well. hope that helps.

September 3rd, 2004, 8:30 PM	#3 (permalink)
iggyboy Surpass Fan Seasoned Poster Joined in Jul 2004 30 posts Gave thanks: 0 Thanked 0 times	thankx for the reply Sam, it works... really great Regards, iggyboy

September 3rd, 2004, 9:49 PM	#4 (permalink)
sam Surpass Fan Super #1 Joined in Dec 2003 Lives in NJ 5,057 posts Gave thanks: 0 Thanked 4 times	thanks for the followup iggyboy good luck with your site / dbs.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)