Problems with MySQL in control panel

EtoCaNNa

Registered
Jul 24, 2003
4
0
151
Having trouble adding databases and users in mysql through cpanel. Cpanel is telling me said databases and users are being added but when I return to MySQL home there's nothing there.

Thanks!
 

chadi

BANNED
Apr 20, 2004
415
0
166
It says "added" and then sometimes "Sorry no more user database available" (not exact words but to that effect).

If so, that simply means the user used up all databases. Adjust the account to increase the databases allowed.
 

EtoCaNNa

Registered
Jul 24, 2003
4
0
151
It is not, it happens to me in all the accounts. In phpmyadmin yes can I create users y BD, but panel not.

Thanks!!
 

DJDarknez

Member
Aug 23, 2004
6
0
151
Chicago
I'm having the same exact problem, which is the main reason I registered here.

I add a DB, it says it added the DB, but when I click "Go Back" or even the "Home" link, it's not there. And under "General Account Information" it says I have "0/5" databases.

I tried finding a way to delete the databases, but there was no option in phpmyadmin.

There were 2 DB's...one for a guestbook and one for a forum. Though the databases did not show up in the SQL manager, nor in the "General Account Information", the guestbook still worked.

I'm not the admin for the server, so I don't have access to the back-end code on the server. Anything I can tell the people that run the site? I think that both they and I are new to the cPanel software, so we're not exactly sure where to go from here.

Stats:

Operating system: Linux
Kernel version: 2.4.20-28.9
Apache version: 1.3.31 (Unix)
PHP version: 4.3.8
MySQL version: 4.0.20-standard
cPanel Build: 9.7.2-CURRENT 11
 

DJDarknez

Member
Aug 23, 2004
6
0
151
Chicago
Not I. Apparently we don't have the "pro" level or whatever. There is nothing under the "Submit a Support Request". Literally. It says "Go Back". That's it.
 

haze

Well-Known Member
Dec 21, 2001
1,550
3
318
What cpanel themes are you all using. Have you tried changing cpanel themes for the account to see if its related? More often than not it is, especially if you are using an older, no longer produced theme.
 

DJDarknez

Member
Aug 23, 2004
6
0
151
Chicago
Well..........the front side of cpanel has changed. So, it's a little different now......

General server information:
Operating system Linux
Service Status Click to View
Kernel version 2.4.20-28.9
Apache version 1.3.31 (Unix)
PERL version 5.8.1
Path to PERL
Path to sendmail
Installed Perl Modules Click to View
PHP version 4.3.8
MySQL version 4.0.20-standard
cPanel Build 9.7.2-CURRENT 11
Theme cPanel X v2.5.0
Documentation Click to View
cPanel Pro 1.0 (RC1)

Edit: Also, keep in mind, I don't have access to the back-end of the cPanel software. I'm being sort of a go-between because the guy who does run the server is just too damn busy.
 
Last edited:

DJDarknez

Member
Aug 23, 2004
6
0
151
Chicago
Anyone? My forums are slowing growing and they're still on a temporary server....
 

DJDarknez

Member
Aug 23, 2004
6
0
151
Chicago
No one, eh? No one can help me? The people who designed the software can't help me? Can't even point me in the right direction? Nothing?
 
C

cPanelBilly

Guest
You will need to contact your host. Without root access tot he server there is nothing we can look at.
 

Limedrink

Member
Dec 30, 2003
14
0
151
I have the same problem after I completed a server migration. When I login to SSH as root and type 'mysql', I get 'ERROR 1045: Access denied for user: '[email protected]' (Using password: YES)'. Tried resetting the password, didn't work. Seems like the password for the SQL server is not being set correctly. Any ideas?


Thanks,

Limedrink.
 

Limedrink

Member
Dec 30, 2003
14
0
151
Problem solved: Force reset your MySQL password to a password without any special characters.

Good luck.


Cheers,

Limedrink.
 

edesignway

Well-Known Member
Dec 4, 2001
96
0
306
I have changed the password and am still encountering this error.

No MySQL databases can be created through cPanel.

If I try to access phpMyAdmin I receive "Wrong username/password. Access denied."

When I type mysql at command, I get

[email protected] [/]# mysql
ERROR 1045: Access denied for user: '[email protected]' (Using password: YES)

Red Hat Enterprise 3
MySQL version 4.0.20-standard
cPanel Build 9.7.2-CURRENT 17
 
Last edited:

Limedrink

Member
Dec 30, 2003
14
0
151
edesignway said:
I have changed the password and am still encountering this error.

No MySQL databases can be created through cPanel.

If I try to access phpMyAdmin I receive "Wrong username/password. Access denied."

When I type mysql at command, I get

[email protected] [/]# mysql
ERROR 1045: Access denied for user: '[email protected]' (Using password: YES)

Red Hat Enterprise 3
MySQL version 4.0.20-standard
cPanel Build 9.7.2-CURRENT 17
That is the same problem I had been encountering. You sure you changed your password to a password without any special characters?


Limedrink.
 

edesignway

Well-Known Member
Dec 4, 2001
96
0
306
I trtied that... I changed that password to aaaa and no luck. EV1 Tech support tried getting on the server and nothing worked for the.

What I did (and I don't recommend this for a live server) is removed the /var/lib/mysql/mysql directory, downgraded and then upgraded MySQL and it is fixed. The only thing I have to do now is add all the users that are supposed to by in the user table.
 

ramprage

Well-Known Member
Jul 21, 2002
655
0
166
Canada
BUMP!

Someone please get this working, it has been broken for a while now.
I've tried the following and nothing has worked.

Reset Mysql local password - does not work
Reset Mysql password - does not work
/scripts/fixcommonproblems - does not work
/scripts/fixmysql - does not work
Updated Cpanel to the latest Stable and Current releases - does not work
Chown root.mysql and mysql.mysql to /var/lib/mysql - does not work

Please provide a solution for this ASAP.