Skip to main content

Fresh cPanel install - MySQL is Broken

Comments

9 comments

  • cPanelMichael
    Hello :) Did you use any custom settings in your /etc/my.cnf file or make any modifications to MySQL before or after the cPanel installation? Please post the output from the following commands: grep innodb_log_file_size /etc/my.cnf du -s /var/lib/mysql/ib_logfile*
    Thank you.
    0
  • TPMGJustin
    [quote="cPanelMichael, post: 1635681">Hello :) Did you use any custom settings in your /etc/my.cnf file or make any modifications to MySQL before or after the cPanel installation? Please post the output from the following commands: grep innodb_log_file_size /etc/my.cnf du -s /var/lib/mysql/ib_logfile*
    Thank you.
    Hey Michael, Thanks for the quick reply! :) I haven't added anything to the my.cnf. I looked at the file, but haven't modified it. Here are the contents of the my.cnf file. [mysqld] max_connections=500 log-slow-queries open_files_limit=35558
    As instructed, I tried both commands. grep innodb_log_file_size /etc/my.cnf <-- Nothing returned du -s /var/lib/mysql/ib_logfile* 102400 /var/lib/mysql/ib_logfile0 102400 /var/lib/mysql/ib_logfile1
    0
  • cPanelMichael
    Try adding the following line to /etc/my.cnf and see if MySQL restarts: innodb_log_file_size=102400
    If that does not help, please open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome. Thank you.
    0
  • TPMGJustin
    [quote="cPanelMichael, post: 1635691">Try adding the following line to /etc/my.cnf and see if MySQL restarts: innodb_log_file_size=102400
    If that does not help, please open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome. Thank you.
    Hey Michael, Unfortunately that didn't work. Here is the number to the ticket I created. 4897175
    0
  • JaredR.
    Friendly Moderator Note I removed the link to the ticket; we do not advise posting it in a public forum. Also, our ticket system does not use the same URLs on our end, as on your end, and we actually cannot use the URL you receive, so it is not useful to us. All we need in the forum, or when referring to another ticket in a ticket, is the ticket number. :)
    0
  • TPMGJustin
    Re: Friendly Moderator Note Gotcha, Thanks for letting me know Jared!
    0
  • cPanelMichael
    To update, the issue was resolved after attempting to reinstall MySQL and verifying the MySQL root password did not use illegal characters. Thank you.
    0
  • supportmwm
    [quote="cPanelMichael, post: 1636891">the issue was resolved after attempting to reinstall MySQL
    Hello Michael, I have been having a similar issue (I have mistakenly replaced "mysql" DB with a copy from another server - how silly hmm). I have been doing rounds of how can I do a fresh re-install and could not find anyway. Hope you can help me here? Can you give me commands/steps to perform this? I do not have any important DBs to backup so data loss is not an issue. Thanks.
    0
  • storminternet
    You can reset the mysql installation as mentioned here
    0

Please sign in to leave a comment.