Please Help Me.. Phpmyadmin And Cpanel Problem

mawerik

Registered
Mar 15, 2007
4
0
151
Hello...

we could not solve our problem with mysql.

it effects us in very badway. We have to solve this problem.

Problem is:

- When a user tries to access to phpMyadmin it gives an error like below :
Welcome to phpMyAdmin 2.9.0.2


Wrong username/password. Access denied.


- When i reboot the mysql it gives an error like below :

/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' mysql has failed, please contact the sysadmin (result was "mysql has failed").



- I cant see the databases in users control panels. (cPanel)

For an Example User Panel:
MySQL Databases NA / 2




However i tried many ways i could not solve this problem. And I dont have any thing more to do. Now I need a quick solution... Please HELP! immediately.
 

learnos

Registered
Mar 2, 2007
4
0
151
Cheney WA
here is the server hosted?

To get the fastest response, you should put in a trouble ticket with the company that you lease the server from.

Have you entered a trouble ticket?

Is this a VPS or Dedicated?

Do you have also have a Virtuozzo Power Panel?
 

mawerik

Registered
Mar 15, 2007
4
0
151
To get the fastest response, you should put in a trouble ticket with the company that you lease the server from.

Have you entered a trouble ticket?

Is this a VPS or Dedicated?

Do you have also have a Virtuozzo Power Panel?


i have :

WHM 10.8.0 cPanel 10.9.0-S119
Fedora i686 - WHM X v3.1.0


my company could not solve this problem. :(

now i dont know but will i do. please help ME!.. :( i can provide every information about my server.
 

dan_nl

Registered
Mar 16, 2007
4
0
151
Well, maybe this will help narrow down where the problem may exist:

Is this a vps server with one website or many?
Is this one website hosting account?

Is this the first time you installed the db on this webserver?
How did you create the MySQL db?
Was the db creation successful?
Did you add a user to the db?
 

mawerik

Registered
Mar 15, 2007
4
0
151
my server is a dedicated server.

mySQL Server and Cpanel was working fine. But it's not working at this time.

there aren't any mysql databases in user cpanel control panels and i cant access to the phpMyadmin from WHM and user panels. I'm getting this error message from phpmyadmin


Welcome to phpMyAdmin 2.9.0.2


Wrong username/password. Access denied.


P.S.: Mysql is working fine on server but mysql service does'nt working on WHM. mysql service is red on WHM (Service Status) old mysql databases working on web sites. but databases aren't showing in user control panels (cPanel).

i think WHM and cPanel don't connect to the mysql and phpmymin services.

please help me... :(

Best Regards.
 

dan_nl

Registered
Mar 16, 2007
4
0
151
I'm surprised that your server provider isn't able to help you out ...

Here's a desperate idea:
1. Backup your website(s), mail, scripts etc. I'm assuming there's no db info to backup.
2. Note all of the config info in WHM and in cPanel.
3. Ask your server provider to reformat and re-install your server from scratch.
4. Restore your website, mail, scripts.
5. Try creating a MySQL db via cPanel.
 

jayh38

Well-Known Member
Mar 3, 2006
1,213
0
166
Also try setting the root password for mysql in your whm
SQL Services>MySQL Root Password

Once you get into phpmyadmin via your root WHM, select the option to reload
the privileges table.
 

kdarray

Well-Known Member
Apr 13, 2006
81
0
156
Washington
Try this

hi mawerik,

i had the same problem the other day after moving a bunch of sites from a fedora server to a centos box. could not get in whm/sql/myphpadmin and sites could not access myphpadmin either.

i changed my root sql password. then flushed the priviledge tables and everything worked.

i had a bit of trouble with horde and squirrel mail but forced a cp update and that fixed those too. /scripts/upcp --force

hope this might help.
 

oinkmedia

Well-Known Member
Jul 5, 2003
49
0
156
SW London (UK)
I am experiencing a similar problem but I am already using the latest stable cPanel version. I can access phpMyAdmin via the root user but any other user cannot!?
 

katmai

Well-Known Member
Mar 13, 2006
564
3
168
Brno, Czech Republic
try putting this in /etc/my.cnf and then do a service mysql restart

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=500
max_connections=1000
interactive_timeout=10
wait_timeout=30
connect_timeout=10
thread_cache_size=96
key_buffer=32M
join_buffer=1M
max_allowed_packet=8M
table_cache=1024
record_buffer=1M
sort_buffer_size=1024K
read_buffer_size=1024K
max_connect_errors=10
thread_concurrency=8
myisam_sort_buffer_size=64M
server-id=1
log-slow-queries
long_query_time = 5

[mysql.server]
user=mysql

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout
 

oinkmedia

Well-Known Member
Jul 5, 2003
49
0
156
SW London (UK)
Thanks for the suggestion. It turns out this was caused by non-letter/number characters in my cPanel username. Changing the password back to [a-z][A-Z][0-9] fixed the problem!