The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Please Help Me.. Phpmyadmin And Cpanel Problem

Discussion in 'Database Discussions' started by mawerik, Mar 15, 2007.

  1. mawerik

    mawerik Registered

    Joined:
    Mar 15, 2007
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    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.
     
  2. mawerik

    mawerik Registered

    Joined:
    Mar 15, 2007
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    i need a very quick solution please help me friends.

    thank you.
     
  3. learnos

    learnos Registered

    Joined:
    Mar 2, 2007
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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?
     
  4. mawerik

    mawerik Registered

    Joined:
    Mar 15, 2007
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1


    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.
     
  5. dan_nl

    dan_nl Registered

    Joined:
    Mar 16, 2007
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    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?
     
  6. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,482
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Try changing the password. Some characters will not work in a password for cpanel.
     
    MaraBlue likes this.
  7. mawerik

    mawerik Registered

    Joined:
    Mar 15, 2007
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    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.
     
  8. dan_nl

    dan_nl Registered

    Joined:
    Mar 16, 2007
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    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.
     
  9. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    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.
     
  10. kdarray

    kdarray Well-Known Member

    Joined:
    Apr 13, 2006
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    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.
     
  11. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    United Kingdom
    For starters update cPanel on your system

    # /scripts/upcp

    Latest Stable is: 10.9.0-STABLE_7965
     
  12. oinkmedia

    oinkmedia Well-Known Member

    Joined:
    Jul 5, 2003
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    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!?
     
  13. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    526
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    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
     
  14. oinkmedia

    oinkmedia Well-Known Member

    Joined:
    Jul 5, 2003
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    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!
     
Loading...

Share This Page