Results 1 to 6 of 6
  1. #1

    cpanel mysql question urgent


    I have created the mysql userid using cpanel interface, but when I try to give the provilegs to database, userID is not showing in the dropdown menu.
    How can I fix? Is there a cpanel sript?

    thanks in advance.

  2. #2
    Join Date
    Feb 2008
    Houston, Texas, USA
    Just in case you're not aware, cPanel appends the cPanel account name to the user you create. For example if you create mysql userid 'user1' under cPanel account 'account1', the user id that cPanel creates becomes account1_user1.

    Either use phpMyAdmin from WHM or select * from mysql.user from the command line to verify the entries.

    UNIXy - Fully Managed Servers and Clusters - Established in 2006
    [ cPanel Varnish Nginx Plugin ] - Enhance LiteSpeed and Apache Performance - Los Angeles | Houston | Atlanta | Rotterdam
    Love to help pro bono (time permitting). joe >

  3. #3
    Try creating a user again. If you still don't see the user listed, do a hard refresh.

    It can be cpanel problem too. so try to change version of cpanel by going to WHM > Update Config and run upcp. If its a cpanel bug changing to different version will fix it.

  4. #4
    Yes, I have manually run /scripts/upcp -force and still same issue. Any other help? Thanks in advance.

  5. #5
    Have you changed version (if stable, change it to release) in WHM > Update Config ?

  6. #6
    Join Date
    May 2009
    What is the mysql version you are using?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts