Results 1 to 6 of 6
  1. #1

    mysql root authentication errors

    for some reason any cpanel application that needs root access to mysql is not working and fails with a wrong username/password error. I am able to connect via shell no problem at all using mysql -p and then entering hte password, but any application/script that accesses mysql is failing.

  2. #2
    Join Date
    Mar 2003
    Location
    California USA
    Posts
    13,294
    check /root/.my.cnf make sure it has the correct pass
    Steven Ciaburri | Industry's Best Server Management - Rack911.com
    Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
    Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
    FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance

  3. #3
    there is no password defined in /etc/my.cnf , should there be?

  4. #4
    Hello,

    /etc/my.cnf should bear the mysql root password. Otherwise the root will not get connected to mysql. The solution for this problem is to run this script:

    /scripts/mysqlup --force

    This will re-install mysql fully without the loosing your data. All the databases remains intact.

    Thank you.

    Regards,

  5. #5
    Join Date
    Mar 2003
    Location
    California USA
    Posts
    13,294
    hostech support you are wrong.



    there should be a file in /root

    named .my.cnf with a period in the front of it just like this:

    /root/.my.cnf

    that has the contents:

    [client]
    user=root
    password=yourpassword


    putting the root password in the /etc/my.cnf is a security risk hosttechsupport.
    Steven Ciaburri | Industry's Best Server Management - Rack911.com
    Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
    Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
    FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance

  6. #6
    ah, I was looking in /etc/ for .my.cnf, found it in /root/

Posting Permissions

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